Get exccel Sheet Names

Anonymous — Sat, 16 Nov 2024 09:18:41 GMT

Hello, I have an excel and i whant to verify that the 2 sheets exist.

How can i do that? i tried with Tmap and ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET")) but i get multipe times the sheet names. See pic.

Re: Get exccel Sheet Names

TRF — Mon, 11 Sep 2017 15:23:13 GMT

Hi,

As far as I know there is no shortcut for this purpose.

However, you can select "All sheets" on configuration tab, then connect tFileInputExcel to a tJava and set a global variable for each sheet (but remember the Excel must be read for that) using the following Java code:

globalMap.put((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET"), "");

After tJava, if you're expecting for 2 sheets named sheet1 and sheet2, you can use an If trigger to connect the next component with this condition:

(String)globalMap.get("sheet1") != null && (String)globalMap.get("sheet2") != null

As soon as sheet1 and sheet are defined in the Excel file and are not empty, the condition is true and je job continue with the next component.

Hope this helps.

Re: Get exccel Sheet Names

fab_74 — Mon, 11 Sep 2017 15:33:24 GMT

hello

use taggregate after your tmap

topic Re: Get exccel Sheet Names in Talend Studio

Get exccel Sheet Names

Re: Get exccel Sheet Names

Re: Get exccel Sheet Names