Search found 1160 matches

by tmplinshi
Yesterday, 03:08
Forum: Offtopic
Topic: Thank you for the music
Replies: 158
Views: 52614

Re: Thank you for the music

by tmplinshi
22 Jun 2018, 13:47
Forum: Scripts and Functions
Topic: Class_Excel - Create excel file from array or listview
Replies: 3
Views: 98

Re: Class_Excel - Create excel file from array or listview

@burque505 I tried some hours on EPPlus, it's really like solving a puzzle :crazy: . Fortunately I finally made some working code, I've replied in your topic Help with EPPlus.dll and AHK.
by tmplinshi
22 Jun 2018, 13:45
Forum: Ask For Help
Topic: Help with EPPlus.dll and AHK Topic is solved
Replies: 3
Views: 121

Re: Help with EPPlus.dll and AHK Topic is solved

Working example: [code file=EPPlus Test.ahk:2ytpq2or]#NoEnv SetWorkingDir %A_ScriptDir% asm := Clr_LoadLibrary(".\epplus\lib\net40\EPPlus.dll") pck := Clr_CreateObject(asm, "OfficeOpenXml.ExcelPackage") Worksheet := pck.Workbook.Worksheets.Add("Sheet1") Worksheet.Cells....
by tmplinshi
22 Jun 2018, 09:11
Forum: Scripts and Functions
Topic: Class_Excel - Create excel file from array or listview
Replies: 3
Views: 98

Class_Excel - Create excel file from array or listview

Posted 2 years ago on chinese subforum , I guess I should post here. Source Functions : ⋅ CreateByArray(outputFile, arr) ⋅ CreateByHLV(outputFile, HLV, Obj_LV_Colors := "", IncludeLvHeader := false) ⋅  HLV - Listview hwnd ⋅  Obj_LV_Colors - Created ...
by tmplinshi
22 Jun 2018, 06:17
Forum: Ask For Help
Topic: Get Listview data from excel
Replies: 6
Views: 81

Re: Get Listview data from excel

Wait, did you deleted the content of ExcelToArray.ahk that I provide? Don't do that.
Download this zip file, then unpack all files, then run Example.ahk.
by tmplinshi
22 Jun 2018, 05:26
Forum: Ask For Help
Topic: Get Listview data from excel
Replies: 6
Views: 81

Re: Get Listview data from excel

It seems it's because the editor SciTE4AutoHotkey not using the script directory to run the script. Try specify the full path of ExcelToArray.ahk: #Include D:\Desktop\ExcelToArray.ahk Or if ExcelToArray.ahk is located in the same directory as the script, you can either use #Include %A_ScriptDir%\Exc...
by tmplinshi
22 Jun 2018, 03:22
Forum: Ask For Help
Topic: Get Listview data from excel
Replies: 6
Views: 81

Re: Get Listview data from excel

Hi, I just posted a function ExcelToArray #NoEnv SetBatchLines -1 #Include ExcelToArray.ahk Gui, Add, ListView, xm w700 r10 Grid, A|B|C|D|E|F|G|H|I Loop, 9 LV_ModifyCol(A_Index, 75) Gui, Show,, Get Listview data from excel SplashTextOn, , , Loading... Gosub, ImportData SplashTextOff Return ImportDat...
by tmplinshi
22 Jun 2018, 03:21
Forum: Scripts and Functions
Topic: ExcelToArray - Read excel data to AHK array
Replies: 1
Views: 69

ExcelToArray - Read excel data to AHK array

Source (GitHub) Usage arr := ExcelToArray(FileName, nSheet, last_row, last_column) ⋅  FileName - The excel file path. ⋅  nSheet - (Optional) Sheet number. Default is 1. ⋅  last_row - (Optional) Last row number. ⋅  last_column - (Optional) Last column ...
by tmplinshi
21 Jun 2018, 06:01
Forum: Other Utilities & Resources
Topic: mCtrl - Bringing more controls for your Win32API applications
Replies: 1
Views: 84

