DLL
To specify the maximum number of rows when using virtual mode
Call the SSVSetMax function and set the Max parameter as follows:
- If you know the exact number of rows in the sheet, specify that number.
- If you do not know the exact number of rows in the sheet, but would like the sheet to determine it once it has read all the rows, specify –1.
-
If you do not know the exact number of rows in the sheet, but would like to estimate it, overestimate the number rather than underestimating it.
If you underestimate the number, the sheet never reads the records past the value you assign the Max parameter.