In tJavaRow, how to skip to the next sheet?

msg1 — Tue, 06 Oct 2020 14:18:56 GMT

Hello,

My goal is to extract data from multiple sheets from an Excel file, while avoiding to loop over all rows of all sheets, given that a prior process stashed the last line to exploit in each sheet if any.

So here a tFileInputExcel feeds a tJavaRow, and basiacally, after looking at the generated text.

Basically, I’m looking for a way to express "if some condition are met, skip the rest of rows contained on the current sheet, and move to the next one".

Here is a concrete example of what I tried to implement :

String sheet = (String) globalMap.get("tFileInputExcel_2_CURRENT_SHEET");

boolean process = true;

for(String key: globalMap.keySet()) {

process = key.matches(sheet + "\\d\\+"); // globalMap contains a "shitname + row-number" key for each line to process

if(!process) {break;}

}

if(!process) {

System.out.println( String.format("Skip sheet '%s': no matching data to extract.", sheet) );

/* Here is code copied from the generated code that I thought possibly relevant to achieve the stated goal */

if (rowCount_tFileInputExcel_2 <= i_tFileInputExcel_2) {

sheet_tFileInputExcel_2 = sheetList_tFileInputExcel_2

.get(++sheetIndex_tFileInputExcel_2);

currentRows_tFileInputExcel_2 = sheet_tFileInputExcel_2.getRows();

}

/* End of code copied from the generated one */

continue;

}

Now, when run, this will lead to the Exception with the message "Exception in component tJavaRow_1 (Parse_Excel_6)":

Exception in component tJavaRow_1 (Parse_Excel_6)

java.lang.IndexOutOfBoundsException: Index: 37, Size: 37

at java.util.ArrayList.rangeCheck(Unknown Source)

at java.util.ArrayList.get(Unknown Source)

at ars.parse_excel_6_0_1.Parse_Excel_6.tFileInputExcel_2Process(Parse_Excel_6.java:7883)

at ars.parse_excel_6_0_1.Parse_Excel_6.tFileInputExcel_1Process(Parse_Excel_6.java:1357)

at ars.parse_excel_6_0_1.Parse_Excel_6.runJobInTOS(Parse_Excel_6.java:8371)

at ars.parse_excel_6_0_1.Parse_Excel_6.main(Parse_Excel_6.java:8220)

Would someone have some recommendation? Likely this is due to the increment of the sheet pointer going to far, but I didn’t figure out how to deal properly with the context produced with the generated code.

topic In tJavaRow, how to skip to the next sheet? in Talend Studio

In tJavaRow, how to skip to the next sheet?