Serialize a Spreadsheet?

I didn't explain myself very well.

The functions you describe do a good job of creating me a file which contains all my spreadsheet information.

But I can't save a file - just a string. I would like that string to contain everything about the spreadsheet, so my users can click an re-open the spreadsheet (and I can updatae it with some new data).  Then they would see all the right columns, conditional formatting, charts etc.

I was hoping that maybe there was an XML format which described the Workbook and its worksheets, which I can save as a (zipped) string. Then deserilize it to re-open the sheet.

Can I serialize a Workbook ?

Hi Ian,

We do not have a provider that serializes this to XAML. The best you can do is to export the workbook to a byte array and then convert it to a base64 string: 

var provider = new XlsxFormatProvider();
byte[] result = provider.Export(workbook);

var str = Convert.ToBase64String(result);
byte[] temp_backToBytes = Convert.FromBase64String(str);

Should you have any other questions do not hesitate to ask.

Ah - that's a a good idea! I'll try that.

Thanks

This worked really well! 

Final line was:

Dim wb As Workbook = provider.Import(temp_backToBytes)

..to make the bytes back into a Workbook instance.

And it's fast too!

Thanks