I’m having an issue with Aspose Cells for Reporting Services. When I export in format Excel2007xlsx and open the file in Excel I get an error Excel Cannot open the file ‘xxxx.xlsx’ because the file format or file extension is not valid.
image.png (3.4 KB)
This only occurs when I set a password for the file in the configuration file as follows:
If I omit the password (I can leave all other settings the same) the file opens okay. We need the password to work. This is with version 21.11 of Aspose Cells for Reporting Services. We currently use version 19.5.4 and this works fine with no error (on SSRS 2016). We are migrating to a new server running SSRS 2019 and so are looking to move to the latest version. This is running as an evaluation version currently on the new server as we are in the process of renewing our support agreement.
The entire contents of Aspose.Cells.Reporting.Services.xml is below.<?xml version="1.0" encoding="utf-8"?>