Importing/Processing CSV/Excel File in WiseJ

0
0

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,

  • You must to post comments
0
0

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

  • You must to post comments
0
0

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?

 

  • Frank (ITG)
    Did you try Excel Interop if Office is installed on your server or a third party product like ClosedXML as suggested in my first linked thread ? There are a lot more tools in the .NET environment that could fit into your scenario but it´s a bit out of scope here. Best regards, Frank
  • You must to post comments
0
0

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

  • You must to post comments
Showing 3 results
Your Answer

Please first to submit.