Last post Nov 25, 2015 02:28 PM by Lannie
Nov 25, 2015 11:39 AM|raj.selvaa|LINK
I am using Asp.NET application with C#, in which having following data table
DataTable dt = new DataTable();
dt.Rows.Add("1", "Hi, I am <b>XXX</b>");
dt.Rows.Add("2", "<b>Great</b> <i>Work</i>");
dt.Rows.Add("3","This is Sample Image <img src='smiley.gif' alt='Smiley face' height='42' width='42'>");
dt.Rows.Add("4", "This is attached file <a href='../Content/FileManager/Documents/Product Review.docx'>../Content/FileManager/Documents/Product Review.docx</a>");
In this DataTable, HtmlContent column contains Html Tags, Image tags and File (PDF or Word or Video or Audio) in Link Format.
I want to export this data table into excel format, My Server does not contain MS-Office Excel, Content should be rendered as Html in Excel cell, If any of the image file is available then displayed within the excel cell, If any of the file
(PDF or Word or Video or Audio) available then It should Embed that object into Excel cell.
Kindly refer the attached Image to view my final output.
I have searched online but could not get appropriate solution approach, Kindly provide some help.
Nov 25, 2015 12:07 PM|dhol.gaurav|LINK
You have to write code manually to generate html.
Sample code available at below link
Nov 25, 2015 02:28 PM|Lannie|LINK
In addition, there are commercial DLLs out there (Telerik asp.net controls, Spreadsheet Gear, and others) that support spreadsheet like grids and export to Excel (and other formats) without Excel installed.