Unable to fetch the data from excel(.xls) file

[Anonymous]

Guys,

I'm facing weird issue while reading .xls file. File is not fetching any data rows even there is data present in a excel file. I'm not getting any error.

If I read same file from repository (metadata) I'm getting the data rows but there will be multiple files so cannot use metadata.

Any idea about this?  

[Anonymous]

Hi,

    Could you please add screenshots of the following details:-

a) Job flow where data read is happening using tfileinputexcel from multiple files and printing to tlogrow.

b) screenshot of tfileinputexcel basic and advanced tabs

c) Schema of tfileinputexcel

   Please also provide 2 sample files so that we can replicate the flow at our end. Please remove any confidential data before providing sample file.

Warm Regards,

Nikhil Thampi

[ankit7359]

Hi @SanjayK9592,

Greetings of the Day,

Can you pls share a screenshot of the excel file which you are tryin to upload also can you attach the screenshot - while reading the file in Metadata.Also it seems that you are reading the older version of excel format(EXCEL - 97 to EXCEL2003)..

Pls reach out to Community,if necessary.

Thanks,

Ankit

[dipanjan93]

Check whether the respective values for headers and footers are correct

[Anonymous]

Attached the screen shots. 

Excel file is of older version .

Basic_setting.PNG
FileInputAdvanced.PNG
inputData.PNG
readExcel.PNG
RepositoryAdvanced.PNG

[Anonymous]

Hi,

    Thanks for the screenshots. Could you please attach the input file also as it is very difficult to create sample set from screenshots?

Warm Regards,

Nikhil Thampi

[manodwhb]

@SanjayK9592,can you enable Read excel2007 fileformat in Basic setting of tFileExcelinput try and let me know.

[Anonymous]

It will through OLEException

[manodwhb]

@SanjayK9592,i do not get any error,might be you need to install the required jars to read a excel file.

can you check in the Problems view from Window>>show view..>>General>>Problems,what was the problem and check the excel file required jars also.

[Anonymous]

Hi,

    I was able to read the file without any issues. I could see there are lot of empty rows at the end and it is the reason why the output reached almost 2310 records.

   

 If you are able to read it through metadata mode, I would recommend you to first create a tfileinputexcel from metadata and then change it to Built in mode once it is present in studio canvas.

Warm Regards,

Nikhil Thampi