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.
Hi Elena,
I am facing issue in reading the Excel file. Could you please give me sample application which reads the excel file and creates the Datatable.
Thank you
Hello Anil,
Please find the attached sample, where I show you a possible approach to read the data from Excel file. In my sample I store the data in ObservableCollection, however you can use a different container depending on your scenario. I can suggest you use the properties Rows and Columns of the Worksheet which allow you iterate along the document and the cells in it.
If you have any further questions with this, please do not hesitate to ask.