Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 fromtFileExcelsheetInput
. Please refer below screens.Please help here.
Thanks
There could be a few reasons why you're not getting any data rows in the next component:
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.