T Tasyo28 Member Licensed User Nov 8, 2021 #1 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 Last edited: Nov 8, 2021
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
