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

Question

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

alice yang · 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

Sundaram Subramanian · Answer

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

Manas Mohapatra · Answer

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

Ankit Sharma · Answer

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

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

Answers (4)