rahulsurya
asked on
Reading a Excel sheet
have a excel file which starts with a report info in first few rows of excel and then table.
For example:
Distribution Report:
No of employees:
Date:
Amount:
Detail Table
empno ssn aadr1 addr2
1. How can i skip rows till table headers and read just the data from table in database or dataset using asp.net
2. How can we handle dynamic sheet names [sheet1$]while reading xls files?
For example:
Distribution Report:
No of employees:
Date:
Amount:
Detail Table
empno ssn aadr1 addr2
1. How can i skip rows till table headers and read just the data from table in database or dataset using asp.net
2. How can we handle dynamic sheet names [sheet1$]while reading xls files?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.