[resolved] Warning and error excel

One Star
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
Highlighted
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.

View solution in original post


All Replies
Highlighted
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.
Highlighted
One Star
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
Highlighted
One Star
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
Highlighted
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.
Highlighted
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.

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog