Export DataTable to Excel and PDF using C# and VB.Net in ASP.Net

Question

I have Data in DataTable And I want to Export it as Excel Pdf Format  Kindly Help

dharmendr · Accepted Answer

Hi RoseRefer below articleExport DataSet or DataTable to Word Excel PDF and CSV Formats

Rose · Answer

HiHere is the Code that I used to Export Datatable DataTable dt  GetListSLDocument sl  new SLDocumentslImportDataTable1 1 dt truestring FileName  name  34 xlsx34HttpContextCurrentResponseClearHttpContextCurrentResponseContentType  34applicationvndopenxmlformatsofficedocumentspreadsheetmlsheet34HttpContextCurrentResponseAddHeader34ContentDisposition34 34attachment filename34  FileNameslSaveAsResponseOutputStreamHttpContextCurrentResponseFlushHttpContextCurrentResponseSuppressContent  trueHttpContextCurrentApplicationInstanceCompleteRequest

Export DataTable to Excel and PDF using C# and VB.Net in ASP.Net

Export DataSet or DataTable to Word Excel PDF and CSV Formats

Company

Explore

Follow us

Contact Us