Hi,
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.
Thanks
Anil Kumar
Hello Anil Kumar,
Currently our Infragistics Excel Engine supports load/save for the files with .xls and .xlsx extensions, so the loading of the CSV file has been determined to be a new feature request. I have sent your feature request directly to our product management team. Our product team chooses new feature requests for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your reference number for this feature request is FR13441.
Thank you for your request.
Hello Elena,
I am having some trouble loading the csv file and I just found this entry. I would like to know if there is a solution for this problem.
Thank you
Hi Alan,
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.
Kind regards,
Andrew
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.
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.
Marta,
If you would like our excel engine to support CSV files then you can log a product idea for this on our ideas site:
https://es.infragistics.com/community/ideas