XLSIO to Grid

[Simon Webster]

Hi, 

I am quite new to this. Is there an example or some tips that anyone has for using https://www.syncfusion.com/products/file-formats/xlsio to open an excel file in to a grid? eg SFDataGrid

My target is to develop for Android / IOS, using Xamarin. 

My Excel will always have the same sheets of known name, and I'd like to be able to read specific sheets. I'm pretty lost at how to open an excel, read the data from a specific sheet and display it in a grid

Simon

[Dilli Babu Nandha Gopal]

Hi Simon,  

  

Thank you for contacting Syncfusion support.  

  

Using XlsIO, we have prepared a sample to read the data from excel file and bind it programmatically to the grid in Xamarin.Forms. The sample can be download from the below link.  

  

Sample Link: https://www.syncfusion.com/downloads/support/forum/124469/ze/Sample-840048819   

  

Please let us know whether the sample fulfil your requirement.   

  

Regards,  

Dilli babu 

[Felique]

Hi,

The examples has a error  in the using Syncfusion.XlsIO   ...  look the picture please, i am stuck

[Abirami Varadharajan]

Hi Felique, 

 

The assemblies referred to the sample is not available in the mentioned location, and so the error is shown. We request you to refer the assemblies Syncfusion.XlsIO.Portable.dll and Syncfusion.Compression.Portable.dll to the sample to resolve this error. 

 

We also request you to upgrade to our latest version (15.1.0.33) of Essential Studio which has more bug fixes and enhancements which is available for download under the following link.    

https://www.syncfusion.com/forums/128853/essential-studio-2017-volume-1-release-v15-1-0-33-is-available-for-download  

 

The assemblies will be available under the following location in your machine. 

 

$system drive: \ Program Files\Syncfusion\Essential Studio\$Version # \Xamarin\lib\pcl 

Eg : $system drive:\Program Files (x86)\Syncfusion\Essential Studio\15.1.0.33\Xamarin\lib\pcl 

 

Please let us know if you have any concerns. 

 

Regards, 

Abirami.