Search found 34 matches
- 15 May 2019, 03:53
- Forum: Ask for Help (v1)
- Topic: COM - Excel - Cell content = floating point? Topic is solved
- Replies: 12
- Views: 2674
Re: COM - Excel - Cell content = floating point? Topic is solved
Thanks guys (for the explanations as well)! I need to iterate over 20.000 cells so speed is crucial... In the end I've used a two step regex process where I first removed all trailing 000000 chars and reformatted the remaining ones (1232.03, 322.42 etc.) into 1232,03 & 322,42 (german divider for num...
- 10 May 2019, 04:14
- Forum: Ask for Help (v1)
- Topic: COM - Excel - Cell content = floating point? Topic is solved
- Replies: 12
- Views: 2674
Re: COM - Excel - Cell content = floating point? Topic is solved
Yeah, I was already replacing that value
by using
but I was just wondering why the array is filled with floating point values when the real value is just an integer
(so that I can avoid the regexreplace).
There must be a reason for this...
by using
Code: Select all
v := RegExReplace(v, "\.0{6}$")
(so that I can avoid the regexreplace).
There must be a reason for this...
- 09 May 2019, 16:12
- Forum: Ask for Help (v1)
- Topic: COM - Excel - Cell content = floating point? Topic is solved
- Replies: 12
- Views: 2674
COM - Excel - Cell content = floating point? Topic is solved
Hi, some demo code: xl := ComObjCreate("Excel.Application") xl.Workbooks.Open("R:\test.xlsx") xl.Sheets("Test").Select xlContent := xl.ActiveSheet.UsedRange.Value Msgbox, % xlContent[13, 6] xl.Workbooks.Close() xl.Quit xl = xlContent will be an array of rows, columns that contain the values of each ...
- 07 Jan 2017, 12:46
- Forum: Ask for Help (v1)
- Topic: Capture streaming cli output?
- Replies: 2
- Views: 808
Capture streaming cli output?
Hi, is it possible to read in the output line after line that a cli program creates (e.g. in a command prompt)? In this particular case I'd like to capture the output of rsync.exe (but not when it's finished but with every new line that it spits out) and display it in e.g. an edit field in a gui... ...
- 25 Oct 2016, 07:28
- Forum: Ask for Help (v1)
- Topic: RegExReplace simple question
- Replies: 2
- Views: 879
Re: RegExReplace simple question
or {<x>}$ where <x> is an integer -> in your case {3}$
or if you want to ignore the comma and anything behind it e.g.:
or if you want to ignore the comma and anything behind it e.g.:
Code: Select all
one := "1.532.245,33"
RegExMatch(one, "^[0-9.]+", two)
msgbox, % two
- 22 Oct 2016, 08:59
- Forum: Ask for Help (v1)
- Topic: Icon in taskbar(toolbar)
- Replies: 11
- Views: 2922
Re: Icon in taskbar(toolbar)
Code: Select all
#Include TrayIcon.ahk
trayIcons := TrayIcon_GetInfo()
Loop, % trayIcons.MaxIndex()
if (trayIcons[A_Index].process = "skype.exe")
TrayIcon_Remove(trayIcons[A_Index].hwnd, trayIcons[A_Index].uid)
- 21 Oct 2016, 13:50
- Forum: Ask for Help (v1)
- Topic: Icon in taskbar(toolbar)
- Replies: 11
- Views: 2922
- 21 Oct 2016, 13:49
- Forum: Ask for Help (v1)
- Topic: How to get an ampersand in the tray's tooltip
- Replies: 6
- Views: 1660
Re: How to get an ampersand in the tray's tooltip
TrayTip:="a&&&b"
- 20 Oct 2016, 15:07
- Forum: Ask for Help (v1)
- Topic: Regex help...
- Replies: 8
- Views: 2170
Re: Regex help...
@ahcahc
Thanks a lot, works!
@HelgeF
Very... evil!
Thanks a lot, works!
@HelgeF
Very... evil!
- 20 Oct 2016, 13:59
- Forum: Ask for Help (v1)
- Topic: Regex help...
- Replies: 8
- Views: 2170
Re: Regex help...
@evilC: Thank you!, but I guess I didn't describe it correctly :( This string can consist of any combination (and numbers!) of serial number / volume label / drive letter :\ [<path with ; in it] So these would be all "valid" strings that could occur: EED6-5BA8:\Us;e;rs;D:\Test;Storage:\A;B;C\ Storag...
- 20 Oct 2016, 12:35
- Forum: Ask for Help (v1)
- Topic: Regex help...
- Replies: 8
- Views: 2170
Re: Regex help...
Could be quite difficult due to the different ways in which semicolon is used (Both as a field separator and a folder separator - how can it tell the difference?) The difference should be solvable by a positive lookahead (at least that was my plan...) Does EED6-5BA8:\Us;e;rs vary? Ofc. It could be ...
- 20 Oct 2016, 12:09
- Forum: Ask for Help (v1)
- Topic: Regex help...
- Replies: 8
- Views: 2170
Regex help...
Hi, I have the following string: EED6-5BA8:\Us;e;rs;D:\Test;Storage:\A;B;C\ I know how to loop over it via RegExMatch but I need a bit of help to define the actual regex pattern... The string consists of three paths: 1.) EED6-5BA8:\Us;e;rs -> Drive serial number + folder with semicolons in it 2.) D:...
- 20 Oct 2016, 05:57
- Forum: Ask for Help (v1)
- Topic: water-tight window activating sequence?
- Replies: 1
- Views: 788
Re: water-tight window activating sequence?
RunWait?
It waits until that program was quit!
Use WinWait instead of Sleep
It waits until that program was quit!
Use WinWait instead of Sleep
- 18 Oct 2016, 17:44
- Forum: Ask for Help (v1)
- Topic: Navigate Microsoft Management Console?
- Replies: 0
- Views: 701
Navigate Microsoft Management Console?
Hi, isn't it possible to navigate gpedit.msc (a MM console)? It has a SysListView321 on it's left side but I can't get any row text from it (with ControlGetText, var, List, , SysListView321, Editor für lokale Gruppenrichtlinien)... I'd really like to automate setting some group policies (which don't...
- 14 Oct 2016, 17:37
- Forum: Ask for Help (v1)
- Topic: [SOLVED] Convert string to raw binary data?
- Replies: 14
- Views: 7493
Re: [SOLVED] Convert string to raw binary data?
@jNizM
Is there a way to get the unicode string back from the hex values (with a function like hex2str(hexValue)) after using str2hex("some unicode characters")?
Is there a way to get the unicode string back from the hex values (with a function like hex2str(hexValue)) after using str2hex("some unicode characters")?
- 12 Oct 2016, 14:12
- Forum: Scripts and Functions (v1)
- Topic: AutoXYWH() - Move control automatically when GUI resized
- Replies: 107
- Views: 85408
Re: AutoXYWH() - Move control automatically when GUI resized
Are there any license restrictions (for using it in a commercial application) for this one?
- 09 Oct 2016, 06:15
- Forum: Ask for Help (v1)
- Topic: Combination of GetKeyStates() -> Derive characters from it? Topic is solved
- Replies: 3
- Views: 1200
Re: Combination of GetKeyStates() -> Derive characters from it? Topic is solved
Perfect! Thanks a lot, wolf_II!
- 09 Oct 2016, 04:05
- Forum: Ask for Help (v1)
- Topic: Combination of GetKeyStates() -> Derive characters from it? Topic is solved
- Replies: 3
- Views: 1200
Combination of GetKeyStates() -> Derive characters from it? Topic is solved
Hi, shiftState := GetKeyState("Shift", "P") ? 1 : 0 ctrlState := GetKeyState("Ctrl", "P") ? 2 : 0 altState := GetKeyState("Alt", "P") ? 4 : 0 lWinState := GetKeyState("LWin", "P") ? 8 : 0 state := ctrlState + shiftState + altState + lWinState Is there a good way to get the corresponding modifier (^,...
- 07 Oct 2016, 13:45
- Forum: Ask for Help (v1)
- Topic: OnMessage - Receive WM_LBUTTONDOWN event?
- Replies: 5
- Views: 2073
Re: OnMessage - Receive WM_LBUTTONDOWN event?
Sorry, you're right lexikos. I though about a specialized hook but a hotkey is sufficient in this case. Me culpa!
- 06 Oct 2016, 17:31
- Forum: Ask for Help (v1)
- Topic: OnMessage - Receive WM_LBUTTONDOWN event?
- Replies: 5
- Views: 2073
Re: OnMessage - Receive WM_LBUTTONDOWN event?
Ok, thanks!
@lexikos:
Any hints how to implement this? I only need to listen for this event for a specific application (for example: Windows File Explorer)
@lexikos:
Any hints how to implement this? I only need to listen for this event for a specific application (for example: Windows File Explorer)