I'm trying to use the Infragistics.Excel library to load an excel file into an Infragistics.Excel.Workbook object. I am using the 2008.3.2102 version targeting the 2.0 framework. This is the line of code I'm using:
Infragistics.Excel.Workbook wb = Workbook.Load(this.txtExcelFile.Text);
And this is the error I'm getting:
The value of argument 'value' (195) is invalid for Enum type 'PaperSize'.Parameter name: value
Any ideas out there what I'm doing wrong? I am able to load this file into a datatable using the Microsoft.Jet.OLEDB method just fine.
Thanks,
Justin
My workbook had a worksheet in it that didn't have the PaperSize set. Setting PaperSize fixed the issue.