Click here to Skip to main content
14,644,614 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hello Every One,

I am using a RKlib for exporting a excel from DataTable in asp .net(c#).
I am having a problem When the DataRow contain a Enter Format Text(Mwssage).
After Enter text set into another cell in Excel.
I am using a Folowing Code...

RKLib.ExportData.Export objexport = new RKLib.ExportData.Export("Win");

      dtToExport = Contain a Data that i have to  copy to childTable

       for (int i = 0; i < dtToExport.Rows.Count; i = i + 65000)
           DataTable childTable = dtToExport.Clone();
           for (int j = 0; j < 65000; j++)

                   childTable.ImportRow(dtToExport.Rows[i + j]);
               catch (IndexOutOfRangeException)
               { break; }

           objexport.ExportDetails(childTable, RKLib.ExportData.Export.ExportFormat.Excel, filePath + tempFileName);

Thanks in advance...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100