Getting an error as Providing input table is not a valid XLS control table, while doing colour to the column headers as below workflow colur_to_Headers.knwf (14.3 KB)
I think the error message pretty much tells the tale here. I used a String Manipulation node to remove the +? characters and everything seemed to work fine. I think you could replace the +? characters again at the end of the workflow right before your Excel Writer .
So your solution was saying that need to use 2 String Manipulation nodes at one from starting and another from ending before writer node. okay i will try in that way.
need another help @ScottF can you give me another solution where in the given excel sheet has column “Amount” once i load in knime it changes to double type format but again when i retrieve that data into excel writer it is changing into still integer only.
amount column has “Double” format while it is in knime workflow. but when i tried to deploy the data in excel sheet amount column was showing “Integer” format. let me know the solution.
i tried this workflow from knime where the excel file having a column named as “Amount” the data type was storing as “Integer” but inside knime workflow i changed to “Double Format”, so it is changing the data type.
But while i appending into excel sheet the date of column “Amount” still data type was "integer only.
I think you could try the Column Expressions node for this as well, although you’d have to have multiple expression inside to account for the various columns you want to update.
I believe this is just a formatting issue in Excel, which often doesn’t respect data types in the way we would hope. If you change the formatting in Excel from “General” to “Number” it will display like you want it to.
still i am facing issue why the column “Amount” data type was not changed. while it loaded in workflow where in knime it is changed to “Double” but still when i deployed it is not changed still it was as Integer format.
I think we are talking in circles a bit. You likely won’t be able to change the format of how the number appears. From what I can tell, this is an Excel issue, not a KNIME limitation.
The only way I can think of that might be a workaround is what I mentioned above about the XLS Cell Formatter, but I’ve not had time to try it out myself yet.
From Knime workflow where a column as “Amount” data type is showing “Double” but once it appended into excel workbook, data type was changed.(it is not showing as Double ).
→ I am getting a data from email and i directly saved data into one excel sheet and loaded into excel reader node after that i changed the data type of column Amount to Double and then appended into Excel workbook but the same column Amount data type was not be as “Double”.
→ my main concern once a datatype was assigned in knime workflow, why it should be changed the same datatype while it appended back to excel sheet.
please confirm me whether a sample data coming source i.e from mail, while pasting entire data into excel sheet without proper format and save that excel. then load the same excel file into excel reader and changed every column data type in knime, and then once that data was appeneded into excel sheet again datatype was not changed.
→ i.e in knime work flow data type was changed but in excel sheet it didn’t changed.