Suppose we have an excel spreadsheet that looks like: StatusCount FirstName LastName ID 1 Tod Mahones 122145 0 Tod Maho
How to extract / filter an inventory list (in range B3:C7) based on a lookup list with partial strings (in range F2:F3)? I know that if the filtering strings w
I am not able to take the reference from column AB and AC given in sheet ("UPDATER") to sheet("Historical_vol"), can anyone please confirm what am i doing wrong
I want to export to excel but filter search doesn't work when I select range date and export the result is all data before filtering, public function download_e
My dataset looks like this: I am looking for a formula to add to the column "Status" to do the following: If Name = "A" and Project = "TT" and Number > 5, w
First, environment: Excel Version 1905 (Build 11629.20246 Click-To-Run) Connected to Office 365 ProPlus Windows 10 Enterprise 10.0.16299 Build 16299 I've bee
I have an existing Excel file I need to work with. It contains a line graph where measurement results are plotted. All the referencing is done via names. The gr
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