URGENT- Unable to read Data-SPIRE XLS Export

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

URGENT- Unable to read Data-SPIRE XLS Export

Postby contactkx » 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

Postby Flash » 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

We use Spire.DataExport

Postby contactkx » 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

Re: URGENT- Unable to read Data-SPIRE XLS Export

Postby arif.budiman » 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

Re: URGENT- Unable to read Data-SPIRE XLS Export

Postby Justin Weng » 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

Who is online

Users browsing this forum: No registered users and 1 guest