topic Re: How can I write in this excel file? in Data Quality

How can I write in this excel file?

Denisa_Itu — Fri, 15 Nov 2024 23:43:08 GMT

Hi. I work in Talend with version 7.2 and I would like to make an insert in an excel file, but this file has a few blocked columns. But this file has a few blocked columns. It has these columns because I put them in manually. And when I run this job next time, I want these columns to stay locked.

How can I solve this in Excel?

Re: How can I write in this excel file?

Anonymous — Fri, 24 Sep 2021 05:25:52 GMT

I am not sure i understand your problem well, maybe you need to specify the First cell X and First Cell Y value? To do, check the 'Is absolute Y pos' box on the basis settings panel of tFileOutputExcel.

Regards

Shong

Re: How can I write in this excel file?

Denisa_Itu — Tue, 28 Sep 2021 05:52:38 GMT

Hi, thanks for answering. I'm an excel file. You can manually block a few columns, and leave one to allow you to make changes to it. I know this. The idea is that when I read this file I want those columns to remain locked and the data to be overwritten. But the moment I put this file in Talend and run the job, it creates another file for me and I want it to be overwritten.

Re: How can I write in this excel file?

Denisa_Itu — Tue, 28 Sep 2021 05:58:57 GMT

The job is quite simple. I read from a firebird database, map the necessary columns and export them to an excel file.