exceljs如何动态创建数据

Question

我正在尝试下载json到excel。我需要在单元格a1中添加图像，然后将标题加粗。

我有下面的代码。我从谷歌，但我有数据，我想动态填充(头太)。我正在努力想办法。(datablerows有我的data - json数组数组)。我还没有看到如何加粗标题和如何添加图像。

import React, { useContext } from 'react';
import ExcelJS from 'exceljs';
import AlertContext from '../../AlertContext';
import { errorAlert } from '../Alert';
const useFileExportToExcel = <T extends object>() => {
const { setAlert } = useContext(AlertContext);
const workbook = new ExcelJS.Workbook();
workbook.addWorksheet('sheet1');
const worksheet = workbook.getWorksheet('sheet1');
worksheet.columns = [
{ header: 'ID', key: 'id' },
{ header: 'fads', key: 'createdAt' },
{ header: 'fadsf', key: 'name' },
];
worksheet.addRows([
{
id: 'f001',
createdAt: 1629902208,
name: 'fasdf',
},
{
id: 'f002',
createdAt: 1629902245,
name: 'fasd',
},
{
id: 'f003',
createdAt: 1629902265,
name: 'fdafads',
},
]);
return (dataTableRows: T[], fileName: string) => {
try {
// const blob = new Blob([xls]);
workbook.xlsx.writeBuffer().then(data => {
const blob = new Blob([data], {
type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
});
const a = window.document.createElement('a');
const downloadUrl = window.URL.createObjectURL(blob);
a.href = downloadUrl;
a.download = `${fileName}.xlsx`;
document.body.appendChild(a);
a.click();
document.body.removeChild(a);
window.URL.revokeObjectURL(downloadUrl);
});
} catch (err) {
setAlert(errorAlert('An error occured during export'));
}
};
};
export default useFileExportToExcel;

Answer 1

const rowHeader = [
{ key: 'xxx' },
{ key: 'adsff' },
{ key: 'ff' },
{ key: 'ffff' },
{ key: 'sdfasdf' },
{ key: 'fasdfads' },
{ key: 'fasdfasdf' },
{ key: 'fasdfadf' },
{ key: 'fasdfawsdft' },
];
const imageId2 = workbook.addImage({
base64: myBase64Image,
extension: 'png',
});
worksheet.addImage(imageId2, 'A1:D3');
worksheet.mergeCells('A1:D3');
worksheet.addRow({});
const col: string[] = [];

rowHeader.forEach(header => {
col.push(header.key);
});
const columnHeaders: string[] = Object.values(col);
worksheet.getRow(5).values = columnHeaders;
worksheet.getRow(5).font = {
name: 'Arial Black',
bold: true,
};
worksheet.columns = rowHeader;
worksheet.addRows(dataTableRows);

workbook.xlsx.writeBuffer().then(data => {
const blob = new Blob([data], {
type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
});
const a = window.document.createElement('a');
const downloadUrl = window.URL.createObjectURL(blob);
a.href = downloadUrl;
a.download = `${fileName}.xlsx`;
document.body.appendChild(a);
a.click();
document.body.removeChild(a);
window.URL.revokeObjectURL(downloadUrl);
});