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
-----------------------------
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
-----------------------------