Have a closer look of the outcome from Readfromfile method :-
Run my demo program (simpletest.lpi, uploaded few hours ago)
1.Click read button and select the file book3.xlsx (attached below).
Outcome looks ok;
2. Read the same file again.
Outcome:
3 additional BLANK sheets ( 'one1', 'two1', 'three1) are inserted into the wsGrid;
3. Goto ms office (don't quit simpletest program). (i) add one sheet ('four') into the book3.xlsx; (ii) key in some numbers in each and every sheet; and (iii) then save the file.
4. Go back to simpletest program and read book3.xlsx again.
Outcome:
4 additional BLANK sheets ('one2', 'two2', 'three2', 'four') are inserted into the wsGrid. AND the Content of sheet 'one',' two', 'three' does not change !
5. click read Book4.xlsx (attached below, which contains 4 sheets 'one',' two', 'three', 'four').
Outcome:
4 additional BLANK sheets are inserted ('one3', 'two3', 'three3', 'four1').
Again, the content of sheet 'one',' two', 'three' does not change !
My question: Are these feature (i.e. insert blank sheets and do not load the data from the sheet with same name) useful ?