Insert List (Of T)

[aricarlos]

Hello:

I have the following list
Dim mListaOrder As New List(Of Order)()
The definition of the function is:
Public Function InsertArray(Of T)(objects() As T, firstRow As Integer, firstColumn As Integer, isVertical As Boolean) As Integer

I have the following code
sheet.InsertArray(Of Order)(mListaOrder, 2, 1, True)

The error that gives me is:
A value of type System.Collection.Generic.List (Order) can not be converted to -1 dimensional array of Order

Greetings from Bilbao
Carlos

[Betsy.jiang]

Dear Carlos,

Sorry for late reply as weekend and thanks for your inquiry.
Kindly note that the List( Order in your code ) is not array, and it cannot be converted to array directly, please make sure they are same type when you use the custom function InsertArray.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear Carlos,

How is the issue now ?
Could you please give us some feedback at your convenience ?

Thanks,
Betsy
E-iceblue support team

[aricarlos]

Hello:
Since you can not use list (Of T), you convert these to datatable
Greetings from Bilbao
Carlos

[Betsy.jiang]

Dear Carlos,

Sorry for late reply as weekend.
Why you get the error is because the list cannot be converted to array directly, you can use ToArray method, like this.
worksheet.InsertArray(Of T)(mListaOrder.ToArray, 2, 1, True)
And there is a tutorial for your kind reference.
If there is still issue, please provide us more information and the entire code you were using.

Sincerely,
Betsy
E-iceblue support team