FortuneExcel

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

Usage

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 (
<>
setKey={setKey}
setSheets={setSheets}
sheetRef={sheetRef}
config={{ // default = all values are true
import: { xlsx: true, csv: true },
export: { xlsx: true, csv: true },
}}
/>
key={key} data={sheets} ref={sheetRef}
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);
};

Export
`
`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
)
}
`

Authors and acknowledgment

- @Corbe30

Developers of FortuneSheetExcel:
- @wbfsa
- @wpxp123456
- @Dushusir
- @xxxDeveloper
- @mengshukeji

Export support:
- Orleans9 - article

Contribution


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

License

MIT