Getting Error in the aspose code

[AjeeshJohn]

hi

i got the following code from aspose team

MemoryStream ms = new MemoryStream();

ms.Write(bytes, 0, bytes.Length);

ms.Position = 0;

Workbook workbook = new Workbook(ms);

but when am using this code am getting an error "Cannot find central directory" in the following line

" Workbook workbook = new Workbook(ms);" please help to resolve this problem

[tahir.manzoor]

Hi Ajeesh,

Please post your queries at Aspose.Cells forum which are related to MS Excel. Please put your question in the reply of Aspose.Cells team.

[shakeel.faiz]

Hi,

Please check the complete running sample code below.

It reads the sample source file into byte array, you will read it from database. Then it creates a memory stream object and then workbook object and prints “Welcome Aspose!” in cell A1 and write the output xlsx file.

I have also attached the source and output xlsx files for your reference.

You can also see the screenshot attached by me.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\source.xlsx”;


//Read all bytes into a byte array

byte[] bytes = System.IO.File.ReadAllBytes(filePath);


//Create a memory stream

MemoryStream ms = new MemoryStream(bytes);

ms.Position = 0;


//Create a workbook object

Workbook workbook = new Workbook(ms);


//Do some work on workbook object of your choice, i will print Welcome Aspose in cell A1

workbook.Worksheets[0].Cells[“A1”].PutValue(“Welcome Aspose!”);


//Save the workbook

workbook.Save(filePath + “.out.xlsx”, SaveFormat.Xlsx);