Convert Excel to HTML

Question

I have a requirement to preview excel files in browser. I am currently trying to convert excel file to html using the OpenXML SDK and OpenXml Power tool. Using the SmlDataRetriever I could retrieve the XElement data from the excel sheet but I am unable to proceed further. Please find below the format which I receive from SmlDataRetriever       "9.25"  defaultRowHeight= "15"  dyDescent= "0.25"  />      "1" >   "A1"  ColumnId= "A"  ColumnNumber= "0"  Type= "s" >      Make     Make        "B1"  ColumnId= "B"  ColumnNumber= "1"  Type= "s" >      Miles     Miles        "C1"  ColumnId= "C"  ColumnNumber= "2"  Type= "s" >      Cost    Cost          "2" >   "A2"  ColumnId= "A"  ColumnNumber= "0"  Type= "s" >      Ford    Ford       "B2"  ColumnId= "B"  ColumnNumber= "1" >      40000    40000       "C2"  ColumnId= "C"  ColumnNumber= "2"  Style= "1" >   "6"  formatCode= "" $ "#,##0_);[Red]$" $ "#,##0$"  applyNumberFormat= "1" >      "11"  />   "1"  />   "Calibri"  />   "Swiss"  />   "minor"  />         3500    $3,500          "3" >   "A3"  ColumnId= "A"  ColumnNumber= "0"  Type= "s" >      Chevi    Chevi       "B3"  ColumnId= "B"  ColumnNumber= "1" >      55000    55000       "C3"  ColumnId= "C"  ColumnNumber= "2"  Style= "1" >   "6"  formatCode= "" $ "#,##0_);[Red]$" $ "#,##0$"  applyNumberFormat= "1" >      "11"  />   "1"  />   "Calibri"  />   "Swiss"  />   "minor"  />         4200    $4,200          "4" >   "A4"  ColumnId= "A"  ColumnNumber= "0"  Type= "s" >      Tata    Tata       "B4"  ColumnId= "B"  ColumnNumber= "1" >      51000    51000       "C4"  ColumnId= "C"  ColumnNumber= "2"  Style= "1" >   "6"  formatCode= "" $ "#,##0_);[Red]$" $ "#,##0$"  applyNumberFormat= "1" >      "11"  />   "1"  />   "Calibri"  />   "Swiss"  />   "minor"  />         3800    $3,800             Is there any possible ways to convert this into a valid HTML so that it can be previewed. Is there any other methods in which this can be achieved. I cannot use the paid libraries for this work. I could not find any examples in the XSLT transformation of excel XML to HTML. Any help in this area is appreciated. TIA

Laxmidhar Sahoo · Answer

Hi   Follow the link may help   https://www.xmlfiles.com/articles/xsl-transformations-in-net-2-0/   Thanks and regards

Laxmidhar Sahoo · Answer

hi Which tool you used like asp.net web page or mvc or other   Thanks and regards

Jignesh Kumar · Answer

Hi Devika,   Please use this link which will help, https://www.c-sharpcorner.com/UploadFile/manas1/display-xml-data-as-html-using-xslt-in-Asp-Net/#:~:text=XslCompiledTransform%20class%20Without%20XML%20control,-In%20the%20.&text=Xml.,data%20into%20the%20TextReader%20object.

Marvin Reid · Answer

You can convert to HTML through the use of the DocumentConverter class. Here is some code that you can try:
using  (DocumentConverter documentConverter =  new  DocumentConverter())        {           var input = @ "C:\Input\Excel.xls" );           var output = @ "C:\Output\output.html" );           var jobData = DocumentConverterJobs.CreateJobData(input, output, DocumentFormat.Html);           jobData.JobName =  "conversion job" ;                  var documentWriter =  new  DocumentWriter();           documentConverter.SetDocumentWriterInstance(documentWriter);                  var renderingEngine =  new  AnnWinFormsRenderingEngine();           documentConverter.SetAnnRenderingEngineInstance(renderingEngine);                  var job = documentConverter.Jobs.CreateJob(jobData);           documentConverter.Jobs.RunJob(job);        }     https://www.leadtools.com/help/sdk/v22/tutorials/dotnet-console-convert-files-with-the-document-converter.html

Devika M · Answer

Hi All,
To add some details to the question. I am working on .Net Core MVC.  As
Sapna Girish suggested, checked spire, but it has limitations for the free version. As Jignesh suggested I tried out the xlst transformation and could get the data in table format. But I am yet to figure out how to extract the styles/css part out of it. PFB the xsl sheet.  "3.0"  xmlns:xsl= "http://www.w3.org/1999/XSL/Transform" >        default  action -->        "@*|node()" >                            "@*|node()" />                                    "Data" >                            "@*|node()" />                                    "Row" >                            "@*|node()" />                                    "Cell" >               "DisplayValue" />
Yet to try out the report viewer. Thanks all. Please pour in your suggestions.

Ajay Bachale · Answer

You can use report viewer to open excel in web browser. Mostly other nuget packages arelicensed version    Example using report viewer  https://stackoverflow.com/questions/21466807/use-excel-spreadsheet-as-data-source-for-report-viewer-c-sharp

Sapna Girish · Answer

refer to the following links   https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Convert-Excel-to-HTML-Excel-to-HTML-in-C-VB.NET.html https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Conversion/Embed-image-in-HTML-when-converting-Excel-to-HTML-in-C.html