void ImportArrays(Worksheet worksheet)
{
    // Create an array containing string values.
    string[] array = new string[] { "AAA", "BBB", "CCC", "DDD" };

    // Import the array into the worksheet and insert it horizontally, starting with cell B1.
    worksheet.Import(array, 0, 1, false);

    // Create a two-dimensional array containing string values.
    String[,] names = new String[2, 4]{
    {"Ann", "Edward", "Angela", "Alex"},
    {"Rachel", "Bruce", "Barbara", "George"}
         };

    // Import the two-dimensional array into the worksheet and insert it, starting with cell B3.
    worksheet.Import(names, 2, 1);

}

Private Sub ImportArrays(ByVal worksheet As Worksheet)
    ' Create an array containing string values.
    Dim array() As String = {"AAA", "BBB", "CCC", "DDD"}

    ' Import the array into the worksheet and insert it horizontally, starting with cell B1.
    worksheet.Import(array, 0, 1, False)

    ' Create a two-dimensional array containing string values.
    Dim names(,) As String = {
        {"Ann", "Edward", "Angela", "Alex"},
        {"Rachel", "Bruce", "Barbara", "George"}
    }

    ' Import the two-dimensional array into the worksheet and insert it, starting with cell B3.
    worksheet.Import(names, 2, 1)
End Sub

byte[] imageBytes1 = File.ReadAllBytes("images//img.png");
byte[] imageBytes2 = File.ReadAllBytes("images//x-docserver.png");
// ...
    Workbook workbook = new Workbook();
    workbook.BeginUpdate();
    try
    {
        Worksheet worksheet = workbook.Worksheets[0];
        worksheet.Clear(worksheet.GetUsedRange());
        worksheet.Cells["A1"].ColumnWidthInCharacters = 35;
        worksheet.Cells["A1"].Value = "Import data from List vertically:";
        ImportList(worksheet);
    }
    finally
    {
        workbook.EndUpdate();
        workbook.SaveDocument("result.xlsx");
        Process.Start(new ProcessStartInfo("result.xlsx") { UseShellExecute = true });
    }
    workbook.Dispose();
}
// ...
void ImportList(Worksheet worksheet)
{
    // Create a List object containing string values.
    List<string> cities = new List<string>
    {
        "New York",
        "Rome",
        "Beijing",
        "Delhi"
    };

    List<byte[]> imageList = new List<byte[]>();
    {
        imageList.Add(imageBytes1);
        imageList.Add(imageBytes2);
    };

    // Import the list into the worksheet and insert it vertically, starting with cell B1.
    worksheet.Import(cities, 0, 1, true);

    // Import the image list into the worksheet and insert it vertically
    worksheet.Import(imageList, 0, 2, true, new DataImportOptions());
}

Private imageBytes1() As Byte = File.ReadAllBytes("images//img.png")
Private imageBytes2() As Byte = File.ReadAllBytes("images//x-docserver.png")
' ...
    Dim workbook As New Workbook()
    workbook.BeginUpdate()
    Try
        Dim worksheet As Worksheet = workbook.Worksheets(0)
        worksheet.Clear(worksheet.GetUsedRange())
        worksheet.Cells("A1").ColumnWidthInCharacters = 35
        worksheet.Cells("A1").Value = "Import data from List vertically:"
        ImportList(worksheet)
    Finally
        workbook.EndUpdate()
        workbook.SaveDocument("result.xlsx")
        Process.Start(New ProcessStartInfo("result.xlsx") With {.UseShellExecute = True})
    End Try
    workbook.Dispose()
    ' ...
Private Sub ImportList(ByVal worksheet As Worksheet)
    ' Create a List object containing string values.
    Dim cities As New List(Of String) From {"New York", "Rome", "Beijing", "Delhi"}

    Dim images As New List(Of Byte()) From {imageBytes1, imageBytes2}

    ' Import the list into the worksheet and insert it vertically, starting with cell B1.
    worksheet.Import(cities, 0, 1, True)
    worksheet.Import(images, 2, 1)
End Sub

using DevExpress.Spreadsheet;
using System.Collections.Generic;
// ...

