The interface to Customize_Excel_Editor.dll has been significantly extended in order bring the ability to read data from the workbook and write data to database at the time a project is saved.
When you bring changes to a project or create a new one, right before the project is saved to databases, the function BeginProjectSaving() is called.
The Number is the project number. Using this new function, you can read data from the workbook before they are written to the database and potentially adapt what is to be written.
You must list the fields you want to read from in a sheet named Excel_Editor in the Template.xlsx file.
This sheet must contains two columns as follows:
In Property name, you list properties which are then accessible from code using:
Properties are objects meaning that you may pass strings, numbers or dates.
To write directly to databases fields from your customized code, you can call: