Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Mon Jun 02, 2008 8:07 am

I export file using the Spire.XLS in my ASP.NET 2.0 WEB App.
Get the following error;
1. Unable to read the file.
2. "Errors were detected in 'Stream.xls,' but Microsoft Excel
was able to open the file by making the repairs listed below. Save
the file to make these repairs permanent.

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have lost or corrupted."

This happens only when the file to be exported contains following data-
"DFAFTAFAFAATTAFTDDDDFTAAFFTAAAFDDADTDATDFDAAAFFDDTDTDFFTADTTDFTFF"
"AATAFDFATDDTTTTDTAFTATTTDAAFTADFDTFFDADFDATTFTFATTATDTTDFFDAFAFFD"

This is a 65 character string obtained after encoding using a 3rd party interop library.This field is then stored in database table and the export calls this file's data from database


I Have used the following code to export-

Dim dtExportTemp As DataTable = GetExportData()

Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition", "attachment; filename=Stream.xls")
Me.ExcelCellExport1 = New Spire.DataExport.XLS.CellExport
ExcelCellExport1.Register("User1", "password1")
ExcelCellExport1.DataSource = Spire.DataExport.Common.ExportSource.DataTable
ExcelCellExport1.DataTable = dtExportTemp
Response.Buffer = True

ExcelCellExport1.SaveToHttpResponse("Stream.xls", Response)


Can anyone please guide me??

Regards

contactkx
 
Posts: 3
Joined: Mon Jun 02, 2008 7:34 am

Tue Jun 03, 2008 7:28 am

Hello,

Could you tell us that you use Spire.DataExport or Spire.XLS ?
User avatar

Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm

Tue Jun 03, 2008 7:55 am

Hi, We are using Spire.DataExport.. with ASP.NET Application
Also, this problem does not occur in my local machine ; It occurs on all other production servers(Local server & Live SERVER)

Awaiting a reply soon.
Regards

contactkx
 
Posts: 3
Joined: Mon Jun 02, 2008 7:34 am

Sat Jun 18, 2011 6:06 am

any clue how to fix this issue ?

Thanks.

arif.budiman
 
Posts: 6
Joined: Mon Jun 13, 2011 4:02 am

Mon Jun 20, 2011 5:53 am

Dear arif.budiman,
Thanks for your inquiry.
The same answer to http://www.e-iceblue.com/forum/viewtopic.php?f=1&t=2357&p=3564#p3564.
Please upload your code and file.
Justin
Technical Support / Developer,
e-iceblue Support Team
User avatar

Justin Weng
 
Posts: 110
Joined: Mon Mar 28, 2011 5:54 am

Return to Spire.XLS