Raw Data from IArrayOfArrayOfRCCell or IArrayOfFieldValue

[chrweber]

Hi I wish to get a "pointer" or a whole blob of data from the COM Interface to quickly populate an excel range.

Currently i have to copy item-wise.

Is there a way to get at least a whole field at once and "cast" it into a (i.e.) c# array of respective type?

best regards

[chrweber]

OK.

No, I am talking seconds and miliseconds for user guided exploration and experimentation purposes and not overnight.

[marcus_sommer]

I doubt that it will be possible without an appropriate waiting-time for the user. I think the only possibility to reduce the waiting-time is my suggestion from above with exporting the data (maybe in an external source or in a hidden excel-sheet) and accessing the informations from there within your target cells/tables. It meant generating some kind of an Excel master-template and then just changing/replacing the data-souce for it.

- Marcus