Mikkelin Posted August 26, 2014 Share Posted August 26, 2014 Hello, if the script isn't ended after you write to a excel file, then a Excel process will hang in the task manager, and if you try to open the created excel file, it simply won't show the excel ark. If you close the process, you can open it. Wokring: #include <Excel.au3> Local $oExcel = _ExcelBookNew() ; Erzeugt eine neue Mappe, macht sie sichtbar _ExcelWriteCell($oExcel, "Ich hab hier mal was rein geschrieben!", 3, 2) ; Schreibt in die Zelle [3,2] MsgBox(0, "Beenden", "Drücke OK zum Speichern und Beenden.") _ExcelBookSaveAs($oExcel, @ScriptDir & "\test.xls", "xls", 0, 1) ; Jetzt wird ins Temp-Verzeichnis gespeichert; wenn nötig, werden bestehende Dateien überschrieben _ExcelBookClose($oExcel) ; Und schließlich machen wir die Mappe wieder zu. _ExcelBookClose($oExcel) Not working: #include <Excel.au3> Local $oExcel = _ExcelBookNew() ; Erzeugt eine neue Mappe, macht sie sichtbar _ExcelWriteCell($oExcel, "Ich hab hier mal was rein geschrieben!", 3, 2) ; Schreibt in die Zelle [3,2] MsgBox(0, "Beenden", "Drücke OK zum Speichern und Beenden.") _ExcelBookSaveAs($oExcel, @ScriptDir & "\test.xls", "xls", 0, 1) ; Jetzt wird ins Temp-Verzeichnis gespeichert; wenn nötig, werden bestehende Dateien überschrieben _ExcelBookClose($oExcel) ; Und schließlich machen wir die Mappe wieder zu. _ExcelBookClose($oExcel) while 1 Sleep(100) WEnd So a loop prevents it from working, But i need a loop, I suppose that's a bug ? Link to comment Share on other sites More sharing options...
water Posted August 26, 2014 Share Posted August 26, 2014 Please have a look at The latesr AutoIt version. The new Excel UDF solves this problem. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
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