How to count rows and Columns of excel sheet in Java

Question

Is there a way to count the number of rows and columns in an excel table in Java? I am using XSSF workbook to import and parse the data into the program. . There are no empty cells until after the last row or column. For example if there was a table that was 5 rows and 3 columns, cell b2 would not be empty.

score 1 · Accepted Answer · answered Nov 23 '15 at 19:31

1

XSSF sheet has a method called getPhysicalNumberOfRows() to get what looks like you want for rows, but I don't know about columns.

answered Nov 23 '15 at 19:31

Aragorn

5,021
5
26
37

any method to get the current row ?? – master ArSuKa Nov 08 '18 at 10:37

How to count rows and Columns of excel sheet in Java

1 Answers1