XLS Formatter input file and out file variables

Hi

I have created a workflow to write multiple excel files and color the first few rows of every excel file using Continental extension (XLS Formatter).

My problem is I can’t find way to pass dynamic path of excel (links to excel file name and file location where node Excel writer is writing to ) to “Input File” and “Output File” of this node.

I have looked in to few of examples but I am still can not figure it out how to make this happen.

Do you have any comment / suggestion of where I should look into?

Thks a lot

Hi kengdeb,
I guess the XLS Formatter node does not support the new path type. So you need to convert it to a string using the Path to String (Variable) node between the Excel Writer and the XLS Formatter node.
Bye
Tobias

2 Likes

You could check out various ways to use and import Excel Files. Maybe the examples can help you

1 Like

Hi

Thks a lot. It works.

Regards

1 Like

Hi

The configuration in your share workflows looks very interesting.

Thks for sharing.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.