Fetch Line_Number from Excel file using Talend

[AbhishekBoga]

Hi All,

This is my first post and hope so expecting a positive response on my query.

I am working on a requirement where I have to extract data from Excel, convert into CSV then convert into JSON and than load into snowflake table. I am able to achieve all above things but where I stuck on below 2 things :

1. How to fetch excel line_number from each sheet in a single excel file. 

2. Read all Line_number from all the sheet of a single CSV file

Find the attached screenshot where i want to read excel line_number (Attachment name: "Excel Line Number" hightlighted in blue which starts from 2) and create a CSV file. So let's say an Excel File is having 3 sheets, each having 10 records, so my final CSV should look like as per the attachment (name: "Target CSV File")

I hope my requirement is clear to understanding the query. Please let me know how i can achieve this handling.

[Anonymous · Accepted solution]

Hello

I suggest tJavaRow to implement line numbers 

Find attached a sample job

talendJob.zip

[AbhishekBoga]

Thanks dgm01.

Your solution worked for me...