Providing input table is not a valid XLS control table

[IJpin_02]

hi Kathrin,

thanks for the help, this solution works me.

[IJpin_02]

@Kathrin,

please can you help me on the data type issue please.

[Kathrin]

Hi @IJpin_02 ,

have you tried the option the options with XLS Cells Formatter node that Scott mentioned?
That would be also my first idea.

Cheers
Kathrin

[IJpin_02]

yes @Kathrin,

Nothing changes. still the column “Amount” was not changed.

→ in Knime workflow data type was changed but in excel spread sheet it didn’t changes.

→ my exact point here is AMount column need to be in “Accounting” format. where while loading excel data without format but output need to be in “Accounting format”

[Kathrin]

I gave the XLS Cell Formatter a try. Unfortunately there is no option to select the type Accounting. So it looks like this is currently not possible.

Would the cell type Custom with a double value, e.g. “2,00” be sufficient for your use case?

[IJpin_02]

yeah if it is “double” then it is fine
it looks same as “Accounting” format

if possible can you send workflow

[Kathrin]

Here is a small example workflow using the XLS Cell Formatter node.

Excel Formatting to Double – kathrin

Cheers
Kathrin

[IJpin_02]

Hi kathrin,

the above workflow is helping my situation.

but @Kathrin can you please guide me on automatically select the excel sheet names as well the excel file (Path).

→ i can able to choose the Excel file(path) through excel reader node as selecting a variable name : “Path”, but every time i need to select the sheet name as manually.

is there anyway to select the excel sheets automatically with filename( selecting Both excel sheets & file path as automatically)

[IJpin_02]

Hi @Kathrin,

for the workflow “Excel Formatting to Double” it is working fine for all the integer column values are changed to double.

I mean if two columns are there in Integer then both are changing into double. But i need only one column to be changed to Double remaining columns need to be as it is.

Provide some assisitence

[IJpin_02]

Hi @Kathrin,

please can you sugest something on here because almost the task was going to complete.

we need to modify just slight things

[Kathrin]

Hi @IJpin_02,

regarding the type for the double and the integer columns. My tip here is to use two different tag values: One for the columns of type integer and one for the columns of type double. Next you only need to adjust the data type for the cells with the tag value of the double columns. I gave it a try it works

Regarding the automatic sheet selection. Are you familiar with the concept of flow variables? If not I can recommend our free self-paced L2 courses and the flow variabel guide:
https://docs.knime.com/latest/analytics_platform_flow_control_guide/index.html#creating-local-flow-variables
They are the key for the automation In this case you might want to look into the flow variable tab (the section “Exporting a node configuration as flow variable” in the guide explains how it can be used to create a flow variable).

Cheers
Kathrin