Getphysicalnumberofrows () and getlastrownum () differences in POI

Source: Internet
Author: User

Getphysicalnumberofrows () Gets the number of physical rows, that is, the case where the empty rows (interlaced) are not included.

Getlastrownum () Gets the number of the last line (numbering starts from 0).

The actual number of rows obtained through getphysicalnumberofrows () does not necessarily have the number of rows of data.
For example, a cell only has a non-"normal" format, and it is also considered by the POI as the actual row.

But there seems to be no such method in Poi, Getnextphysicalrow ().
So we had to traverse from Getfirstrownum () to Getlastrownum (), and if Null==currentrow, verify the next line.

Getphysicalnumberofrows () and getlastrownum () differences in POI

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.