Basement Posted June 20, 2014 Posted June 20, 2014 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 Posted June 20, 2014 Posted June 20, 2014 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Basement Posted June 20, 2014 Author Posted June 20, 2014 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 Posted June 20, 2014 Posted June 20, 2014 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 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Basement Posted June 20, 2014 Author Posted June 20, 2014 Ups, seems that i had an older version of the Excel.au3 in use... Great, that's all i wanted. best regards Daniel
water Posted June 20, 2014 Posted June 20, 2014 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now