An Excel import/export import library for FortuneSheet
npm install @corbe30/fortune-excel

FortuneExcel is an .xlsx and .csv import/export plugin for FortuneSheet / ProsperaSheet.
1. Install the package:
``js`
npm i @corbe30/fortune-excel
2. Import/export toolbar item (code example)
> Note: is a hidden component.`
js
import { FortuneExcelHelper, importToolBarItem, exportToolBarItem } from "@corbe30/fortune-excel";
function App() {
const sheetRef = useRef();
const [key, setKey] = useState(0);
const [sheets, setSheets] = useState(data);
return (
<>
setSheets={setSheets}
sheetRef={sheetRef}
config={{ // default = all values are true
import: { xlsx: true, csv: true },
export: { xlsx: true, csv: true },
}}
/>
customToolbarItems={[importToolBarItem(), exportToolBarItem()]}
/>
>
);
}
`
3. Programmatic import/export (code example)
`js
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);
};
``
js`
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
4. npm run build-storybook
5. npm run storybook`