[RESOLVED] Gridview Excel question

[Metallicaman]

I need to make an application where someone can edit excel documents and generate reports. The excel documents will follow 3 different formats so I will know what the layout of the excel file will be.

My question is one of the excel files has a layout that im not sure how to query.

its basically like this where there is a main header, then each group has its own header.

Can this be read into a gridview or something without muych fussing, or do am going to need to go through alot of formatting to get the sql to work

--------------------------------------------------------------
page title
--------------------------------------------------------------
Author | Title | Pub Date
--------------------------------------------------------------
Scary Books
--------------------------------------------------------------
Steven King | Sleepwalkers | 9/1/9000
--------------------------------------------------------------
Steven King | IT | 9/1/2000
--------------------------------------------------------------
Adventure stuff
--------------------------------------------------------------
J.K Rowling |Harry potter and... | 9/1/4000
--------------------------------------------------------------

[mendhak]

You will need to read the Excel data in and write code that inherently knows the structure of this Excel document. Based upon that, generate the data table/ data set that the gridview or repeater will use. And yes, there will also be gridview formatting involved, again custom formatting that you need to come up with.

However, you can get an idea of what to do with the gridview formatting bit - do a search for gridview with subheadings.

[Metallicaman]

Yea, I just got to the point where i was importing it and noticed it was importing pretty much every cell with a border regardless of if it had data.

So yea im going to have to format it a bit.

thanks