AutoHotkey Community

nadure

Nice lib! Thank you. One question. To create a new excel file, do I have to read an empty file first? xl := new OpenAhkXl() ; bbbbbbbb.xlsx > tatally empty file. xl.open("bbbbbbbb.xlsx") yes, the function for writing totally new file is not implemented. :D i think it's very long way for that :crazy:

nadure

submeg wrote: ↑
14 Aug 2022, 17:22
Hey @nadure, have you seen Joe's COM stuff?

yes. I already read about that.
It's a just try to open excel file with native autohotkey.

nadure

what about use this library?

viewtopic.php?style=17&t=95251

it is not open the excel, and just modifying value or get value from excel file.

nadure

This is the code for using open cv matchTemplate example. it works :) hOpencv := DllCall("LoadLibrary", "str", "opencv-4.5.4-vc14_vc15\opencv\build\x64\vc15\bin\opencv_world454.dll", "ptr") hOpencvCom := DllCall("LoadLibrary", "str", "autoit-opencv-com\autoit_opencv_com454.dll", "ptr") DllCall("auto...

nadure

this occurs because of namespace in xml. in docs. https://docs.microsoft.com/en-us/previous-versions/troubleshoot/msxml/msxml-6-matching-nodes-not-return for example, at my post. i used namespace. https://www.autohotkey.com/boards/viewtopic.php?style=2&t=95251&p=423433 but the problem is that can't ...

nadure

viewtopic.php?f=6&t=89236

this library is the oauth2 authentication library for google.

but, i can't find the example for oauth2 authentication for Teknik in their docs. hm.. wher is it?

nadure

Xeo786 wrote: ↑
05 Oct 2021, 23:34
Great....!
but I have few suggestions

i've doen that.
now you can call like this

Code: Select all

sheet.range( Addrs ).value

nadure

Great....! but I have few suggestions You should make a Class for Range just like you did for sheet so we can do sheet.range(adrs).value then you can make class for color and borders too thank you for your suggestion. I was wandering if i use returned original XML object(now code) or recreate Range...

nadure

hi. i'm making excel treating library without ms excel. it can pick up value or writing cell without ms excel or excel com library. just use native AHK language and msxml com library. TODO List: 1. Reading Cell value -- Done 2. Writing Cell value -- Done 3. Add sheet -- Done 4. Remove sheet -- Done ...

nadure

malcev wrote: ↑
12 Apr 2021, 09:23

i have no idea about getting out public key from private key
May be You can do it with BCryptExportKey function with BCRYPT_RSAPUBLIC_BLOB as blob type.

thanks for the information!

i'll try it

nadure

malcev wrote: ↑
11 Apr 2021, 17:56
I have written examples:
https://www.autohotkey.com/boards/viewtopic.php?f=6&t=89236

thx i've read the post.

that's an unbelievable code!

nadure

thx ! :o I don't know if I'm offended, but I've cleaned it up the codes your example by class. after viewing your code, i have no idea about getting out public key from private key and using the key and encyrpting it. :crazy: this is the code for other people who is searching for jwt rs256. #Include...

nadure

wow, beautiful codes were posted!
thanks a lot!

nadure

with clr library and c# code, get the access token for oauth2 authentication. so dll libary and clr.ahk are needed. file download link. https blogattach.naver.com /5cc940f0e2bdb86448afc8f8c026572784d429c975/20210405_283_blogfile/goglkms_1617631782534_7X3doL_zip/google_oauth2.service_account.dll.zip ...

nadure

Hello, I'm trying to manually calculate a JWT's signature. I'm using: https jwt.io / . Broken Link for safety if you complete a JWT library please share in the Scripts&Functions forum #Include %A_ScriptDir%\Resource\JsonParser.ahk #Include %A_ScriptDir%\Resource\libcrypt.ahk JWT_Token(Header, Paylo...

nadure

Thanks for very detailed explanation.
As your mention, this is very hard way to work on.
but I'm so touching very things. i'll understand little more, and use it another project.

Have a good day!

nadure

Masonjar13 wrote: ↑
29 Mar 2021, 19:22
Tested, it opens the "yes" msgbox. The code is fine, maybe you forgot to save and reload?

To HotKeyIt's reply, if() works fine, believe it or not (in v1.1)

sorry,,

maybe, my compiler is weird.

nadure

example code is below

Code: Select all

a := "="

if(a="=")
{
	Msgbox,Yes
}
else
{
	Msgbox,No
}
return

It said, No

Is this bug?
If not, how can compare the string?

nadure

for other people who using JWT keword for searching, I 've just added title.

nadure

Hi. :wave: Recently, I've just made it. this is my origin blog.(not englinsh) :!: https blog.naver.com /goglkms/222292001153 Broken Link for safety and i'll explain it with english. #Include %A_ScriptDir%\Resource\JsonParser.ahk #Include %A_ScriptDir%\Resource\libcrypt.ahk JWT_Token(Header, Payload,...

Search found 22 matches

Re: OpenAhkXl - Automate Excel with native ahk. no excel need

Re: OpenAhkXl - Automate Excel with native ahk. no excel need

Re: write date & time to Excel file without opening it?

Re: OpenCV COM

Re: XMLDOM - how to display SelectNodes output?

Re: OAuth2 Authorization

Re: OpenAhkXl - Automate Excel with native ahk. no excel need

Re: OpenAhkXl - Automate Excel with native ahk. no excel need

OpenAhkXl - Automate Excel with native ahk. no excel need

Re: Creating signed JWT with RS256 (RSA Signature with SHA-256) for Google Oauth2 authenticating with service account

Re: Google Oauth2 authenticating with service account

Re: Creating signed JWT with RS256 (RSA Signature with SHA-256) for Google Oauth2 authenticating with service account

Re: Creating signed JWT with RS256 (RSA Signature with SHA-256) for Google Oauth2 authenticating with service account

Google Oauth2 authenticating with service account

Re: Calculating JWT signature Topic is solved

Re: .NET Framework Interop (CLR, C#, VB)

Re: Is it possible for comparing string("=") ? Topic is solved

Is it possible for comparing string("=") ? Topic is solved

Re: Json Web Token Encoder in AutoHotKey(JWT Library)

Re: Json Web Token Encoder in AutoHotKey