我试图将我的表导出到Excel文件，所以我在获取从数组转换到Excel的数据后创建了一个函数，我工作了，但它并没有导出所有数据这是一个正在获取here的例子，所以你可以看到最后三列是空的，我认为问题是日期是数组数据，但我不知道这是我的代码：

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);
  };