Reading sheetnames from excel and insert it into a checkboxlist
Posted on 2008-06-10
Im a bit confussed and ive got a question regarding importing sheetnames from a excel.
Im about to read from an excel document read it sheets and insert it into a checkboxlist in a asp.net page.
IM using oledbb4.0 with extention 8.0 (old excel)
Any idea how to accomplish this?
The actual part im stuck at is how to read the sheetnames after that i will insert the sheetnames ive got into a dataset and by that way set he checkboxlist to read from the dataset.
But back to my problem Any idea how to read the sheetnames? It canbe more than once just now one:) So i gotta have a loop of some kind.
Any idea ? I would be thnakful