Page History

 public Area ImportData(System.Object[,] data, System.String[] columnNames, Cell cell, DataImportProperties props)
{signature}{signature:

Public Function ImportData(ByVal data As Object(,), ByVal columnNames As String(), ByVal cell As Cell, ByVal props As DataImportProperties) As Area
{signature}
{parameters}
{param:data}A rectangular array of values to import to the worksheet. The first dimension corresponds to row and the second to column.
        Thus, an array of data  \{ \

A rectangular array of values to import to the worksheet. The first dimension corresponds to row and the second to column.
Thus, an array of data { {"A","X"

},

{"B","Y"

},

{"C","Z"

}

}

would

be

inserted

into

the

worksheet

as:

If you enable DataImportProperties.Transpose , the format will be [row][column], so:
{ {"A","B","C"

},

{"X","Y","Z"

}

}

would

be

inserted

into

the

worksheet

as:

An array of column names for the imported data. columnNames and the column dimension of data must contain the same number of elements.

The cell at which to start entering the imported values.

A DataImportProperties object that contains a set of properties that will determine the behavior of the data import.

An Area object representing the set of cells populated with the imported values.