How do I access excel file from asp.net with unformated columns

See more:

VB

ASP.NET

MS-Excel

Hello developers

I have one excel file and I want to access it from asp.net but it does not have formatted columns like tables.

for example:

let's say this is a MS Excel File.

in Sheet 1:


Work Name: Abcd


Sr. No | Item | Quantity | Rate | Amount
1 | xyz | 10 | 10 | 100
2 | abc | 5 | 50 | 250
3 | def | 50 | 100 | 5000

Total --------------------------- 5350
tax------------------------------ 150
Grand Total----------------------- 5500


in sheet 2:



Work Name : xyz


Sr. No Item Quantity Rate Amount
1 xyzabc 10 60 600
2 abcdef 10 10 100
3 defsds 50 50 2500

Total --------------------------- 3200
tax------------------------------ 150
Grand Total----------------------- 3350



Now I want to access Data from asp.net

for example if I select work name as abcd

then i should get data of sheet 1

Sr. No Item Quantity Rate Amount
1 xyz 10 10 100
2 abc 5 50 250
3 def 50 100 5000

Can any one help me to do this task.
thanx in advance and sorry for bad english.

plz help me its urgent.