[resolved] Warning and error excel

One Star G47
One Star

[resolved] Warning and error excel

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

Accepted Solutions
Seventeen Stars

Re: [resolved] Warning and error excel

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.

All Replies
Moderator

Re: [resolved] Warning and error excel

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star G47
One Star

Re: [resolved] Warning and error excel

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
One Star G47
One Star

Re: [resolved] Warning and error excel

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

Re: [resolved] Warning and error excel

Hi G47,
Is there any update for your issue? Because the post is set as resolved.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seventeen Stars

Re: [resolved] Warning and error excel

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.