FortuneExcel is an .xlsx import/export plugin for FortuneSheet.
For best results, import and export a single sheet at a time. Although you can force FortuneExcel to handle multiple sheets, certain configurations may break.
- Install the package:
npm i @corbe30/fortune-excel- Add import/export toolbar item in fortune-sheet
<ImportHelper />is a hidden component and only required when usingimportToolBarItem().
import { ImportHelper, importToolBarItem, exportToolBarItem } from "fortune-excel";
function App() {
const workbookRef = useRef();
const [key, setKey] = useState(0);
const [sheets, setSheets] = useState(data);
return (
<>
<ImportHelper setKey={setKey} setSheets={setSheets} sheetRef={workbookRef} />
<Workbook
key={key} data={sheets} ref={workbookRef}
customToolbarItems={[exportToolBarItem(workbookRef), importToolBarItem()]}
/>
</>
);
}Developers of FortuneSheetExcel: