dar100111 1 Posted May 2, 2014 Hey All, Is there a faster way to copy an array into a worksheet if you have a large array? Wasn't sure if anyone had used the clipboard for something like this? $oExcel = _ExcelBookNew(1) WinActivate($oExcel) _ExcelSheetAddNew($oExcel, "Exceptions") _ExcelSheetActivate($oExcel, "Exceptions") _ExcelWriteSheetFromArray($oExcel, $exceptionArray, 1,1,0,0) _ExcelSheetDelete($oExcel, "Sheet1") $oExcel.Columns.AutoFit _ExcelSheetAddNew($oExcel, "Not Found") _ExcelSheetActivate($oExcel, "Not Found") _ExcelWriteSheetFromArray($oExcel, $notFoundArray, 1,1,0,0) $oExcel.Columns.AutoFit _ExcelSheetAddNew($oExcel, "SSD_SAD Changed") _ExcelSheetActivate($oExcel, "SSD_SAD Changed") _ExcelWriteSheetFromArray($oExcel, $dateChangeArray, 1,1,0,0) $oExcel.Columns.AutoFit Share this post Link to post Share on other sites
abberration 53 Posted May 2, 2014 Could you write the data to a blank file under a .csv extension? You would write to it without using Excel. When finished writing the data, open it in Excel, apply your formatting (autofit) and re-save it with an Excel format and extension. I image this method would be much quicker because the majority of the work will be done outside of Excel. Easy MP3 | Software Installer | RAID Calculator Share this post Link to post Share on other sites
BrewManNH 1,304 Posted May 3, 2014 Try the latest beta version of AutoIt, it has a new rewritten Excel UDF that is a lot faster. Check the function names though, the new version changes all the old function names. If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag GudeHow to ask questions the smart way!I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays. - ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script. - Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label. - _FileGetProperty - Retrieve the properties of a file - SciTE Toolbar - A toolbar demo for use with the SciTE editor - GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI. - Latin Square password generator Share this post Link to post Share on other sites
water 2,367 Posted May 3, 2014 BrewManNH is quite right. The new function _Excel_RangeWrite is about 20-100 times faster. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites