# Search the Community

Showing results for tags 'excel'.

• ### Search By Tags

Type tags separated by commas.

### Forums

• General
• Announcements and Site News
• AutoIt v3
• AutoIt Help and Support
• AutoIt Technical Discussion
• AutoIt Example Scripts
• Scripting and Development
• Developer General Discussion
• Language Specific Discussion
• Operating System Deployment
• Windows Client
• Windows Server
• Office

### Categories

• AutoIt Team
• Beta
• MVP
• AutoIt
• Automation
• Databases and web connections
• Data compression
• Encryption and hash
• Games
• Hardware
• Information gathering
• Internet protocol suite
• Maths
• Media
• PDF
• Security
• Social Media and other Website API
• Windows
• Scripting and Development
• Operating System Deployment
• Windows Client
• Windows Server
• Office

• Forum
• AutoIt

### Calendars

• Community Calendar

### Filter by number of...

• 0 Replies

• 0 Reviews

• 0 Views

#### Minimum number of views

Found 183 results

1. ## Excel: Set Background Color using some _EXCEL_* ?

Hello, I used the various "_Excel_*()" funktions to open workbooks, read and write cells. I was looking through the helpfile for the _EXCEL_* funktions, if there is a direkt way to set background color or text color -- if there is one, then I missed it? Searching the forum I found this posting demonstrating how to do this task using ... ObjCreate("Excel.Application") Is there a way to set the background color etc. with the native "_EXCEL_*" as well? Regards, Rudi.
2. ## for next with excel range addition

Hi guys, Wondering, is there a better way, likely to use 'for...next' to add a letter to each range, by moving right -> along a range of columns in excel. I currently use this, but its clunky. If $run = 1 Then$range = "B6:B41" If $run = 2 Then$range = "C6:C41" If $run = 3 Then$range = "D6:D41" If $run = 4 Then$range = "E6:E41" If $run = 5 Then$range = "F6:F41" If $run = 6 Then$range = "G6:G41" If $run = 7 Then$range = "H6:H41" If $run = 8 Then$range = "I6:I41" If $run = 9 Then$range = "J6:J41" If $run = 10 Then$range = "K6:K41" If $run = 11 Then$range = "L6:L41" If $run = 12 Then$range = "M6:M41" If $run = 13 Then$range = "N6:N41" If $run = 14 Then$range = "O6:O41" If $run = 15 Then$range = "P6:P41" If $run = 16 Then$range = "Q6:Q41" If $run = 17 Then$range = "R6:R41" If $run = 18 Then$range = "S6:S41" If $run = 19 Then$range = "T6:T41" If $run = 20 Then$range = "U6:U41" If $run = 21 Then$range = "V6:V41" If $run = 22 Then$range = "W6:W41" If $run = 23 Then$range = "X6:X41" If $run = 24 Then$range = "Y6:Y41" If $run = 25 Then$range = "Z6:Z41" If $run = 26 Then$range = "AA6:AA41" If $run = 27 Then$range = "AB6:AB41" If $run = 28 Then$range = "AC6:AC41" If $run = 29 Then$range = "AD6:AD41" If $run = 30 Then$range = "AE6:AE41" If $run = 31 Then$range = "AF6:AF41" If $run = 32 Then$range = "AG6:AG41" If $run = 33 Then$range = "AH6:AH41" If $run = 34 Then$range = "AI6:AI41" If $run = 35 Then$range = "AJ6:AJ41" If $run = 36 Then$range = "AK6:AK41" If $run = 37 Then$range = "AL6:AL41" If $run = 38 Then$range = "AM6:AM41" If $run = 39 Then$range = "AN6:AN41" If $run = 40 Then$range = "AO6:AO41" If $run = 41 Then$range = "AP6:AP41" If $run = 42 Then$range = "AQ6:AQ41" If $run = 43 Then$range = "AR6:AR41" If $run = 44 Then$range = "AS6:AS41" If $run = 45 Then$range = "AT6:AT41" If $run = 46 Then$range = "AU6:AU41" If $run = 47 Then$range = "AV6:AV41" If $run = 48 Then$range = "AW6:AW41" If $run = 49 Then$range = "AX6:AX41" If $run = 50 Then$range = "AY6:AY41" Normally, if it was going down the rows, i'd use this: For $i = 0 To UBound($iRowCount) - 1 $row =$i + 1 $range = "B"&$row&":B"&$row+1 Next so something like this, but i don't know how to code sequential columns: For$i = 0 To UBound($iColCount) - 1$col = $i + 1$range = $col&"1:"&$col&"40" Next If I don't make sense, let me know. Any help would be great. thanks

4. ## Opened Excel File Not activate

I try to activate my opened excel file using this code : #include <Excel.au3> $oExcel = _Excel_Open()$sCaption = $oExcel.Caption WinSetState($sCaption, "", @SW_MAXIMIZE) But when i edit cell in my excel file above code not working because it open new excel sheet.

