[resolved] Use sheet position in tFileInputExcel

[Anonymous]

Hello,
I want to import only the first sheet of an Excel file by using the position of the sheet (0 or 1). So I disable "All sheets" and enter the position in the column "Sheet (name or position)". This gives an error "The method addSheetName(String, Boolean) in the type ExcelReader is not applicable for the arguments (int, boolean)". Tried to use "0" but then the sheet with the name "0" is not found.
Am I doing something wrong or is this a bug? How can I import only the first sheet without using the name?
Thanks for any suggestions!

[Anonymous]

Hi Sabrina,
The sheet position is not working in the component tfileinptexcel for the .xlsx files when we are in Generation Mode: less memory consumed for the large files(Even Mode). It is giving error when I given sheet position is 0.
for Memory consuming(User mode): The sheet position is working very well is 0 for the "Sheet1".
Could you guys please provide your ideas how to handle ..its very urgent for me to implement some job.
Note: I have to work on very large files so that I need to work on Generation Mode: less memory consumed for the large files(Even Mode) in Advanced settings.
Waiting for your answers and very big advance thanks to your answers..
Kind Regards,
Raghav K 

[Anonymous]

Hi Raghav K ,
Could you please indicate the build version you are using? What's the volume of your large file? What does this error you are facing look like?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
Thanks for your reply.
I have been working with build version: TOS_BD-20150508_1414-V5.6.2
OS: windows 7
The volume of large file which i am working is around 500MB. If i try to load this file in the Generation Mode: Memory- consuming(User Mode) i am getting the Out of memory exception. So that i am working with the excel files Advance Settings- Generation Mode: less memory consumed for the large file(Event Mode).
Note : Please confirm what is maximum size of the files does supports tfileinputexcel?
Generation Mode(User mode):  The sheet position is working as expected. In detail I want to read a excel file sheet name "Sheet1".
To read the sheet1 in Basic settings I am giving Sheet(name or position): 0(not in quotes). This case is working fine.
Generation Mode(Event Mode): I tried to read the Sheet1 with the Sheet(Name or position): 0 (no in quotes) which throwing the error message as below..
Error: The method addSheetName(String, Boolean) in the type ExcelReader is not applicable for the arguments (int, boolean)
As i know excel sheet name is string , So that i tried to read the sheet name like "0". In this case i am facing the error no matching sheets.
Note: I am facing this issue for the small and large files  as well when the advance settings are Generation Mode: less memory consumed for the large file(Event Mode)
Please find the attached input file and error snapshot. 
Great Thanks again for your help and waiting for your valuable suggestion.
Kind Regards,
Raghava K 

[Anonymous]

Hi Sabrina,
Could you please provide the solution/help about this excel sheet position issue.

Kind Regards-
Raghav K

[_AnonymousUser]

Hi !
I got the same problem than Raghav and I don't found a solution for this ...
My Excel file have only one Sheet ... if I try to read this sheet with the name, I've got this error :
"Cannot format given Object as a Number" and if I add one sheet ... the error disappears. But it's a file from another person and I can't modify it.
So I tried to use the Sheet position but got the same problem thant Raghav ....
Any solutions ?
Best regards
Sangoval

[Anonymous]

Hi  Sangoval,
We have replied to your another topic: https://community.talend.com/t5/Design-and-Development/Excel-bug-mode-event/td-p/58402
Could you please take a look at it?
Best regards
Sabrina

[Anonymous]

Hi Sangrovel-
If you want to go with the memory consuming mode you can use the sheet name/position option 0 (note: with out quotes)to reading the first excel sheet.
for the big files it is not applicable.
Kind Regards-
Raghav