Write a datatable to a named range

[Robert Chapman]

Currently I can write a datatable using ImportDataTable starting at a specific row, col.

What I would like to do is write a datatable to a named range.

When using excel interops, I have to convert the datatable to an 2d object array.
Sheet.Range[myRangeName].Value = MakeArray(myTable)

When I try and follow this process with syncfusion, I end up writing the type of object to each cell. (ie each cell contains "System.String[,]")

Is there a simple way to write a data table to a NAMED range?

[Administrator]

Hi Rob,

I will consult our development team regarding this and will update you as soon as I hear back from them.

Thanks,

Bharath.

[Robert Chapman]

I have come up with a work around but would love to return to our original implementation!

Thanks,
Kelley

>Hi Rob,
>
>I will consult our development team regarding this and will update you as soon as I hear back from them.
>
>Thanks,
>
>Bharath.