Index was out of range.Excel 97


#1

When I execute this command:

Worksheet sheet = excel.Worksheets[0];

in this context

Before the class:
Excel excel = new Excel();

In a class method:

string designerFile = “C:\InetPub\wwwroot\CTC.WebApp\ExtractUpdate\XLSheets\MassExtract.xls”;
excel.Open(designerFile);

Worksheet sheet = excel.Worksheets[0];

I get this message:

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Should I send you a copy of the sheet? It’s Excel 97.

Best Regards,
Michael Minadeo
IBM Global Services
Nissan Account


#2


Dear Michael,

Yes. Please send it to excel@aspose.com.

By the way, Laurence is working on the Excel 97 issues reported by you yesterday. Shortly he will reply.

Thanks for your patience.


#3

Ben,

Did you receive my e-mail? If so, how soon do you think this issue can be resolved?

I need to demo Aspose.Excel, incorpated into our developement site, using Excel 97, very soon. We are considering an Office Automation process that involves using an Exe running on web server to poll the message queue and create the Excel object and required spreadsheets upon request.

You and I both know that this approach is less that reliable.

I was hoping to demo Aspose.Excel to show management that there is a better way.

Best Regards,
Michael Minadeo
IBM Global Services
Nissan Account


#4

Dear Michael,

I got you sample file. It’s an Excel5.0/95 file.

Though Aspose.Excel support Excel95(BIFF7), most of advanced features are not kept up with product enhancement. I suggest you use Excel97 to open it and save as an Excel97 file, then have a try.

Thanks.


#5

Laurence,

Thanks.

After saving the file to the Excel97 format, I got past this line of code.

Thanks again,
Michael Minadeo
IBM Global Services
Nissan Account