Identify and capture Hidden rows from excel file

[AbhishekBoga]

Hi All,

Is there any inbuild component in Talend where I can identify the hidden rows from excel file and then store it in a table?

I didn't found any component which can work like this.

[akumar2301]

Hello ,

You can identity hidden row using Java 

 Workbook workbook = WorkbookFactory.create(new File(.......));
  Sheet = workbook.getSheetAt(0);
  Iterator<Row> row Iter = sheet.iterator();
  while(rowIter.hasNext()) {
    Row row = rowIter.next();
    if(row.getZeroHeight()) {
        System.out.println(row.getRowNum() + " Rownumber is hidden"  );
    }
  }

[AbhishekBoga]

Hi Abhishek,

Thanks for the code.

I am getting error message as "rowIter cannot be resolved"

I have added the code in tJava component as below:

Workbook workbook = WorkbookFactory.create("D:/Project Docs/Data Lake/Source Files/Fetch_Line_Number.xlsx");
Sheet = workbook.getSheetAt(0);
Iterator<Row> row Iter = sheet.iterator();
while(rowIter.hasNext()) {
Row row = rowIter.next();
if(row.getZeroHeight()) {
System.out.println(row.getRowNum() + " Rownumber is hidden" );
}
}

[akumar2301]

Hello Try below code

org.apache.poi.xssf.usermodel.XSSFWorkbook workbook = new org.apache.poi.xssf.usermodel.XSSFWorkbook("C:/xxxxxx/in.xlsx");
org.apache.poi.xssf.usermodel.XSSFSheet sheet= workbook.getSheetAt(0);
java.util.Iterator<org.apache.poi.ss.usermodel.Row> rowIter = sheet.iterator();
while(rowIter.hasNext()) {
org.apache.poi.ss.usermodel.Row row = rowIter.next();
if(row.getZeroHeight()) {
System.out.println((row.getRowNum()+ 1) + " Rownumber is hidden" );
}
}