open and read excel

Question

Hi,

 

I want to open a excel spreadsheet. Read the first column
into and array. The sheet name is “SalesPerson”. Can you please give me an
example that will work on an android device.

 

I tried the following

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using Android.App;

using Android.Content;

using Android.OS;

using Android.Runtime;

using Android.Views;

using Android.Widget;

using System.Collections;

using Syncfusion.XlsIO;

 

using NU_CRM;

 

 

namespace NU_CRM

{

    public class GetXdata

    {

       
[System.Security.SecuritySafeCritical]

        private ArrayList RepName;

        private ArrayList Speciality;

        private ArrayList DoctorName;

        private ArrayList
HospitalName;

        private ArrayList
ProductName;

       
String xlDocName = @"/storage/emulated/0/nu-data/data.xlsx";

        

        //string ConfigFile =
Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal),
"config.xls");

        //==================
Get reps ===========================

        public ArrayList
RepaddData()

        {

           
RepName = new ArrayList();

           
var sheetName = "SalesPerson";

           
//
Existing tab name.

 

           
System.IO.MemoryStream mStream = new
System.IO.MemoryStream(System.Text.Encoding.UTF8.GetBytes(xlDocName));

 

           
using (ExcelEngine
excelEngine = new ExcelEngine())

           
{

               
IWorkbook workbook = excelEngine.Excel.Workbooks.Open(mStream);

               
IWorksheet worksheet = workbook.Worksheets[0];

               
string cellinfo = worksheet["A1"].Text;

 

               


            }

               
return RepName;

        }

 

 

When I put a breakpoint at string cellinfo = worksheet 
the value of cell info is "/storage/emulated/0/nu-data/data.xlsx"

Padmini Ramamurthy · Answer

attachment

Sridhar Sukumar · Answer

Hi Johnny, 
 
Thank you for contacting Syncfusion support. 
 
We have prepared a sample to read the worksheet values using XlsIO in Xamarin.Android platform. The sample can be downloaded from the following link. 
 
Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Sample1560009131.zip 
 
Please let us know if you have any concern. 
 
Regards, 
Sridhar.

Pon Geetha A J · Answer

Hi Sridhar, 
 
The sample you send works perfect. Thanks. If I add the sample code to my project. It compiles and if I run the app I do get the following exception error. 
 
  
 
My file with the code is attached. The function is at line 188 
 
Can you please help 
 
Thanks 
 
Johnny SettingsActivity

Mathu Mohan Vijayakumar · Answer

Hi Johnny, 
 
The Exception occurs when the Linker behavior is set to None or Link all assemblies. So, we request you to set the following options to resolve the exception. 
 
Go to Project Properties -> Android Options 

Set Linker options to Sdk Assemblies Only
Add Syncfusion.XlsIO.Portable assembly in Skip Linking assemblies 
 
Screenshot: 
  
 
For reference we have shared below the KB documentation link. 
 
KB Documentation Link: https://www.syncfusion.com/kb/7773/how-to-resolve-type-initialization-exception-in-xamarin-ios  
 
Please let us know if you have any queries. 
 
Regards, 
Mathu Mohan V A

Pon Geetha A J · Answer

Hi, 
 
Thank you for the support. It solved my problems 
Regards 
 
Johnny