open and read excel

[Johnny van Aardt]

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]

attachment

[Sridhar Sukumar]

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]

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]

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 

1. Set Linker options to Sdk Assemblies Only
2. 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]

Hi, 

 

Thank you for the support. It solved my problems 

Regards 

 

Johnny