topic Re: [resolved] Warning and error excel in Talend Studio

[resolved] Warning and error excel

Anonymous — Tue, 08 Jul 2014 08:03:03 GMT

I'd like to decorate my excel sheet, like showcase the cells, etc.
I try to use an template but when i use it.
They are warning or error this:
Error:
The requested operation could not be performed on a file with a user mapped section open
Warning:
Warning: no filename property for drawing

Re: [resolved] Warning and error excel

Anonymous — Tue, 08 Jul 2014 08:19:21 GMT

Hi,
What's kind of docorating do you want to make? Could you please set an example with input and expected result?
Best regards
Sabrina

Re: [resolved] Warning and error excel

Anonymous — Tue, 08 Jul 2014 08:35:45 GMT

Hi,
What's kind of docorating do you want to make? Could you please set an example with input and expected result?
Best regards
Sabrina

Ok, like in this pic.
I used tsleep tools and the errors disappear but warnings remains.
Warning: no filename property for drawing
It works but there are warning when i try to update
Best regards,
G47

Re: [resolved] Warning and error excel

Anonymous — Tue, 08 Jul 2014 13:14:37 GMT

Hi,
The warning appear but the excel files is ok!!
Any idea to help me?
Best regards,
G47

Re: [resolved] Warning and error excel

Anonymous — Wed, 09 Jul 2014 04:40:18 GMT

Hi G47,
Is there any update for your issue? Because the post is set as resolved.
Best regards
Sabrina

Re: [resolved] Warning and error excel

Anonymous — Wed, 09 Jul 2014 13:50:03 GMT

This use case can easily be done with the component tFileExcelSheetOuput. You have to read in a template file (tFileExcelWorkbookOpen) and write in in with the activated option reuse style from the first written row.
Finally save it as new file with tFileExcelWorkbookSave.
http://www.talendforge.org/exchange/index.php?eid=1257&product=tos&action=view&nav=1,1,1
Take a look in the documentation.