Hello,
A fundamental task in development is data import from CSV/Excel files. I searched the forum but couldn’t find any thread on this topic. Just wondering, if it is possible? A sample code would be highly appreciated!
Thanks,
I used EPPlus when I worked with VWG so I am sure it will work with Wise J
https://github.com/JanKallman/EPPlus
Does not require Microsoft Interop to work
Hope this helps
Ewan
Well, I gone through these threads. I wanted to process uploaded files in excel/csv by reading all records (say customer records into Customer table) & importing them into database. How can I read an excel file using WiseJ or any 3rd party extension?
Hi Abaid,
here is some discussion about working with Excel files:
https://wisej.com/support/question/microsoft-office-interop-excel-application
Apart from that it depends on what your goal is:
Provide some server generated data for the client to Download ?
Then our Download sample might come in handy:
https://github.com/iceteagroup/wisej-examples/tree/2.0/Download
Have the client Upload some data that is then processed on the server ?
In this case please refer to our Upload sample:
https://github.com/iceteagroup/wisej-examples/tree/2.0/UploadFiles
Best regards
Frank
Please login first to submit.