Paste ArrayToClip-result in Excel sheet

[Basement]

Hi,

another day, another question ;-)

I want to create an excel-sheet which contains the content of an array.

I think the fastest way to transfer the Array's content (which is VERY large, 9000 lines and 30 Columns) is via the function ArrayToClip and then paste it in Excel - so far so right?

The problem:

When i paste the content into the Excel sheet, it is not pasted in table format (which would mean every Array column is in a separate Excel column). It is pasted in the CSV-semicolon-separared format "content col 1;content col 2;etc) and pasted all in the first cell of the sheet.

Is it possible to paste in a way that the structure of the array table is overtaken?

Best regards

Daniel

[water]

Writing an array to Excel can be done without using the Clipboard. Use function _Excel_RangeWrite when running AutoIt 3.3.12.0.

[Basement]

Hi,

but as i know the array then is written line by line to Excel.

With an Array of 9000 lines this takes hours.

Is there no possibility to paste automatically in table format?

Excel has a Paste-function which is called in german version "Textkonvertierungsassistent".

When i use this function manually (which i don't want, all is to be done automatically) i can say "separater is semicolon" and then Excel pastes in correct format.

Every idea is appreciated...

best regards

Daniel

[water]

No it isn't. The Excel UDF has been rewritten and starting with AutoIt 3.3.12.0 replaced the "old" UDF which worked cell by cell.

The array is now being written in one go to Excel and is about 10 to 100 times faster compared to the old UDF.

[Basement]

Ups, seems that i had an older version of the Excel.au3 in use...

Great, that's all i wanted.

best regards

Daniel

[water]