Until now I was using epplus for excel file reading writing - standalone application. Bt I've moved to web version, is it possible to read excel file or say 'to manipulate excel file jQuery/JavaScript/AJAX.
1 Answer
Yes, you can do this in similar fashion.
- Upload an excel File
- Read the uploaded file and return the data and bind a grid.
- Allow the user to modifiy the data
- Post the data back (or use ajax to post the data)
- Write the new data in a new excel File and Download it.
You can use the same EPPlus library or NPOI library to read/write. Also you can use Excel DataReader to read the excel file.
2 Comments
Annadate Piyush
that's for application specific...that would be same for web version?
sudhansu63
Usually in the web version its prefered not to use any com component. If your existing code is not using and com component you can reuse the same for web version.