In Excel, I need to know how many columns make up a specific row. How is that even doable? I applied POI API.
but I could only increase the number of columns to 7.
fileInputStream = new FileInputStream(file);
workbook = new HSSFWorkbook(fileInputStream);
Sheet sheet = workbook.getSheet("0");
int numberOfCells = 0;
Iterator rowIterator = sheet.rowIterator();
* Escape the header row *
Row headerRow = (Row) rowIterator.next();
//get the number of cells in the header row
numberOfCells = headerRow.getPhysicalNumberOfCells();
System.out.println("number of cells "+numberOfCells);
I want to know how many columns there are at, let's say, row 10. The columns in Excel are different.