Page 1 of 1

Blank worksheets

Posted: Mon Jan 11, 2016 2:35 pm
by jshawver
When we read an xlsx file containing blank worksheets, the LastCol and LastRow properties of the blank sheets is 0. When we read an xls file containing blank sheets, the LastRow and LastCol properties of the blank sheets is -1. Is this an expected difference between the two file versions?

Re: Blank worksheets

Posted: Thu Jan 14, 2016 11:27 am
by larsa
Hello

I would have been better if xls and xlsx files returned the same value, but as it have been like this for several years, we can't change it as this is what users expect.