Generates a loader specification XML file to load Excel data from the specified Excel worksheet to a database table.
The generated loader XML file is placed in <install-root>/custom/loader with a file name of load-<sheet-name>.xml. The table drop and create JACL script is generated in <install-root>/custom/loader/scripting with a file name of Loadscript-<sheet-name>.jacl. The input Excel file should be placed in <install-root>/custom/data.
generate loadspec for sheet [<sheetName>] from file [<xls fileName>]
SheetName—Excel worksheet from which to load data
xls fileName—Name of the XLS file from which the SheetName is taken