Reading data from muliplte table structure in single excel sheet

AnandManokaran

New Member
Hi Everyone,

I need to read the content from an excel having two or more table like data in single sheet. And create two collections having data from each table

Example:
Table 1
Item_Type Brand Price
Pencil Fabber 50
Pencil Apsara 30
Pen Parker 100
Pen Parker 160
-----------------------------
Total 340
-----------------------------

Table 2
Item_Type Brand Price
Watch Fastrack 5000
SmartWatch Apple 35000
Mobile Samsung 40000
-----------------------------
Total 80000
-----------------------------
 

Attachments

  • Sheet 1 - Two table data.jpg
    30.8 KB · Views: 8
Top