Output Array To Range Of Cells

[Adrian White]

Hi

Does anyone know how/if it is possible to output an array of data to a range of cells in one action (not looping) using XLSIO?

If I had a 2x2 array i.e. two rows, two columns how can I output this to Excel using xlsio?

Any help on this matter is massively appreciated. Thanks.

Adrian

[Administrator]

Hi Adrian, It is possible to output an array of data to a Single row or column of cells using arrays sheet.ImportArray() method. I here with attach a Sample for your reference. Arrays_6792.zip I have logged a feature request regarding the 2x2 array, you can track the status of this issue here. http://www.syncfusion.com/support/features/xlsio/Default.aspx?ToDo=view&questId=487 Please let me know if you have further questions. Best Regards, Seetha >Hi > >Does anyone know how/if it is possible to output an array of data to a range of cells in one action (not looping) using XLSIO? > >If I had a 2x2 array i.e. two rows, two columns how can I output this to Excel using xlsio? > >Any help on this matter is massively appreciated. Thanks. > >Adrian

[Adrian White]

Thanks Seetha. That new feature request would be great thanks.

>Hi
>
>Does anyone know how/if it is possible to output an array of data to a range of cells in one action (not looping) using XLSIO?
>
>If I had a 2x2 array i.e. two rows, two columns how can I output this to Excel using xlsio?
>
>Any help on this matter is massively appreciated. Thanks.
>
>Adrian

[Greg]

If you only wish to export values to this 2x2, you may be able to use an arrayformula such as ={1,2;3,4} today.

However, the individual cells of this resulting matrix cannot then be edited independently (requires odd Ctrl-Shift-Enter array formulas within Excel).

Just an idea.

-Greg

>Thanks Seetha. That new feature request would be great thanks.
>
>>Hi
>>
>>Does anyone know how/if it is possible to output an array of data to a range of cells in one action (not looping) using XLSIO?
>>
>>If I had a 2x2 array i.e. two rows, two columns how can I output this to Excel using xlsio?
>>
>>Any help on this matter is massively appreciated. Thanks.
>>
>>Adrian