Hi,
I'm looking for B4J developer to help me to automate the process of creating formulas for every totals or sub-totals in excel sheet (Possibly using jPOI).
(Initially all totals and sub-totals are in plain text, I want it to be in formula)
Needed.
- able to upload the excel files inside a folder (source folder and destination)
- Excel columns are fixed but records are dynamic.
- New output excel created after entering all formulas
The only challenge here is the groups are based in the number of dots in the first column image below.
I need a code snippet to do this or also can do the total solution please let me know.
Regards,
Tasyo
I'm looking for B4J developer to help me to automate the process of creating formulas for every totals or sub-totals in excel sheet (Possibly using jPOI).
(Initially all totals and sub-totals are in plain text, I want it to be in formula)
Needed.
- able to upload the excel files inside a folder (source folder and destination)
- Excel columns are fixed but records are dynamic.
- New output excel created after entering all formulas
The only challenge here is the groups are based in the number of dots in the first column image below.
I need a code snippet to do this or also can do the total solution please let me know.
Regards,
Tasyo
Last edited: