Use poi to parse Excel getlastnum ()

Yesterday, when I used poi to parse the Excel file, I found that if the Excel file is encrypted, that is, the Excel file is set to protected worksheet (tool --> Protection Work Sheet) the poi of apahce cannot parse the encrypted Excel file. However, if only one sheet in the encrypted Excel file (that is, the sheet protected by the Excel file is set to protected) can be parsed ~~~

In addition, poi provides a method to obtain the maximum number of rows, which is called getlastrownxx. The number of rows obtained by getlastrownxx is the number of rows of the unit rows drawn in your Excel file.

If you have 10 rows of data in the Excel file, call this method and return 10,

After you manually delete two rows using Delete, call this method and return 10. In this case, you need to delete the unit rows before returning 8 ~~~