导出阵列列表到React JS中的Excel XLSX

Question

我正在尝试将表导出到Excel文件 ，所以我在获取从数组转换为excel的数据后创建了一个函数，我工作了，但并未导出所有数据 这是一个示例 在这里 因此，如您所见，最后三列是空的，我认为问题是日期是数组数据，但我不知道 这是我的代码：

import {
    GridToolbarContainer,
    gridVisibleSortedRowIdsSelector,
    gridFilteredSortedRowIdsSelector,
    gridVisibleColumnFieldsSelector
} from "@mui/x-data-grid";


const CustomToolbar = () => {

    const apiRef = useGridApiContext();
    const getFilteredRows = ({ apiRef }) => gridVisibleSortedRowIdsSelector(apiRef);
    const handleExport = (options) => apiRef.current.exportDataAsCsv(options);
    const fileType = "application/vnd.ms-excel;charset=utf-8";
    const fileExtension = ".xlsx";
    const fileName = "myfile";
    const buttonBaseProps = {
        color: "primary",
        size: "small",
    };

    // const arrayToExcel = (a) => {}
    const Export = (a, fileName) => {
        const ws = XLSX.utils.json_to_sheet(a);
        const wb = { Sheets: { data: ws }, SheetNames: ["data"] };
        const excelBuffer = XLSX.write(wb, { bookType: "xlsx", type: "array" });
        const data = new Blob([excelBuffer], { type: fileType });
        FileSaver.saveAs(data, fileName + fileExtension);
    };

    const myfiltredRows = (a) => {
        const filteredSortedRowIds = gridFilteredSortedRowIdsSelector(apiRef);
        const visibleColumnsField = gridVisibleColumnFieldsSelector(apiRef);
        let data = filteredSortedRowIds.map((id) => {
            const row = {};
            visibleColumnsField.forEach((field) => {
                row[field] = apiRef.current.getCellParams(id, field).value;
            });
            return row;
        });
        let m = JSON.stringify(data, null, 2);
        data.map((d) => { (delete d._check_, delete d.action) })
        console.info(data)
        Export(data, fileName)
        // arrayToExcel(data)
    };

    return (
        <GridToolbarContainer>
            <Button
                {...buttonBaseProps}
                onClick={(e) => myfiltredRows(getFilteredRows)
                }> Filtered rows</Button>
        </GridToolbarContainer>
    );
}

这是将我的数组转换为Excel的函数

const Export = (a, fileName) => {
    const ws = XLSX.utils.json_to_sheet(a);
    const wb = { Sheets: { data: ws }, SheetNames: ["data"] };
    const excelBuffer = XLSX.write(wb, { bookType: "xlsx", type: "array" });
    const data = new Blob([excelBuffer], { type: fileType });
    FileSaver.saveAs(data, fileName + fileExtension);
};