SaveAs corrupt excel file

Thread ID:	Created:	Updated:	Platform:	Replies:
143545	Mar 26,2019 10:31 AM UTC	Mar 27,2019 10:09 AM UTC	ASP.NET Core - EJ 2	2

Subscribe to this post

Tags: XlsIO

Maxim Konoplyanik

Asked On March 26, 2019 10:31 AM UTC

SaveAs call corrupt excel file, even if i don't change anything. Attached excel error message.

Attachment: message_a1f31c74.rar

Reply | Reply with quote

Maxim Konoplyanik

Replied On March 26, 2019 10:37 AM UTC

using (var stream = new FileStream(filepath, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite))

{

stream.Position = 0;

var Workbook = application.Workbooks.Open(stream);

Workbook.SaveAs(stream);

}

Something like this

Reply | Reply with quote

Karthikeyan Chandrasekar [Syncfusion]

Replied On March 27, 2019 10:09 AM UTC

Hi Maxim,

This is an usage level issue. In the given code snippet we can see that you are using the same stream to read and write the excel file, so the already opened stream has been overwritten which leads to corruption. (i.e) InputStream object is used to load the excel file and the stream is used for saving the excel file.

In order to resolve the issue , clear the stream before saving using SetLength() method. Below we have shared the code snippet to resolve this.

Code snippet :

stream.Position = 0;

IWorkbook workbook = application.Workbooks.Open(stream);

stream.SetLength(0);

workbook.SaveAs(stream);

Please let us know if this helpful.

Regards,

Karthikeyan

Reply | Reply with quote

CONTACT US

SaveAs corrupt excel file

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US