Per Nergård
Dec 20, 2015
  2249
(1 votes)

Generate HTML table from excel file

How hard should it be to parse an excel file and and present it as a html table? One would think that since Excel is so popular it would be super easy but in my experience it's not.

The code im going to link to isn't my own but since it actually works and handles merged cells I thought I would share it anyway.

The method uses the EPPlusl package for parsing the excel-file and generates a table.

You can get the code over at GitHub

Dec 20, 2015

Comments

Please login to comment.
Latest blogs
IDX21323 - RequireNonce is true, Nonce was null

We have multiple clients configured with Azure Active Directory (Microsoft Entra) for requiring authentication when accessing their website. The...

David Drouin-Prince | Oct 1, 2023 | Syndicated blog

Minimum Detectable Effect in Optimizely Web Experimentation

Understanding Minimum Detectable Effect Minimum Detectable Effect (MDE) is a core statistical calculation in Optimizely Web Experimentation. In...

Matthew Dunn | Oct 1, 2023 | Syndicated blog

Configured Commerce - Introduction to Long-Term Support (LTS) Releases

First off, for those who have not had a chance to meet me yet, my name is John McCarroll, and I am the Technical Product Manager for the Optimizely...

John McCarroll | Sep 29, 2023

Auto-translate with OpenAI in Optimizely CMS

You can now auto-translate content using your favorite online AI service, inside the old trustworthy Episerver.Labs.LanguageManager!

Tomas Hensrud Gulla | Sep 29, 2023 | Syndicated blog