How can i get Excel sheet name in a job?

[Anonymous]

How can i get Excel sheet name in a job?

[Anonymous]

Rxkang,

In a component after your tFileInputExcel you can use crtl + space and select something like the following: ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET")) . (Depending on the name of your tFileInputExcel component offcourse)
Regards

[Anonymous]

Hi,mpa
I didn't find " ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET")) "
I only find :
((String)globalMap.get("tFileInputExcel_3_ERROR_MESSAGE"))
((Integer)globalMap.get("tFileInputExcel_3_NB_LINE"))
is our tos version problem?

[Anonymous]

rxkang,
I would assume that this would be related with your tos version. What version are u using?
Regards

[Anonymous]

Hi,mpa
I use TOS 3.1.1.

Do you have Msn No? we can talk with Msn. I am chinese.

[Anonymous]

Rxkang,
I had a look and it seems to be added in version 3.2.
http://www.talendforge.org/bugs/index_jira.php?id=TDI-5407
Regards

[Anonymous]

Do upgrade of TOS. First export from old version and then import repository to new version, this could help prevent issues when upgrading (comming from my experiences...)
Ladislav

[Anonymous]

Do you mean i cann't get excel sheet name in version 3.1.1?

[Anonymous]

Thank you ,archenroot
But , version is not compatible?

[Anonymous]

As mpa wrote, feature CURRENT_SHEET has been added in version 3.2, so you schould use this version at minimal. It is not available in version 3.1.1.