Import and Export Excel – What is the best library? [closed]

by

I’m going to throw my hand in for flat csv files, if only because you’ve got the greatest control over the code. Just make sure that you read in the rows and process them one at a time (reading the document to the end and splitting will eat up all of your memory – same with writing, stream it out).

Yes, the user will have to save-as CSV in excel before you can process it, but perhaps this limitation can be overcome by training and providing clear instructions on the page?

Finally, when you export to the customer, if you set the mime type to text/csv, Excel is usually mapped to that type so it appears to the user to be ‘an Excel file’.

More Related Contents:

  1. Format excel column to decimal doing export from c#
  2. How do I export to Excel?
  3. Format an Excel column (or cell) as Text in C#?
  4. How to write some data to excel file(.xlsx)
  5. How to export a JQgrid data to Excel using c#?
  6. Export DataTable to Excel File
  7. EPPlus number format
  8. Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’
  9. Read excel file from a stream
  10. Is csv with multi tabs/sheet possible?
  11. Can I specify a custom location to “search for views” in ASP.NET MVC?
  12. How can I get a list of users from active directory?
  13. Has an event handler already been added?
  14. How to dynamically create ASP.net controls within dynamically created ASP.net controls
  15. Call non-static method in server-side from client-side using JavsScript
  16. Currency format for display
  17. Help with a OleDB connection string for excel files
  18. Multi-select dropdown list in ASP.NET
  19. How to access page controls inside a static web method? [duplicate]
  20. MemoryStream – Cannot access a closed Stream
  21. How can I get the value of a session variable inside a static method?
  22. Determine OS using Environment.OSVersion [duplicate]
  23. Prevent textbox autofill with previously entered values
  24. How can I secure passwords stored inside web.config?
  25. How to change CurrentCulture at runtime?
  26. How to return a PDF from a Web API application
  27. openxml spreadsheat save-as
  28. How to return XML in ASP.NET?
  29. iTextSharp international text
  30. Import Excel to Datagridview

Leave a Comment