Can ClosedXML be used with Silverlight (5)?

Jul 30, 2012 at 5:49 PM

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.

Signitures:

public String openXlsxSpreadsheetAsCsv(String filename)

public FileStream SaveCsvAsXlsxSpreadsheet(String csvData)

Thanks!!

Coordinator
Jul 30, 2012 at 6:11 PM

Nope, this library uses DocumentFormat.OpenXml.dll which is not targeted for Silverlight.

Jul 30, 2012 at 7:35 PM

True that! I understand that this is not going to be able to be used directly by silverlight but what about on the server side using WCF web services between the SL5 UI and ClosedXML/OpenXML dlls?

Coordinator
Jul 30, 2012 at 8:05 PM

Sure, just reference both libraries in your service and you're good to go.