views:

47

answers:

0

In my C# xll, I have a string array. I can read it from VB in Excel one element at a time, with the following code on c# side:

public int NumColumns()
{
    return _columns.Count;
}

public string ColumnName(int columnNumber)
{
    return _columns[columnNumber];
}

and this code in VB on Excel side:

 n = Application.Run("NumColumns")
 s = Application.Run("ColumnName", 1)

Can I transfer the whole array at once?