mCtrl - Bringing more controls for your Win32API applications

mCtrl is open-source C library providing set of additional user interface controls for Windows, intended to be complementary to standard Win32API controls from USER32.DLL and COMCTL32.DLL.

Learn more
by tmplinshi
20 Jun 2018, 00:57
Forum: Scripts and Functions
Topic: Drawing with autohotkey
Replies: 6
Views: 770

Re: Drawing with autohotkey

Nice. Here is a simplified version: Run, %windir%\system32\mspaint.exe,,, pid WinWait, ahk_pid %pid% WinActivate WinWaitActive Sleep, 100 CoordMode, Mouse, Window MouseMove, 218, 215 p = ( 20,343|-19,-342,30,15|17,-44|28,35|21,-41|25,30|27,-37|25,34|28,-31|25,32|23,-30|23,40|31,-32|20,37|15,-25|22,2...
by tmplinshi
17 Jun 2018, 00:07
Forum: Ask For Help
Topic: Help converting JSON library from v1.1 to v2
Replies: 4
Views: 110

Re: Help converting JSON library from v1.1 to v2

Or another JSON library Jxon that compatible with v1.1 and v2.
by tmplinshi
13 Jun 2018, 05:49
Forum: Ask For Help
Topic: Detect closed explorer path Topic is solved
Replies: 6
Views: 482

Re: Detect closed explorer path Topic is solved

HSHELL_WINDOWDESTROYED = 2 A top-level, unowned window is about to be destroyed. The window still exists when the system calls this hook. Thanks for the quote, that makes me tried again, and, it worked! The key is DetectHiddenWindows, On . DetectHiddenWindows, On MsgNum := DllCall("RegisterWin...
by tmplinshi
13 Jun 2018, 05:13
Forum: Ask For Help
Topic: Detect closed explorer path Topic is solved
Replies: 6
Views: 482

Re: Detect closed explorer path Topic is solved

Thanks for the replies, but did you noticed this topic was posted 4 years ago? :)

Anyway, I guess it is impossible to retrieve the explorer path in the HSHELL_WINDOWDESTROYED event, the path should be recorded when HSHELL_WINDOWCREATED event occurred.
by tmplinshi
12 Jun 2018, 05:58
Forum: Ask For Help
Topic: XML for AHK V2.0
Replies: 8
Views: 206

Re: XML for AHK V2.0

KeyValStore.ahk support both AutoHotkey v1.1 and v2.0-a:
https://autohotkey.com/boards/viewtopic.php?t=15815
by tmplinshi
09 Jun 2018, 04:50
Forum: Scripts and Functions
Topic: JSON Editor / MsgBox_Json() / MsgBox_Obj()
Replies: 2
Views: 338

Re: JSON Editor / MsgBox_Json() / MsgBox_Obj()

Added 2 functions: MsgBox_Json() and MsgBox_Obj()
by tmplinshi
09 Jun 2018, 01:24
Forum: Tutorials
Topic: Using Selenium with AutoHotkey- Cross browser automation!
Replies: 59
Views: 11446

Re: Using Selenium with AutoHotkey- Cross browser automation!

How do I hide the chrome window? http://chromedriver.chromium.org/capabilities Tried with driver.SetCapability("args", "['headless']") but didn't work. Anyway, below are two ways that worked: Method 1: Using --headless Run, chrome.exe --remote-debugging-port=9222...
by tmplinshi
06 Jun 2018, 13:28
Forum: Ask For Help
Topic: Datatypes in AHK?
Replies: 5
Views: 108

Re: Datatypes in AHK?

= and := are different when assigning variables. payload = {"k": "v"} ; This is a string MsgBox % payload ; ==> {"k": "v"} payload := {"k": "v"} ; This is an object MsgBox % payload ; ==> MsgBox % payload.k ; ==> v Write your object like t...

Go to advanced search