Excel export template syntax
Say I have values in an excel in cells A1,A2,A3,A4,A5,A6,A7,A8 . And A1-A5 shuld be read into Pagelist1() and A6 to A8 should be read into Pagelist2() . When I mentioned Pagelist1().Prop1 in A1 position in template excel, all the values from A1-A8 gets read into Pagelist1. How do I give the range A1-A5 for Pagelist1() in template. Or let me know if any otherway we can read values into 2 lists from same excel column.
Posted: 3 years ago
Posted: 3 years ago
Thank you for reply.
Yes, this could be one option.
I have around 6 such lists and around 20 sheets.
Any other solution?
How about parsing the page list first and then implement the logic in some activity.
Parse the excel and put all the values in one page list then loop it through and when its 8th page on the list put it in other page list.
-Saikat