void ImportListValues(Workbook workbook) {
    Worksheet worksheet = workbook.Worksheets[0];

    // Create a list of the most populated cities.
    var cities = new List<City>()
    {
        new City(){ Name = "Tokyo", Country= "Japan", Population = 37393128 },
        new City(){ Name = "Delhi", Country= "India", Population = 30290936 },
        new City(){ Name = "Shanghai", Country= "China", Population = 27058480},
    };

    // Insert list values into the worksheet.
    // Data starts with the B1 cell.
    worksheet.Import(cities, 0, 1);
    // Apply the number format to the "Population" column. 
    worksheet["D1:D3"].NumberFormat = "_(* #,##0_);_(* (#,##0);_(* \" - \"??_);_(@_)";

    // Import values from specific data source fields.
    // Data starts with the B5 cell.
    var importOptions = new DataSourceImportOptions()
    {
        PropertyNames = new string[] { "Name", "Population" }
    };
    worksheet.Import(cities, 4, 1, importOptions);
    // Apply the number format to the "Population" column.
    worksheet["C5:C7"].NumberFormat = "_(* #,##0_);_(* (#,##0);_(* \" - \"??_);_(@_)";
}

class City
{
    public string Name { get; set; }
    public string Country { get; set; }
    public int Population { get; set; }
}

Imports DevExpress.Spreadsheet
Imports System.Collections.Generic
' ...

Sub ImportListValues(ByVal workbook As Workbook)
    Dim worksheet As Worksheet = workbook.Worksheets(0)

    ' Create a list of the most populated cities.
    Private cities As New List(Of City)() From {
        New City() With {
            .Name = "Tokyo",
            .Country= "Japan",
            .Population = 37393128
        },
        New City() With {
            .Name = "Delhi",
            .Country= "India",
            .Population = 30290936
        },
        New City() With {
            .Name = "Shanghai",
            .Country= "China",
            .Population = 27058480
        }
    }

    ' Insert list values into the worksheet.
    ' Data starts with the B1 cell.
    worksheet.Import(cities, 0, 1)
    ' Apply the number format to the "Population" column. 
    worksheet("D1:D3").NumberFormat = "_(* #,##0_);_(* (#,##0);_(* "" - ""??_);_(@_)"

    ' Import values from specific data source fields.
    ' Data starts with the B5 cell.
    Dim importOptions As New DataSourceImportOptions() With {
        .PropertyNames = New String() { "Name", "Population" }
    }
    worksheet.Import(cities, 4, 1, importOptions)
    ' Apply the number format to the "Population" column.
    worksheet("C5:C7").NumberFormat = "_(* #,##0_);_(* (#,##0);_(* "" - ""??_);_(@_)"
End Sub

Public Class City
    Public Property Name As String
    Public Property Country As String
    Public Property Population As Integer
End Class

byte[] imageBytes1 = File.ReadAllBytes("images//img.png");
byte[] imageBytes2 = File.ReadAllBytes("images//x-docserver.png");
// ...
    Workbook workbook = new Workbook();
    workbook.BeginUpdate();
    try
    {
        Worksheet worksheet = workbook.Worksheets[0];
        worksheet.Clear(worksheet.GetUsedRange());
        ImportDataTable(worksheet);
        // ...
    }
    finally
    {
        workbook.EndUpdate();
        workbook.SaveDocument("result.xlsx");
        Process.Start(new ProcessStartInfo("result.xlsx") { UseShellExecute = true });
    }
    workbook.Dispose();
    // ...
void ImportDataTable(Worksheet worksheet)
{
    // Create a "Products" DataTable object with four columns.
    DataTable sourceTable = new DataTable("Products");
    sourceTable.Columns.Add("Product", typeof(string));
    sourceTable.Columns.Add("Price", typeof(float));
    sourceTable.Columns.Add("Quantity", typeof(Int32));
    sourceTable.Columns.Add("Discount", typeof(float));
    sourceTable.Columns.Add("Image", typeof(byte[]));

    sourceTable.Rows.Add("Chocolade", 5, 15, 0.03, imageBytes1);
    sourceTable.Rows.Add("Konbu", 9, 55, 0.1, imageBytes1);
    sourceTable.Rows.Add("Geitost", 15, 70, 0.07, imageBytes2);

    // Import data from the data table into the worksheet and insert it, starting with cell B2.
    worksheet.Import(sourceTable, true, 1, 1);

}

