xml spreadsheet issue while exporting data

See more:

C#

C#4.0

Hi There,

I have created a program which will export large data say 10 million rows to excel, text or other formats.
Now I am finding problem with excel export.

I have huge data to be exported in excel. I am using “XML Spreadsheet” where I will construct xml file and write into excel file using stream writer.

Every thing goes fine and exported successfully but when I try to open file it will not show the file. It will show message “problem during loading xls file” and that’s all. I check xls log also which is like that

XML Spreadsheet Warning in Table
REASON: String too long
ACTION: Truncating string
FILE: C:\Users\sunder\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO\FFB7679E.xls
GROUP: Row
TAG: Cell

XML Spreadsheet Warning in Table
REASON: String too long
ACTION: Truncating string
FILE: C:\Users\ sunder \AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO\FFB7679E.xls
GROUP: Row
TAG: Cell

I feel there are no issues with coding. Perhaps may be a cell will not allow more characters or some other issue. May be the data which I am storing in cell is not valid or some other issue.

But here I am restricting a cell should not have more than 1000 characters.

Anyone faced this issue before. I am kind of no brainer now?

Thanks