Using Project Specific Custom XML Template (Magic xpi 4.14)
The default template files OfficeComXMLTemplate.tpl and XMLTemplate.xsd, used by Magic xpi for creating XML output from Excel, are located in the <Magic xpi Installation>\Runtime folder. It is strongly recommended not to modify these default files, instead use a copy of these files.
Follow the steps given below to use the custom templates:
-
Copy the files OfficeComXMLTemplate.tpl and XMLTemplate.xsd to a different directory. This directory can be within the project or located anywhere on the disk.
|
|
Keep the original names of the files as renaming of these templates is not supported.
|
-
Modify these files as per the business requirement.
-
In Studio, create a variable in the project with name OfficeComFolder and its value pointing to the path to the directory created above.
For example if you create a directory named OfficeCustomTemplates within the project, you can set the value for OfficeComFolder variable as
%currentprojectdir%OfficeCustomTemplates%sl%
If the directory is outside the project, point the variable to the absolute path of the directory.
The Magic xpi runtime will now load these custom templates for the project instead of the default one.
