topic Re: tFileInputExcel : Cannot read drop down range Unrecognized token 43 in Talend Studio

tFileInputExcel : Cannot read drop down range Unrecognized token 43

YVES1 — Sat, 16 Nov 2024 12:57:28 GMT

Hi,
I am using TOS 4.2 and when launching the job (use of 3 Excel files I have the following issue about the 3rd file).
Looking at the forum this issue occured with TOS 3.1 and supposed to be fixed in a newer release.

connecting to socket on port 3547
connected
Warning: Cannot read drop down range Unrecognized token 43
Exception in component tFileInputExcel_5
java.lang.NullPointerException
at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:237)
at jxl.read.biff.SheetReader.read(SheetReader.java:994)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:676)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:285)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource$1RegexUtil_tFileInputExcel_5.getSheets(fichierSource.java:4288)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.tFileInputExcel_5Process(fichierSource.java:4340)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.tFileInputExcel_1Process(fichierSource.java:2276)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.runJobInTOS(fichierSource.java:5898)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.main(fichierSource.java:5772)
disconnected
Job fichierSource terminé à 15:54 26/04/2011.
With best regards,
Yves.

Re: tFileInputExcel : Cannot read drop down range Unrecognized token 43

Anonymous — Wed, 27 Apr 2011 03:44:11 GMT

Hi
Here is a related 15119, do you install Talend on a network driver or local driver? Can you upload some screenshots of job? It will be helpful for us to locate the problem.
Best regards
Shong

Re: tFileInputExcel : Cannot read drop down range Unrecognized token 43

YVES1 — Wed, 27 Apr 2011 11:34:16 GMT

Hi ,
in attached files are some screenshots
My configuration is the following :
LapTop DELL LATITUDE E6400, Windows XP SP3
Local C:/ : TOS 4.2 : installed on C:\Program Files\TOS-Win32-r58358-V4.2.0RC2
Local E:/ : Excel files used (tFileInputExcel_1 , tFileInputExcel_7 & tFileInputExcel_6) + tFileOutputExcel_8)
Logs extracts :
émarrage du job fichierSource a 09:33 27/04/2011.
connecting to socket on port 3984
connected
Warning: Cannot read drop down range Unrecognized token 43
Exception in component tFileInputExcel_6
java.lang.NullPointerException
at jxl.biff.DataValiditySettingsRecord.getFirstColumn(DataValiditySettingsRecord.java:237)
at jxl.read.biff.SheetReader.read(SheetReader.java:994)
at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:676)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252)
at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:285)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource$1RegexUtil_tFileInputExcel_6.getSheets(fichierSource.java:4140)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.tFileInputExcel_6Process(fichierSource.java:4191)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.tFileInputExcel_1Process(fichierSource.java:2276)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.runJobInTOS(fichierSource.java:5658)
at changements_clos_dans_le_mois.fichiersource_2_0.fichierSource.main(fichierSource.java:5532)
disconnected
Job fichierSource terminé à 09:33 27/04/2011.

With best regards,
Yves.