How to show excel data format in browser using c#?

Question

Advance Thanks...

Farhan Shariff · Answer

Do u mean something like google doc viewer This might help: https://support.microsoft.com/en-us/kb/304662 http://stackoverflow.com/questions/5534534/view-excel-in-webbrowser-control-c-sharp http://stackoverflow.com/questions/5114751/how-can-i-open-a-excel-inside-a-web-browser

Anish Kumar · Answer

Bro, Its Fine... But my question is Showing the datatable values in excel format in one part of the browser ... Not in table format.... Sorry this is urgent need!!

Farhan Shariff · Answer

protected stringExportDatatableToHtml(DataTabledt) { StringBuilderstrHTMLBuilder= new StringBuilder(); strHTMLBuilder.Append( " " ); strHTMLBuilder.Append( " " ); strHTMLBuilder.Append( " " ); strHTMLBuilder.Append( " " ); strHTMLBuilder.Append( " " ); strHTMLBuilder.Append( " " ); foreach(DataColumnmyColumnindt.Columns) { strHTMLBuilder.Append( " " ); strHTMLBuilder.Append(myColumn.ColumnName); strHTMLBuilder.Append( " " ); } strHTMLBuilder.Append( " " ); foreach(DataRowmyRowindt.Rows) { strHTMLBuilder.Append( " " ); foreach(DataColumnmyColumnindt.Columns) { strHTMLBuilder.Append( " " ); strHTMLBuilder.Append(myRow[myColumn.ColumnName].ToString()); strHTMLBuilder.Append( " " ); } strHTMLBuilder.Append( " " ); } //Closetags. strHTMLBuilder.Append( " " ); strHTMLBuilder.Append( " " ); strHTMLBuilder.Append( " " ); stringHtmltext=strHTMLBuilder.ToString(); return Htmltext; } You can find the code and explaination from this article http://www.c-sharpcorner.com/UploadFile/deveshomar/export-datatable-to-html-in-C-Sharp/

Anish Kumar · Answer

Bro, By Data table , how to show the excel format in browser???

Farhan Shariff · Answer

You can import it to datatables and then display in a brower html