Private imageBytes1() As Byte = File.ReadAllBytes("images//img.png")
Private imageBytes2() As Byte = File.ReadAllBytes("images//x-docserver.png")
' ...
    Dim workbook As New Workbook()
    workbook.BeginUpdate()
    Try
        Dim worksheet As Worksheet = workbook.Worksheets(0)
        worksheet.Clear(worksheet.GetUsedRange())
        ImportDataTable(worksheet)
        ' ...
    Finally
        workbook.EndUpdate()
        workbook.SaveDocument("result.xlsx")
        Process.Start(New ProcessStartInfo("result.xlsx") With {.UseShellExecute = True})
    End Try
    workbook.Dispose()
    ' ...
Private Sub ImportDataTable(ByVal worksheet As Worksheet)
    ' Create a "Products" DataTable object with four columns.
    Dim sourceTable As New DataTable("Products")
    sourceTable.Columns.Add("Product", GetType(String))
    sourceTable.Columns.Add("Price", GetType(Single))
    sourceTable.Columns.Add("Quantity", GetType(Int32))
    sourceTable.Columns.Add("Discount", GetType(Single))
    sourceTable.Columns.Add("Image", GetType(Byte()))

    sourceTable.Rows.Add("Chocolade", 5, 15, 0.03, imageBytes1)
    sourceTable.Rows.Add("Konbu", 9, 55, 0.1, imageBytes1)
    sourceTable.Rows.Add("Geitost", 15, 70, 0.07, imageBytes2)

    ' Import data from the data table into the worksheet and insert it, starting with cel0l B2.
    worksheet.Import(sourceTable, True, 1, 1)
End Sub

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Clear(worksheet.GetUsedRange());

string imageBase64 = Convert.ToBase64String(imageBytes1);

List<TestObject> list = [new TestObject(1, "1", true, imageBase64), new TestObject(2, "2", false, imageBase64)];
worksheet.Import(list, 0, 0, new DataSourceImportOptions()
{
    Converter = new TestDataValueConverter(),
    PropertyNames = new string[] { "IntValue", "Value", "BoolValue", "ImageBase64" }
});

workbook.SaveDocument("result.xlsx");
Process.Start(new ProcessStartInfo("result.xlsx") { UseShellExecute = true });

Dim workbook As New Workbook()
            Dim worksheet As Worksheet = workbook.Worksheets(0)
            worksheet.Clear(worksheet.GetUsedRange())

            Dim imageBase64 As String = Convert.ToBase64String(imageBytes1)

            Dim list As List(Of TestObject) = New List(Of TestObject) From {
    New TestObject(1, "1", True, imageBytes1),
    New TestObject(2, "2", False, imageBytes2)
}
            worksheet.Import(list, 0, 0, New DataSourceImportOptions() With {
                .Converter = New TestDataValueConverter(),
                .PropertyNames = New String() {"IntValue", "Value", "BoolValue", "ImageBase64"}
            })

            workbook.SaveDocument("result.xlsx")
            Process.Start(New ProcessStartInfo("result.xlsx") With {.UseShellExecute = True})

class TestDataValueConverter : IDataValueConverter
{

    public bool TryConvert(object value, int index, out CellValue result) {
            if (value is string) {
                string strValue = value as string;

                try
                {
                    result = DXImage.FromBase64String(strValue);
                }
                catch
                {
                    int str2int = 0;

                    if (Int32.TryParse(strValue, out str2int))
                        result = str2int;
                    else
                        result = strValue;
                }
                return true;
            }        
            result = DevExpress.Spreadsheet.CellValue.TryCreateFromObject(value);
            return true;
    }
}

Friend Class TestDataValueConverter
    Implements IDataValueConverter
    Private Function IDataValueConverter_TryConvert(value As Object, index As Integer, ByRef result As CellValue) As Boolean Implements IDataValueConverter.TryConvert
        If TypeOf value Is String Then
            Dim strValue As String = TryCast(value, String)

            Try
                result = DXImage.FromBase64String(strValue)
            Catch
                Dim str2int As Integer = 0

                If Int32.TryParse(strValue, str2int) Then
                    result = str2int
                Else
                    result = strValue
                End If
            End Try

            Return True
        End If

        result = DevExpress.Spreadsheet.CellValue.TryCreateFromObject(value)
        Return True
    End Function

End Class