Processing of xls databases
BuildPlus can process .xls databases that meet these criteria:
- The worksheet must look like a database, with one row that contains the field names, then multiple rows of field values of a consistent type
- The first field should be the tagnames.
- Blank rows are not supported
- Fancy features, such as filters, drop-downs, macros, formats, are not supported and will cause problems in the processing
- For DBDOC, the XLS files may need to be modified to remove blank rows or any of the above mentioned features
- If you export your PI database into XLS format, DO NOT customize it
See also