We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Write multiple Collections to excel sheet

Thread ID:





128437 Jan 21,2017 08:05 AM UTC Jan 25,2017 05:10 AM UTC Xamarin.Forms 3
Tags: XlsIO
Sasan Pasha
Asked On January 21, 2017 08:05 AM UTC

hi , 
i am new to this control and am trying to understand how to write a collection which has another collection inside it and write to excel sheet - I found that this method "ImportData" is used to dump the data to excel sheet but it doesn't work if i have another collection inside my first collection. do i have to write for loops ? 

essentially I want to be able to programmatically create a range of cells and assign the value of each cell to my collection.  so for example I have a list of cars with CarName and CarPlateNumber and another list called InfractionDates that needs to be printed in the excel as below 

    public class Data

        public string VehicleName { get; set; }

        public string PlateNumber { get; set; }

        public IEnumerable<DateTime> InfractionDate { get; set; }


VehicleID PlateNumber Date Time
Honda 126MSF 30-Sep-16 3:52:00 PM
Honda 126MSF 1-Oct-16 1:01:00 AM
Honda 126MSF 2-Oct-16 1:10:00 AM

VehicleID VehicleID Date Time
Mazda 293WVM 30-Sep-16 1:02:00 AM
Mazda 293WVM 1-Oct-16 12:23:00 AM
Mazda 293WVM 2-Oct-16 1:10:00 AM

if you can point me to a sample that I can create above output programmatically would be great ...

Abirami Varadharajan [Syncfusion]
Replied On January 23, 2017 12:16 PM UTC

Hi Sasan, 

Thank you for contacting Syncfusion support. 

We have prepared sample to import data from a collection which has another collection. The sample can be downloaded from following location. 

Kindly refer and let us know if your requirement is fulfilled. 


Sasan Pasha
Replied On January 24, 2017 11:59 PM UTC

Thank you so much. it certainly clarified a lot of things for me.

Many thanks 

Abirami Varadharajan [Syncfusion]
Replied On January 25, 2017 05:10 AM UTC

Hi Sasan,
Thank you for updating us.
We are glad that your requirement is fulfilled. Please let us know if you need any further assistance.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon