One Star

How can i get Excel sheet name in a job?

How can i get Excel sheet name in a job?
10 REPLIES
One Star mpa
One Star

Re: How can i get Excel sheet name in a job?

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
One Star

Re: How can i get Excel sheet name in a job?

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?
One Star mpa
One Star

Re: How can i get Excel sheet name in a job?

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

Re: How can i get Excel sheet name in a job?

Hi,mpa
I use TOS 3.1.1.

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

Re: How can i get Excel sheet name in a job?

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
Six Stars

Re: How can i get Excel sheet name in a job?

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
One Star

Re: How can i get Excel sheet name in a job?

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

Re: How can i get Excel sheet name in a job?

Thank you ,archenroot
But , version is not compatible?
Six Stars

Re: How can i get Excel sheet name in a job?

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.
One Star

Re: How can i get Excel sheet name in a job?

Thank you ,archenroot
How many years you used Tos, i am a new player. Can you give me a Skype or MSN?
I want to timely advice from you .May I be honored to make accqaintance with you?