extended-salmon
extended-salmon•2y ago

useImport Excel

Hi there! new to the refine.dev can somebody help me here, general design let's say, how can I do an excel import soemthing like useImport csv ? * If somebody would have done that already? * Should I write a pre / js code first to convert the exce;l into csv (there are sometimes interoperable anyways, I know) and then use useImport ? * Or something else ?
3 Replies
deep-jade
deep-jade•2y ago
Hey @akmanocha you can check out the documentation for useImport here https://refine.dev/docs/api-reference/core/hooks/import-export/useImport/ Also UI packages has ImportButton with same functionality (uses useImport under the hood) Here is the one for the Ant Design https://refine.dev/docs/api-reference/antd/components/buttons/import-button/ We also have an example for import that you can check out here https://refine.dev/docs/examples/import-export/ useImport has a prop mapData which allows you to map/transform the imported data to match your API 🚀 Hope this helps 🙏
useImport | refine
useImport hook API references of @pankod/refine-core
Import | refine
is compatible with the useImport hook and is meant to be used as it's upload button.
Import-Export | refine
refine allows you to export and import your data as CSV files. You can quickly do CSV import and export operation with refine by creating model operations on the CSV data.
extended-salmon
extended-salmon•2y ago
Hi @aliemirs that's helpful But I have gone high level over them. What I wanted to confirm or seek help is before going deep does it support CSV only or Excel too? Which is my main use case
deep-jade
deep-jade•2y ago
Parsing is done using papaparse. As far as i know, it does not support excel but not sure 🤔
More Posts
Compiled Error when update refine antdI just update refine antd from refine update command and got this error.How to use generic search with strapi-v4 and useTableHi 👋 I am listing the customers from my database with useTable hook from AntD and Strapi-v4 as datHello to everyone!I would like to understand if it's possible to add filter params to URL in the List view. I want touseSelect fetch on scrollit's me again!) How to use scroll pagination with select via useSelect hook? Maybe you have any exammake a new call api after the x-locale changeHello i'm currently making an app with refine and i have implement i18n. I also have an API which aldeleting successfully but showing errorerror notification on settledNavigation not properly working if the resource has custom routeHi, I am using react-router-6, We have configured a resource with a route called '/config/units'. whhasura data provider - pass token in header before requestI've configured my hasura endpoint so that an Authrization Header must be populated with a value (i.