tFileExcelSheetOutput / tFileExcelWorkbookOpen - 2 questions

One Star

tFileExcelSheetOutput / tFileExcelWorkbookOpen - 2 questions

Hello,
I am trying to create a new excel file and insert a hyperlink that references a cell on another excel spreadsheet..
Firstly, I cannot work out how to create a new Excel workbook using tFileExcelWorkbookOpen and tFileExcelSheetOutput.
In tFileExcelWorkbookOpen if I select 'Create empty workbook' it does not give me a filename / location to create it. 
If I instead uncheck the 'Create empty workbook' option and enter a filename, when I run it, I get an error saying it does not exist.
How do I do this please?
Second, I want to include a hyperlink in my output referencing another workbook, sheet and cell (actually the original source of the data)
The string is output in the format:
c:\temp\filename.xlsx#'Calls'!A43
where Calls is the sheet, and A43 is the cell I want to hyperlink to. 
but this is failing when it is parsed by the URI Parser when I run it.
Does this component support this kind of hyperlink?
If this was entered manually in excel in the style:
=HYPERLINK("c:\temp\filename.xlsx#'Calls'!A43")
it would create a hyperlink to that cell.
Many thanks
Ian
One Star

Re: tFileExcelSheetOutput / tFileExcelWorkbookOpen - 2 questions

Ok.. answered my own question for #1..
I need the tFileExcelWorkbookSave component... 
Still having trouble with the hyperlink though.. Any help would be appreciated.
Ian
Seventeen Stars

Re: tFileExcelSheetOutput / tFileExcelWorkbookOpen - 2 questions

Active the individual column configuration and set the option Hyperlink for your hyperlink column.
This component has a lot of features. Perhaps you read the documentation linked in the detail page:
https://www.talendforge.org/exchange/index.php?eid=1257&product=tos&action=view&nav=1,1,1

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch