I have 2 seamingly identical excel files. Here is a portion of my code:
Dim iWorkbook As Infragistics.Excel.Workbook
....
Try iWorkbook = Infragistics.Excel.Workbook.Load(Me.lblDatafilePath.Text)Catch ex As Exception DisplayMsgBox("There was an error opening Excel Workbook. The error is: " & ex.Message) Exit SubEnd Try
.....
File, Test1.xls works fine. File Test2.xls fails on the Workbook.Load line with an error of: "The number of copies must be between 1 and 65535.Parameter name: value Actual value was 0."
I have compared the files using multiple XLS file compare utilites and they compare as identical. I'm at a loss!
Thanks
This looks like a bug in the Load logic. I would recommend submitting the issue to the support group: http://ko.infragistics.com/gethelp.