I see this ClosedXML is based on OpenXML dll from microsoft. Is this correct?
I have my data in csv format on the server side already. I want to be able to put my csv data into a xlsx file stream and then save to users machine on client side.
I also have data in csv format imported to my object and used within a grid control on UI side. So I need to be able to read the xlsx data and put into csv format to import.
Can this be done with either OpenXML or ClosedXML?
Right now I can import and export to xxxxx.csv files on client side. (Sliverlight 5)
It would be nice to have some functions that openXlsxSpreadsheetAsCsv() and saveCsvAsXlsxSpreadsheet()... Most common need since most developers should be able to read and write csv data.
public String openXlsxSpreadsheetAsCsv(String filename)
public FileStream SaveCsvAsXlsxSpreadsheet(String csvData)