I get an exception deep in Aspose when opening the attached password-protected xlsx file. Excel appears to open it without a problem. The problem showed up when a potential customer submitted the file. I’ve done light editing of the file to remove sensitive information and changed the password - the symptoms when trying to open are still the same.
A simple console app that reproduces the problem is at the end of this message - password is in plaintext in the code. Please keep me posted as to the problem and any potential workarounds; we will lose this customer if we can’t import the data.
Thanks,
-Steve
using System;
using System.IO;
using Aspose.Cells;
namespace AsposeTest
{
class Program
{
static void Main(string[] args)
{
const string fileName = @“…....\TestData\Test.xlsx”;
const string password = “aspose”;
LoadOptions options = new LoadOptions(LoadFormat.Auto);
options.Password = password;
try
{
Workbook workbook = new Workbook(fileName, options);
Console.WriteLine(“FILE OPENED SUCCESSFULLY”);
}
catch (Exception e)
{
Console.WriteLine(“ERROR OCCURRED:\n” + e);
}
}
}
}