Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
C0D4669016yWelcome to... wait where are all these new folks coming from π€¨
Ok this is getting crazy, oh hi again, yeah vba is a painful but necessary evil if you work with excel. -
C0D4669016y@broseph but the cake is a lie.
I'm still waiting for it.
I'm pretty sure we have cookies though. -
@C0D4 I just found out that I’m type 1 diabetic a couple of weeks ago so I won’t get too excited anyway π π
-
-Minty-2116y@C0D4 I'm new, though I doubt my reason for coming here is the common one. For data purposes though, I was browsing the top of all time on /r/programmerhumor and found a devrant watermark (probably user made) in a meme.
-
I do sometimes have to code some VBA occasionally. Yeah, it's one tragic language.
Specially when some non-techie made a macro that reads hard-code ranges and values to automate himself and you spend a good day to understand that damn thing!
Get out of vba world ASAP. It's known to be career crushing. -
python+lib that outputs to excel.
maybe pandas.
Avoid vba like the plauge it is. -
Ah, VBA. The only language I've ever encountered that uses BOTH 0 and 1 as starting indexes. *In the same library 0_o*
But no really is there a way to use python for macros? -
@Techno-Wizard not for Microsoft suite as far as I know, but you can use python for Google docs
-
C0D4669016y@Darkovernerd the python partπ
I have a serious need to fully automate a painful process without using excel, it's already macro'd in excel but I want to migrate this task to a sever where the data is read from anyway once put together. -
@C0D4 hahaha yeah. It's a very nice to use API, I think you have to use OpenId Connect or OAuth to access it. If that is the case the client credential flow is probably best for your use case.
-
C0D4669016y@Darkovernerd Oath2, Which is no problem.
I'll have to spend some time digging through the docs to work out my use cases correctly but this looks overly promising. -
@Techno-Wizard well, I've got really good results with xlwings (FOSS).
This is if you are strictly restricted to the Excel environment.
You'll need to add its plugin to excel, and then can use python to write your own UDF (user-defined functions) and call them in excel.
https://www.xlwings.org
Another commercial one is pyxll, but its pretty expensive.
Related Rants
God! I hate doing macro. VBA scares me
rant
vba
macro