Hi,
I have upgraded my application from Apose.Cells 4.7.1.23 to 7.0.2.0 to make use of xlsx formats. We are having trouble saving 2007 xlsx formats to a memory stream. After saving the workbook to a memory stream we are getting around 5k where is should be 23k. This prevent us from opening the workbook again from the memory stream. Below is code from my test harness (VS2010 .net 3.5 console app). Attached is the Excel workbook we’re testing.
//Load xlsx file
LoadOptions loadOptions = new LoadOptions(LoadFormat.Xlsx);
Workbook workbook = new Workbook(@“C:\Development\AsposeCellsTest\Model_80.xlsx”, loadOptions);
//Convert to bytes array
MemoryStream memorystream = new MemoryStream();
workbook.Save(memorystream, SaveFormat.Xlsx);
//Get bytes
byte[] bytes = memorystream.ToArray();
memorystream.Dispose();
memorystream.Close();
//output the bytes
Console.WriteLine(string.Format(“Byte length: {0}”, bytes.Length));
//convert back to workbook
MemoryStream ms2 = new MemoryStream(bytes);
workbook = new Workbook(ms2, loadOptions);
ms2.Dispose();
ms2.Close();
Console.ReadLine();
Help pls. I have tried various save and load options. This all works fine for xls (97-2003) files if load options and save options removed.