Excel import to database using C#

Question

Hi please find the screenshot attached and provide me the logic how we can acheive this. I need to import this excel file. This is a sample image. I have no. of header rows and no. of columns will differ in each header.

Here is another information about the excel file. Col cells are set with background color. IS there any way to read the values from the cells having background color

Answer 1

Suggests that you probably want to do this in an automated way. I posted a question + analysis of a number of ways to do this using 3rd party libraries (as the Interop isn't really designed for automation).

I'd recommend a library (something like FlexCel) or using some of the newer capabilities in C# to handle the Office XML format. Believe these are avaliable from .NET 3.5 onwards but I don't know much about them.