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();
           childTable.Rows.Clear();
           for (int j = 0; j < 65000; j++)
           {
               try
               {

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

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


Thanks in advance...
Posted

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