thanks ScottF,
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.
Colur_to_headers.xlsx (8.8 KB)
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.