Update excel file

One Star

Update excel file

Hi all,
I have a some XLS with data (ID|Name|originalDID|newDID, where ID is primary key) on sheet 'TranData'. Data for columns ID, Name, originalDID are known, newDID is empty.
I have a informix connection with request data from some magic system, where result is OriginalDID|NewDID. After tMap this data to XLS data I have a cram-full rowset: ID|Name|originalDID|newDID.
And, here is my problem, how to update data in XLS column newDID? I know create a new XLS file with resul, or I know create a new sheet in existing XLS. But I don't know how to update data on the existing sheet.
Community Manager

Re: Update excel file

You can output the final result to temporary file, then read/get new data from this temporary file and output them to the existing sheet of original excel file.
Best regards
Talend | Data Agility for Modern Business
One Star

Re: Update excel file

Hi shong,
thanks for your reply.
That's a good solution, but not acceptable for my problem. I have a XLS with sheet TranData (filled with primary data) and with formulas linked to another sheet. No chance to replace original sheet, because XLS Talend connections know create new or append to exists only. I need update data on one XLS sheet. That's my serious problem Smiley Happy
Best regards
One Star

Re: Update excel file

i am having 9 excel files in one folder does not have the same schema or same sheet names.
now I want to add a new sheet called "info" to all existing excel files.
can you please give me an idea how to do this?
One Star

Re: Update excel file

Hi This is Prashant.I Have 10 Records Excel File.And the Fields Names are First Name,Surname,Title, Gender,Year etc.Now I Want to Update Particular Row.For Example if the First Name is Smith i Want to Make it as John.Please Help me Regarding with this.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend