I have an xlsx workbook on my desktop with existing sheets. I have a dataframe in R that I would like to add to this workbook as a new sheet. Using library(open
I'm using this code with vb.net and I'm successfully connecting to the database. However when I try the same code in Excel I'm getting error "run time error 37
I have a really large dataset with a column showing (date and time), X-coordinates the object, Y-coordinates the object, Z-coordinates the object, and speed the
I'm trying to build a second tab in my Excel Add-In and I can't get it to work. I've basically duplicated my first tab and if I delete either tab, they show, bu
I don't know a lot in Excel but I want to add Multiple prefixes in Excel and let them loop until the number of cells ends. I used this Formula, but it picks the
I am currently struggling with coding and need help from an expert. Help. There are a large number of classes ("df-table") on that link homepage. The first clas
Good morning, I have this code below that send an email with an attachement (excel file) and a table in email's body. Sub Email() Dim outapplication As Object
I'm looking to change the behaviour of Odoo 14 Export to Excel function. At the moment if I select at the same time several records of a model and run the expor
Input: Sub RangeFindWithDoubleType() Dim strResult As range With ActiveSheet.range("A2:A11") On Error Resume Next Set str
I have a script that writes data to a csv file, but if that csv file is open (in the excel application on Windows 10) then it generates a PermissionError. This
The purpose of the code below is to check whether or not a sheet already exists in excel workbook. If sheet exists, then set sheet as active sheet with given na
I am relatively new to VBA and have managed to edit a worksheet_change sub from example code found online (Thanks Tim Williams!) that allows multiple selection
I've set up a macro to send an e-mail through Outlook. .Body is read from a cell inside the file with indents. Since the value will change depending on the usag
I get 50 mails with Excel sheets per day. I want to add the first line of each Excel sheet to an existing Excel sheet located on my computer. I first wrote a sc
Here is my DF. data3 = {'DCF Years': ['1st', '2nd', '3rd','4th','5th'], 'DCF Amt': ['8.5', '6.5', '10.5', '4.5', '12.5']} df = pd.DataFrame (data3, columns
I have written code in VBA which copies a dynamic table (dynamic because it could be 20 rows or 200 etc) from one worksheet into another. The issue I am having
My excel file has 500 rows of data. I am trying to get 500 individual JSON files. Each file should have data only from 1 row. Thank you in advance. import json
how can I add rows in excel according to the cell value (as per example below). https://i.stack.imgur.com/q8MQG.png i want to add column D if column A contain '
junior dev here. Goal: Using python, convert file type from xls to xlsx that contains a clean header. Desired header: My attempt: My first attempt was to use w
I have found code to search a table and load cell values into the form. I need to be able to make changes and save the form data back to the table to update th