topic [resolved] tFileOutputExcel support xlsx, File overwrite ? in Talend Studio

[resolved] tFileOutputExcel support xlsx, File overwrite ?

Anonymous — Sat, 16 Nov 2024 13:11:07 GMT

My questions ?
1. Does tFileOutputExcel supports xlsx files, if yes then how because file gets generated but I am getting error while opening in MS Excel Application ?
2. Does tFileOutputExcel supports file overwrite operation i.e if file with same name exist it overwrite older file with newer one ?
Attached is a sample job

Re: [resolved] tFileOutputExcel support xlsx, File overwrite ?

Anonymous — Thu, 09 Dec 2010 08:56:43 GMT

Which version of TOS yopu are using
beacause when we declare the path of the output file there we get an option for xlsx also
regards
Honey

Re: [resolved] tFileOutputExcel support xlsx, File overwrite ?

Anonymous — Thu, 09 Dec 2010 09:37:55 GMT

Which version of TOS yopu are using
beacause when we declare the path of the output file there we get an option for xlsx also
regards
Honey

I am using TOS 4.0.0 and I don't see any such option

Re: [resolved] tFileOutputExcel support xlsx, File overwrite ?

Anonymous — Thu, 09 Dec 2010 14:27:03 GMT

In TOS 4.1.0 we have an option write to Excel2001

Re: [resolved] tFileOutputExcel support xlsx, File overwrite ?

Anonymous — Mon, 13 Dec 2010 10:23:28 GMT

So it will be seamless to switch to a newer TOS version, how it does effects jobs built in an older version ?
And what about tFileOutputExcel supports file overwrite operation ?

Re: [resolved] tFileOutputExcel support xlsx, File overwrite ?

Anonymous — Wed, 15 Dec 2010 07:32:50 GMT

there is complete compatibility with the version it wont affect ur job at all
and yes there is also an option to overwrite the file