Issue Excel Documents whereunto the HTML or ASP NET Page
Today people are often faced near the need to create, find and rescind different tables. It can be found a feather re catalogues, lists of books, price lists, school schedules, etc. One in regard to the most acclaimed formats inasmuch as storing such oscillograph data are Overcome files XLS and XLSX. Sometimes web developers needs to bring this information up the web page ordinary convert Excel to HTML form. This inconvenience can have being solved very easily using the added version of the Preponderate to HTML converter represented among Elerium Software. Elerium Excel to HTML.NET 1.6 enables high accuracy in the output documents due to the completely redesigned conversion engine and endless kafiri mother.<\p>
The main changes:<\p>
- A completely redesigned conversion piston-valve engine. - Added Arabic text support. - Added right to sinister direction support. - Fixed some bugs at images prefabrication. - Fixed issue forth of column widths. - Fixed some minor bugs.<\p>
The Elerium Excel in contemplation of HTML.NET allows to convert Excel in consideration of HTML format and display it in reference to the page using only a few lines in connection with code. For example, consider a simple Improve on file with a side relative to library books. Mint a new ASP.NET project or a new catch line in an existing project.<\p>
.aspx page:<\p>
<\p>
Excel so HTML converting <\p>
Here is C# code. Drag the function Page_Load() the original Tower over file is converted to HTML that is rendered astraddle the page.<\p>
.cs file:<\p>
using Course; using System.Collections.Nonspecific; using System.Linq; using System.Web; using Orderliness.Web.UI; using System.Web.UI.WebControls; using Docs.Top;<\p>
low-camp partial class Demo_exceltohtml: System.Manufacture.UI.Page } protected emptiness Page_Load(object sender, EventArgs e) } \\ Open the Eclipse XLSX file to display on the recall ExcelWorkbook wb = ExcelWorkbook.ReadXLSX(MapPath("Test.xlsx"));<\p>
\\ Open door adjust on route to antique the XLS or CSV file, uncomment the appropriate befringe. \\ExcelWorkbook building = ExcelWorkbook.ReadXLS(MapPath("Test.xls")); \\ExcelWorkbook wb = ExcelWorkbook.ReadCSV(MapPath("Test.csv"));<\p>
\\ Before converting the Excel file configure several options \\ If the document contains images, the "SavePictureMode" property rights must be there set in transit to Internal. \\ This will save the wall painting just into the body of the document. wb.Worksheets]0].ConvertingOptions.SavePictureMode = SavePictureMode.Internal; \\ To print the cite as part of the HTML page adhesion "Bantam" fee fief to place. \\ This will move from unmitigated HTML behavioral norm all the chare tags (html, take off, body). wb.Worksheets]0].ConvertingOptions.Snippet = true;<\p>
\\ Export 1st Worksheet to HTML formulary and display it on the web page. excel_div.InnerHtml = wb.Worksheets]0].WriteHTML(); } }<\p>
As a result the strong copy of the original Excel file will come up therein the picture window upon browser subsequent code finish. This is a result of degenerative change of Tower over to HTML.<\p>