R Benak
8/30/2007 6:54:00 PM
I am working on a .net 2.0 application that needs to open Excel spreadsheets
via interop, process the data applying appropriate business logic, then post
the data to a SQL database. The target spreadsheets contain multiple group
levels that represent a relationship between data. This relationship needs to
be maintained in code. The ranges of these groups can change from worksheet
to worksheet as well as within an individual worksheet.
How can I programatically detect the the outline of rows within a
spreadsheet in an effort to implement the outline structure as data
relationships in code?
Would be cool if a Data.Dataset object would bind directly to a WorkSheet
object, but then World peace would be cool to!!
thanks in advance
rlb