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](https://github.com/Corbe30/FortuneExcel/tree/main/src/stories/Plugin.tsx))
> 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 (
<>
);
}
```
3. Programmatic import/export ([code example](https://github.com/Corbe30/FortuneExcel/tree/main/src/stories/Manual.tsx))
```js
import { transformFortuneToExcel } from "@corbe30/fortune-excel";
const manualExport = async () => {
const exportedFile = await transformFortuneToExcel(
sheetRef,
"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
)
}
```
## Authors and acknowledgment
- [@Corbe30](https://github.com/Corbe30)
Developers of [FortuneSheetExcel](https://github.com/zenmrp/FortuneSheetExcel):
- [@wbfsa](https://github.com/wbfsa)
- [@wpxp123456](https://github.com/wpxp123456)
- [@Dushusir](https://github.com/Dushusir)
- [@xxxDeveloper](https://github.com/xxxDeveloper)
- [@mengshukeji](https://github.com/mengshukeji)
Export support:
- [Orleans9](https://blog.csdn.net/zinchliang) - [article](https://blog.csdn.net/zinchliang/article/details/120262185)
## Contribution
1. Install node v20.17.0
3. `npm run prepare`
4. `npm run build-storybook`
5. `npm run storybook`
## License
[MIT](http://opensource.org/licenses/MIT)
