Try our conversational search powered by Generative AI!

Per Nergård
Dec 20, 2015
  2369
(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
Upgrade Optimizely CMS From v11 to v12

Why Upgrade? There are many improvements implemented in version 12, but most importantly is that the whole framework is migrated from .Net Framewor...

MilosR | May 13, 2024

Configured Commerce - Infrastructure Updates Ahoy!

I'm very happy to share an important milestone - we no longer have any customers in our legacy v1 environment!  This means that the Configured...

John McCarroll | May 10, 2024

A day in the life of an Optimizely Developer - Enabling Opti ID within your application

Hello and welcome to another instalment of A Day In The Life Of An Optimizely developer, in this blog post I will provide details on Optimizely's...

Graham Carr | May 9, 2024

How to add a custom property in Optimizely Graph

In the Optimizely CMS content can be synchronized to the Optimizely Graph service for it then to be exposed by the GraphQL API. In some cases, you...

Ynze | May 9, 2024 | Syndicated blog