15. ## Excel - Store an entire row into an array

Hi everybody, i have to store an entire row of a Excel workbook into an array. The row index is stored in a variable. How can i do it? Thanks in advance for your support.
16. ## Excel - Write into a column

Hi everybody, i have to write a value into an excel column. I know where it starts from, but i don't know what the end is, last non-empty cell. How can i get the number of last non-empty cell? Thanks in advance. Regards
17. ## How Cut/Copy text from Excel and past to other software one by one ?

Hi All, I have excel file like this and i want to cut cell/text from excel to other software. I have to cut the cell of B column one by one and past into other software If Winexists("No Data Found") then restore cuted cell and goto next/down side cell How to do it ?
18. ## Beginner Question - Filepath - change letters - search for specific data

Hey Community, cause im too new in the Auto it world i will try it with the your help. hopefully. I woud like to know how i can handle my Problem. ---- I have a Excel Data with 362 random numbers. For Example: 1166642335374 1172899897343 ..... this numbers are a part of the filepath ...example D:\Projekte\1166_64233_5374 as u can see its the first number of the Excel data. After the first 4 numbers it shoud make a "_" than another 5 "_" This is my first question. How can i handle this to make it Shell execute. -------- Second question: If i am in the path. For Example: D:\Projekte\1166_64233_5374 the code shoud search for specific PDF Files. They are named like: 0050569E364B1ED79B900F73E62660EC.pdf the first 15 letters are always the same 0050569E364B1ED when he found this data he has to copy it on a Folder on the Desktop. (There can also be 2 or 3 pdfs in one Folder with this letters) ---- Please give me some help :-)

I am not sure why I am getting the this error on my second pass of the code. 1 - $oWorkbook is not an object or not a workbook object Any help or advice on my code appreciated. #include <Excel.au3> #include <Array.au3> #include <MsgBoxConstants.au3> Global$sExcelFile1 = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "(*.xlsm)") Global $sExcelFile2 = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "Excel Sheet (*.xlsx;*.xls)|All (*.*)") Global$vRow = 2 If FileExists($sExcelFile2) Then Global$oExcel2 = _Excel_Open () $oExcel2 = _Excel_BookOpen($oExcel2,$sExcelFile2) EndIF If FileExists($sExcelFile1) Then Global $oExcel1 = _Excel_Open ()$oExcel1 = _Excel_BookOpen($oExcel1,$sExcelFile1,Default,Default,"2007") EndIF $oRead = _Excel_RangeRead ($oExcel2,"Untitled","A2",3) $oFind = _Excel_RangeFind ($oExcel1,$oRead,"E4:FD92",Default,$xlWhole) $Clip = _ArrayToClip($oFind,"",0,0,"",2,2) Send("{ScrollLock Off}") $hWnd = WinWait("[CLASS:XLMAIN]") ControlSend($hWnd, "", "", ("^g")) WinWait("[CLASS:bosa_sdm_XL9]") ; Go To ControlSend($hWnd, "", "", ("^v")) ControlSend($hWnd, "", "", ("{Enter}")) ControlSend($hWnD, "", "", "{Down " &$vRow & "}") Do $oTime = _Excel_RangeRead ($oExcel2,"Untitled","B2",3) If @error Then Exit MsgBox(0, "Error", "Error" & @CRLF & "@error = " & @error & ", @extended = " & @extended) MsgBox(0,"Test",$oTime) IF$oTime = "7:10:00 AM" Then $oCalls1 = _Excel_RangeRead ($oExcel2,Default,"C" & $vRow,3)$oCalls2 = _Excel_RangeRead ($oExcel2,Default,"D" &$vRow,3) ControlSend($hWnd, "", "",$oCalls1) ControlSend($hWnd, "", "", ("{RIGHT}")) ControlSend($hWnd, "", "", $oCalls2)$vRow = $vRow + 1 ContinueLoop Else$vRow = $vRow + 1 EndIf Until$vRow = 4 1.xlsm 2.xlsx
20. ## [Solved] _Excel_RangeFind Questions

