Load Excel and CSV file

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

Anil Kumar

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.

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

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://www.infragistics.com/community/ideas

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.

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

You can use zetexcel.com  to load Excel(.xls) file using Infragistics.Excel.