hello everybody!i want to export datatable to excel,but the problem appearence.i want format this number "400101000101150104" as text but i tried some method haven't the result.the excel file aways give me the number:4.00101E+17
now what should i do?thanks all~
XI
xieyun
September 5, 2008 01:35 AM UTC
go on,thanks for your help.
hello everybody!i want to export datatable to excel,but the problem appearence.i want format this number "400101000101150104" as text but i tried some method haven't the result.the excel file aways give me the number:4.00101E+17
now what should i do?thanks all~
GM
Geetha M
Syncfusion Team
September 9, 2008 06:33 AM UTC
Hi,
I hope your issue has been resolved. Please let me know if you have any other concerns.
Regards,
Geetha
XI
xieyun
September 9, 2008 01:00 PM UTC
thanks for your attention,i solved this problem in the end by the way:xlsWorksheet.ImportDataTable(sourceDt, false, 6, 1, 65535, 20, true);
the last parameter tell xlsio to preserve the type of datatable's.
best wish~
GM
Geetha M
Syncfusion Team
September 10, 2008 04:03 AM UTC
Hi,
Thank you for the update.
Regards,
Geetha