My Main goal is to copy the info from sheet 2 and put it in the correct date and time location on sheet 1. 1.xlsm - Password 2007 2.xlsx 1. I do not understand why I am unable to find the date. I am reading the value and searching for the value. But, it never turns anything up. 2. What would be the best way (function) to go about selecting the second cell underneath the date after I have found it? So Ideally, I would want to match the date. Once it finds the date go 2 cells down insert the data from sheet 2. I believe I have a good idea on how to loop the script. The only thing I am not sure on is how to take the cell I find and get the cell location (exp. A2) to go the cell that I find and select 2 cells down and go to A4. In other words I don't know how to put the cell I find into a variable that I can use to position where I start to input data. Any help is appreciated as always. #include <Excel.au3> #include <Array.au3> MsgBox(0, "", "Open Excel 1") Global $sExcelFile1 = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "(*.xlsm)") MsgBox(0, "", "Open Excel 2") Global$sExcelFile2 = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "Excel Sheet (*.xlsx;*.xls)|All (*.*)") If FileExists($sExcelFile2) Then Global$oExcel2 = _Excel_Open () $oExcel2 = _Excel_BookOpen($oExcel2,$sExcelFile2) EndIF If FileExists($sExcelFile1) Then Global $oExcel1 = _Excel_Open ()$oExcel1 = _Excel_BookOpen($oExcel1,$sExcelFile1,Default,Default,"2007") EndIF $oRead = _Excel_RangeRead ($oExcel2,Default,"A2") $oRead1 = _Excel_RangeRead($oExcel1,Default,"BY4") MsgBox (0,"Test",$oRead) MsgBox (0,"Test",$oRead1) $oFind = _Excel_RangeFind ($oExcel1,$oRead,"E4:FD4") If @error Then MsgBox(4096, "", "No File(s) chosen") Else Local$aSalesResult = _Excel_RangeFind($oExcel1,$oRead, Default, Default, $xlWhole) _Arraydisplay($aSalesResult, "RangeFind", 2, 0, "", "|", "Col|Sheet|Name|Cell|Value|Formula|Comment") EndIf
21. ## [Solved] _Excel_RangeFind Error

I get this error, Whenever I try to find a date. Does anyone have any idea why? I saw some post from 2015, However I would imagine this is fixed by now. @water >"J:\Temporary Files\XXXXXXXXX\AutoIt\AutoIt\AutoIt\SciTe\..\autoit3.exe" /ErrorStdOut "C:\Users\XXXXXX\Desktop\Call Report Automation.au3"     "J:\Temporary Files\XXXXXXXX\AutoIt\AutoIt\AutoIt\Include\Excel.au3" (656) : ==> The requested action with this object has failed.: $aResult[$iIndex][1] = $oMatch.Name.Name$aResult[$iIndex][1] =$oMatch^ ERROR >Exit code: 1    Time: 5.791 #include <Excel.au3> Global $sExcelFile1 = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "(*.xlsm)") Global$sExcelFile2 = FileOpenDialog("Choose/Create Excel File", @ScriptDir, "Excel Sheet (*.xlsx;*.xls)|All (*.*)") If FileExists($sExcelFile2) Then Global$oExcel2 = _Excel_Open () $oExcel2 = _Excel_BookOpen($oExcel2,$sExcelFile2) EndIF If FileExists($sExcelFile1) Then Global $oExcel1 = _Excel_Open ()$oExcel1 = _Excel_BookOpen($oExcel1,$sExcelFile1,Default,Default,"2007") EndIF $oRead = _Excel_RangeRead ($oExcel2,Default,"A2",3) _Excel_RangeWrite ($oExcel1,"Calls Handled",$oRead,"BY7") Sleep (1000) _Excel_RangeFind ($oExcel1,$oRead,"E4:FD92") MsgBox (0,"Test",$oRead) UPDATE: If I take out this line it works. By works I mean I don't get the error. :/ However, I need it. I am just confused. _Excel_RangeWrite ($oExcel1,"Calls Handled",$oRead,"BY7") UPDATE 2: I also get this error when trying to use the helpfile examples. I have version 3.3.14.2 \AutoIt\AutoIt\AutoIt\Include\Excel.au3" (670) : ==> The requested action with this object has failed.:$oSheet = $oWorkbook.Sheets($iIndexSheets) $oSheet =$oWorkbook^ ERROR >Exit code: 1 Time: 0.8931
22. ## ExcelChart

Version 0.4.0.1

Extensive library to control and manipulate Microsoft Excel charts. Written by GreenCan and water. Theads: General Help & Support - Example Scripts BTW: If you like this UDF please click the "I like this" button. This tells me where to next put my development effort KNOWN BUGS (last changed: 2017-07-21) None. The COM error handling related bugs have been fixed.

25. ## KB 3008923 error help

Hi guys, I was trying to automate a webpage after getting input from excel. The script worked fine for like 5 iterations but then stopped all of a sudden, I dont have the exact error msg now, but it was pointing to this in the IE UDF:- Return SetError($_IESTATUS_Success,$oTemp.GetElementsByTagName(\$sTagName).length, When i looked up the forum there was a similar question which said that I have to fix KB 3008923 update by uninstalling it, but I am unable to do that. here is the link for download:- ( i guess ) https://support.microsoft.com/en-us/help/3024777/error-0x800706f7-occurs-after-you-install-kb-3004394-and-then-run-windows-update-in-windows-7-and-windows-server-2008-r2 Does anybody know the proper steps to solve this?? Plus I wont be able to send the code here because of privacy policy n all by the company. Desperately looking for a reply.....
×

• Wiki

• Back

• Git