Overview
Anchanto WMS saves Excel reports with the .xlsx file extension, which matches their actual file format. Reports open directly in Excel without a format-and-extension mismatch warning. Scripts, integrations and scheduled jobs can read the files without being blocked. The data, columns and layout of your reports stay exactly the same.
Prerequisites:
- No new setup is needed. You generate reports the same way you always have.
- If any automations, email rules or integrations look for report files ending in .xls, update them to .xlsx (see Update Your Automations and Integrations below).
Step-by-Step Instructions
Generate and Open an Excel Report
- Go to the report you need → Select the Excel “xls” format → The report is set up to generate in Excel format, as before.
- Go to the report you need → Click Generate, then download the report → The file is saved with the .xlsx extension.
- Go to your downloaded report file → Open it in Excel → The file opens directly, with no format warning.
Update Your Automations and Integrations
- Go to any automation, email rule or integration that looks for “.xls” report files → Update the file filter or reference to “.xlsx” → Your processes pick up the new report files without interruption.
Use this table to find what may need updating:
| Where to check | What to update |
|---|---|
| Automated scripts or tools | File-name filters such as *.xls used to pick up, rename or parse reports |
| Email rules | Rules that sort, forward or save report attachments by file extension |
| Integrations (ERP, BI, SFTP jobs) | Import jobs that expect report files ending in .xls |
| Macros or shared folder logic | References to report files by their .xls name |
Tip: A filter such as *.xls* matches both older .xls files and newer .xlsx files, so one rule can handle both.
Important Notes & Limitations
- The change applies to all customers and to every report generated in the Excel “xls” format, including Any Report.
- Only the end of the file name changes. The report content, layout and data stay exactly the same.
- Reports generated before this change keep their original .xls name.
- If you use Excel 2003 or earlier, you’re no worse off than before.
- Update any automations, email rules or integrations that look for “.xls” files so they look for “.xlsx”.
Comments
0 comments
Article is closed for comments.