Sign in to follow this  
Followers 0
Basement

Paste ArrayToClip-result in Excel sheet

6 posts in this topic

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

Share this post


Link to post
Share on other sites



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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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

Great, that's all i wanted.

best regards

Daniel

Share this post


Link to post
Share on other sites

:)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0