topic Re: tFileExcelSheetInput component reading Zero rows for XLSX file in Talend Studio

tFileExcelSheetInput component reading Zero rows for XLSX file

Ritz05 — Fri, 15 Nov 2024 22:06:55 GMT

Hi Team,

Using 2 components tFileExcelWorkbookOpen and tFileExcelsheetInput to read first sheet of .XLSX file after providing all configuration setting for both the component, I am getting

Zero data rows are populating in next component

excel from

tFileExcelsheetInput

. Please refer below screens.

Please help here.

Thanks

Re: tFileExcelSheetInput component reading Zero rows for XLSX file

KMoore1676025612 — Fri, 10 Feb 2023 10:48:58 GMT

There could be a few reasons why you're not getting any data rows in the next component:

Incorrect File Path: Make sure that you have provided the correct path to the .XLSX file. Check if the file exists in the specified location.
Incorrect Worksheet Name: Ensure that you have specified the correct worksheet name in the tFileExcelWorkbookOpen component.
Incorrect Data Range: Check if you have specified the correct data range in the tFileExcelsheetInput component. Make sure that the data range includes the cells that contain the data.
File Corruption: If the .XLSX file is corrupted, you may not be able to read its data. Try opening the file in Microsoft Excel to see if there are any errors.

Re: tFileExcelSheetInput component reading Zero rows for XLSX file

Ritz05 — Fri, 10 Feb 2023 13:49:54 GMT

Hi Team,

Thanks for responding.File is not corrupted.but when I try to process tis by selecting "Use header to config position of columns" I am getting this error.

java.lang.Exception: Try to configure column config for sheet: <sheet name> by header row but there is no row at row-index: 1.