I am new to Knime.
I currently have spreadsheet A with a formula in a specific cell.
I would like to run a workflow where the excel formula is input into the spreadsheet by Knime instead of excel. The formula also has to go into a specific cell ie not all rows or columns.
So we would :
1.Start with a blank template (File Reader)
2. Connect nodes to the file reader
3. Use node to input excel formula into output data in a specific cell
Can anyone please help ?
@jasonk2022 you can use OpenPyxl to insert Excel formulas with the help of KNIME:
thanks ill take a look.
seems complex for someone like me however I will try
There is a chance that the package OpenPyxl will be part of the (new) Bundled Python integration (we are counting on you @carstenhaubold - KNIME Analytics Platform - 4.6.0 Preview - #11 by carstenhaubold )
Yep @mlauber71, we want to do that for the December release
I havent got access to Python therefore that solution will not work.
I need to transpose an excel formula from one spreadhseet ( from a specific cell) and then input that into a separate spreadsheet again into a specific cell
input that formula into a specific cell for my output table
I have tried using column expression, rule engine and math formula modes but have become stuck
Can anyone please assist ?
Or you could approach this the other way around and use the “write to excel template” node to update your data values for selected cells while leaving the existing formatting of the spreadsheet / formulas in other cells intact.
I believe that you will find this the much easier and robust approach.
Not quite sure if it is the same with the normal Excel Writer,
But if you start a string column with = you can also write formulas directly with the template writer.
=1+1 will put that formula into Excel (formula has to be in english format)
That is awesome @AnotherFraudUser! I will definitely be adding this trick to my current project today.
The idea is really interesting but my excel looks like this
Your calculation is working without any manual adjustment? Did not see any escape
@Daniel_Weikert… you are correct
Tested it on my private computer on openoffice…which handles it differently it seems
Well when I open it with Excel I get the same result as you do…sorry for the wrong info!
Well at least my Excel Template Writer works as I remember
KNIME_project9.knwf (17.2 KB)
Thanks for the clarification. I was struggling with the standard Excel Writer node as well, but your write to template node is working great.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.