[resolved] Warning and error excel

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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.