How to export Data Table into Pdf , xls ,copy ?

Abdalla Elawad

9y2.5k

Hello Guys

Please Help me ... i using data table with ASP.NET , now i need to export data table into pdf , xls,word .....etc

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

alice yang9y ago
Accepted answer
DataTable to PDF:
https://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-DataTable-to-PDF.html

DataTable to Excel:
https://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-Datatable-to-Excel-through-DataGridView.html

DataTable to Word:
https://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-Data-from-Datatable-to-Word-Document-in-C.html
0
Sundaram Subramanian9y ago
Follow this link,

https://www.aspsnippets.com/Articles/Export-DataSet-or-DataTable-to-Word-Excel-PDF-and-CSV-Formats.aspx
0
Manas Mohapatra9y ago
Follow below links:

https://www.aspsnippets.com/Articles/Export-DataSet-or-DataTable-to-Word-Excel-PDF-and-CSV-Formats.aspx

http://amin-sayed.blogspot.sg/2008/10/in-this-article-ill-demonstrate-how-to.html

https://www.codeproject.com/Tips/355353/Exporting-a-DataTable-to-PDF
0
Ankit Sharma9y ago
Hi ,
To export to excel format you can use following code

protected void ExportExcel( DataSet dataSet)

       {

           string filename = "Report";

           XLWorkbook workBook = new XLWorkbook();



           try

           {

             workBook.Worksheets.Add(dataSet.Tables[0], "Exported_Data");



              if (workBook.Worksheets.Count > 0)

               {

                   Response.Clear();

                   Response.Buffer = true;

                   Response.Charset = string.Empty;

                   Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

                   Response.AddHeader("content-disposition", "attachment;filename= " + HttpUtility.UrlEncode(filename));



                   using (MemoryStream MyMemoryStream = new MemoryStream())

                   {

                       workBook.SaveAs(MyMemoryStream);

                       MyMemoryStream.WriteTo(Response.OutputStream);



                       HttpContext.Current.Response.Flush();

                       HttpContext.Current.Response.SuppressContent = true;

                       HttpContext.Current.ApplicationInstance.CompleteRequest();

                       HttpContext.Current.Response.Close();

                   }

               }

             }

           catch (Exception ex)

           {

               return;

           }

    }
Visit this link to see how to install packages using Nuget package manager

http://www.c-sharpcorner.com/UploadFile/8a67c0/use-nuget-package-manager-in-visual-studio-2015/

Use nuget command :

Install-Package ClosedXML -Version 0.88.0

and include using ClosedXML.Excel; in your .cs file

to export to pdf format visit this link

http://www.c-sharpcorner.com/blogs/datatable-to-pdf-export
0