I want to load Excel(.xls) and CSV file in Silverlight environment. I have able to load Excel(.xls) file using Infragistics.Excel but CSV is throwing some Format Exception. Could you please providate a sample application showing loading of both Excel formats.
I have to read CSV file using infragistics in C# code , we are doing for excel file and it works perfectly but CSV format file is not working . May you please provide us some sample code to read CSV file using Infragistics.
Reading a CSV file into and excel workbook is still a new product idea and you can submit your idea on our new ideas site. AS such you would need to manually read the CSV file yourself by opening the file, reading the lines and splitting each line on the delimiter. You could then create a workbook manually and set the value of each cell based on what you read.
As reading a CSV isn't specific to Infragistics there are many examples online including Reading CSV file and storing values into an array on StackOverflow. Once you have the values in a list, simply loop through the values and set the value of the relevant cells in the workbook. A good example to use as a guide is the Populating a Worksheet from a DataSet in our help.
Anil and Elena were talking about the ability to read CSV using the Infragistics.Documents.Excel API some 7 years ago. Is this still not available? Has anyone officially logged it as a feature request? Do you know timescales on when this will be available? Are any of your devs working on this or is it a pipe dream?
I have just upgraded one of our applications to 18.1 and surprised to not see this available:
"Invalid or unrecognized file format."
I see you have given an alternative option of reading CSV file and storing into an array but really this needs to be part of your API because xls is not the only file extension in Microsoft Excel.
You can use zetexcel.com to load Excel(.xls) file using Infragistics.Excel.