Reading excel file including cell color

Topics: Developer Forum, Project Management Forum
Aug 7, 2009 at 8:28 PM

I wonder if this application can help me. I am writing an ASP.Net application (vers. 3.5) to put on the company server. It needs to read data from an Excel file, including the cell color. There is no version of Office running on the server.

Also, is there a cost for using this product?

Oct 1, 2009 at 5:10 AM

AFAIK, the product is Open Source / GPL. See "License" tab for more info.

Getting a cell color is non-trivial. To get you started:

  • If you rename XLSX file to ZIP you can extract files from it.
  • In worksheet XML file, each cell has a reference to a style (index of the style).
  • The style should have the fill info (or a reference to a fill tag, which in turn has the color info).