Hi Everyone
I must thank the Infragistics team and also the other active members who gave me a wonderful support during my previous posts. The help provided by you all made to complete the module perfectly. I am back here with new doubts.
I have a ultrawingrid and i should import the Excel file with data to ultrawingrid. I tried with many of the codes but nothing i found to be useful. I am using Excel 2007 and Netadvantage for .NET CLR 2.0. I found something very close to what i needed but it works only for previous versions of Excel 2007. The code which i tried is below
fileLocation = OpenFileDialog.FileName;
for .NET CLR 2.0
internalWorkbook = Infragistics.Excel.Workbook.Load(fileLocation);
It stands error on the 2nd line itself with a message
The specified stream or file does not contain a valid workbook. Parameter name: fileName
I dont know where i have gone wrong. Can anyone suggest me with some of the ideas to overcome this issue and acheive Importing the data to Excel
Thanks in advance
Ferdin