Working with Spreadsheets
PIFOP offers a limited support for spreadsheets files (.xlsx).
- Spreadsheet files can be uploaded to a project, but they cannot be edited through PIFOP.
- Spreadsheet files can be referenced within script files.
- Spreadsheet files are not supported by GLPSOL nor NEOS, only by PIFOP Optimization Servers.
- The AMPL folder in the Optimization Server must contain the file amplxl.dll, which can be downloaded from here.