I am the author of an Excel add-in that loads data from an internal api. What I want to do is avoid having many users run the StreamingInvocations concurrently
I am the author of an Excel add-in that loads data from an internal api. What I want to do is avoid having many users run the StreamingInvocations concurrently
Currently working on a robot where I want to download an excel file from a system, copy paste the contents of the excel file to a word file as an embedded excel
In the Microsoft graph REST API docs, it shows how to call a function from an excel sheet. https://graph.microsoft.com/v1.0/me/drive/root:/boo
I would like to get the current week number. I tried this: MsgBox (Format(Now, "ww", vbMonday)) The result: 3 But it has to be 2 Where is my mistake?
Long ago I had a macro that would open some workbooks, do some fiddling, then close - all fully automated, called from the commandline so I could batch file it
I am trying to split a string and create a loop for going through the Cell I Want Only This Code Results Column Wise I want A Row Wise Insert
I have a little problem, thanks for whatever help you might bring :) my goal : i want to create a vba function that receives an address and returns the gps coor
I am trying to automate a work task using excel VBA. I can't seem to get all the source code. I created this simple code to test it. dim IE as object Dim S as S
Please see my code below: import pandas df = pandas.read_excel('cat.xlsx') After running that, it gives me the following error: Traceback (most recent call las
I have a spreadsheet which has a lot of duplicates I need to cleanse but need to ensure the right data in another column is kept. Data and desired outcome Esse
I am stuck with this python code regarding SheetImageLoader. The error message says that there's no image in the cell I am referencing, but there's an image in
I'm importing .xlsx file to Sharepoint using Shareplum, i found that when the excel is more then 30MB i get the error ConnectionResetError: [WinError 10054] An
I am trying to create a macro that copies all the data from a csv file to the workbook that executed the macro. I got the code below from this Youtube video It
I am getting some data as JSON via RESTful web api and transforming it into a datatable. Afterwards I want to open an "Excel template" (*.xlsx) with OpenXML and
I want to open a pdf according to the codes in a table that changes daily from the archive with thousands of files. It has to search in two ways. Search by BA22
I am creating a vb.net application to update an excel spreadsheet. I access the excel file using Imports Microsoft.Office.Interop. So far I can add data to the
I have some a weird situation trying to get the output in to_excel pandas function. I tried to read a xlsx excel file with the number "21631706.9893399", but wh
I'm struggling with data validation for the range of cells in a For loop. I want to use a custom formula with COUNTIF to check for unique values. I found exampl
I am trying find e-mail that matches body text and sender. Each day I check if 300/400 emails were already sent. I need to iterate through more than 4500 emai