Skip to content

Instantly share code, notes, and snippets.

@JoeGlines
Created November 19, 2022 19:51
Show Gist options
  • Save JoeGlines/01cbc8c1dca0fe046096b697282d741b to your computer and use it in GitHub Desktop.
Save JoeGlines/01cbc8c1dca0fe046096b697282d741b to your computer and use it in GitHub Desktop.
;*******************************************************
; Want a clear path for learning AutoHotkey; Take a look at our AutoHotkey courses.
;They're structured in a way to make learning AHK EASY: https://the-Automator.com/Learn
;*******************************************************
SetBatchLines,-1
#SingleInstance,Force
;********************Excel Safe array***********************************
XL:=XL_Handle(1) ;Connect to Excel
sArr :=xl.Range["a1:L29"] ;Store the content of the array into sArr
;~ MsgBox % IsObject(sArr)
for row in sArr
for cell in row
data.= cell.value ","
MsgBox % Data
;If you want to access it directly, add the .Value
sArr :=xl.Range["a1:L29"].Value
MsgBox % sArr[2,2]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment