FortuneExcel is an .xlsx and .csv import/export plugin for FortuneSheet / ProsperaSheet.

1. Install the package:

   npm i @corbe30/fortune-excel

2. Import/export toolbar item (code example)

   Note: <FortuneExcelHelper /> is a hidden component.

   import { FortuneExcelHelper, importToolBarItem, exportToolBarItem } from "@corbe30/fortune-excel";
   
   function App() {
     const sheetRef = useRef();
     const [key, setKey] = useState(0);
     const [sheets, setSheets] = useState(data);
   
     return (
       <>
         <FortuneExcelHelper
           setKey={setKey}
           setSheets={setSheets}
           sheetRef={sheetRef}
           config={{ // default = all values are true
             import: { xlsx: true, csv: true },
             export: { xlsx: true, csv: true },
           }}
         />
         <Workbook
           key={key} data={sheets} ref={sheetRef}
           customToolbarItems={[importToolBarItem(), exportToolBarItem()]}
         />
       </>
     );
   }

3. Programmatic import/export (code example)

   import { transformFortuneToExcel } from "@corbe30/fortune-excel";
   
   const manualExport = async () => {
     const exportedFile = await transformFortuneToExcel(
       sheetRef.current,
       "xlsx", // or "csv"; default = "xlsx"
       true // start automatic download; default = true
     );
     console.log("Exported file data:", exportedFile);
   };
   
   <button onClick={manualExport}>Export</button>

   import { transformExcelToFortune } from "@corbe30/fortune-excel";
    
   const manualImport = async (event) => {
     await transformExcelToFortune(
       event.target.files[0], // file type (csv/xlsx) is automatically identified
       setSheets,
       setKey,
       sheetRef.current
     )
   }

• @Corbe30

Developers of FortuneSheetExcel:

• @wbfsa
• @wpxp123456
• @Dushusir
• @xxxDeveloper
• @mengshukeji

Export support:

• Orleans9 - article

1. Install node v20.17.0
2. npm run prepare
3. npm run build-storybook
4. npm run storybook

MIT