Convert excel inputs in JSON structures

[mattiagiupponi]

The client will provide an excel or a simple file with the structure there the value of the checks are placed inside the XSLX file.

The agreeded structure of the file is the following:

foglio	colonna_check	colonna_rel	desc
fiumi	BC	I,K	Controllo su portata concessa {I} uso potabile {K}

Where:

foglio -> is the name of the excel sheet
colonna_check -> is the position inside the seed file where the check is placed
colonna_rel -> is the position where the value that we are checking is placed in the sheet
desc -> is a description that the client wants to use for the log

As an example from the file DBI_A, sheet Fiumi the checks are placed from columns BD to BY

If the value of the check in column BD is 1 means that is wrong, so we can use the above schema to map know that the value of the check positioned in column BD is located in column I

[mattiagiupponi]

20241230 - mappatura formule inviato.xlsx