The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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~
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~
GMGeetha 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
XIxieyunSeptember 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~
GMGeetha M Syncfusion Team September 10, 2008 04:03 AM UTC