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

Anish Kumar

10y1.2kVisual Basic .NET

Advance Thanks...

5 Replies

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

Farhan Shariff10y ago
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
0
Anish Kumar10y ago
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!!
0
Farhan Shariff10y ago
1. protectedstringExportDatatableToHtml(DataTabledt)
2. {
3. StringBuilderstrHTMLBuilder=newStringBuilder();
4. strHTMLBuilder.Append("");
5. strHTMLBuilder.Append("");
6. strHTMLBuilder.Append("");
7. strHTMLBuilder.Append("");
8. strHTMLBuilder.Append("");
10. strHTMLBuilder.Append("");
11. foreach(DataColumnmyColumnindt.Columns)
12. {
13. strHTMLBuilder.Append("");
14. strHTMLBuilder.Append(myColumn.ColumnName);
15. strHTMLBuilder.Append("");
17. }
18. strHTMLBuilder.Append("");
21. foreach(DataRowmyRowindt.Rows)
22. {
24. strHTMLBuilder.Append("");
25. foreach(DataColumnmyColumnindt.Columns)
26. {
27. strHTMLBuilder.Append("");
28. strHTMLBuilder.Append(myRow[myColumn.ColumnName].ToString());
29. strHTMLBuilder.Append("");
31. }
32. strHTMLBuilder.Append("");
33. }
35. //Closetags.
36. strHTMLBuilder.Append("");
37. strHTMLBuilder.Append("");
38. strHTMLBuilder.Append("");
40. stringHtmltext=strHTMLBuilder.ToString();
42. returnHtmltext;
44. }
You can find the code and explaination from this article
http://www.c-sharpcorner.com/UploadFile/deveshomar/export-datatable-to-html-in-C-Sharp/
0

Anish Kumar10y ago

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

Farhan Shariff10y ago

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