I have a VBA project where I need to create a userform on which there should be an attachment button to select multiple images and save them in a folder with a
I want to look through my Excel worksheets and find a sheet with a certain name and delete that sheet if it is found. Afterwards I want to create a sheet after
I have an array of 30 columns and 800 rows (Sheet 1), each cell has either text or is blank. I want to check if ANY values in this array (specificially row by r
The goal is to iterate through rows of the character table and replace each character with it's substitute. The character table in this example is ={"&","&a
I need help in converting a .xls file to .xlsx using C# and without using Microsoft Office.
Hello I am just trying to get into a bit of macro programing to help my Mom, and Dad get some excel work done, and they have some ungodly amount of paper work i
I am still relatively new to Java and have cobbled together enough code that allows me to write my data out to a new excel file. However, I want it to write (a
I am wanting to write a C# program to copy a specific range of cells below a specific keyword. The code will identify a keyword in Excel and then copy the value
I'm working on a rec process which will pull data out of a SQL Server database into Excel and out of another application to compare the two sources. I've writt
So I have an Excel document, which is essentially a table. For the purposes of this, we will use this: Dummy Data What I'm wanting to do is take the values fr
I have a large xlsx Excel file (56mb, 550k rows) from which I tried to read the first 10 rows. I tried using xlrd, openpyxl, and pyexcel-xlsx, but they always t
Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi
Could you help me solve the following? I want to return the total sum, not the first match that it finds. My first preference is have indexing and matching wi
my application basically accepts an excel file and uploads data to my database which used to work perfect with Excel 2010 with the below code. However we update
I am working on a tool to analyse data. The data to be analyzed is manually copied into the first sheet, then I am planning to run a macro which analyzes the da
I am receiving a null pointer exception when trying to launch an instance of excel to export data to. I have tried adding the newest version of COM4J.jar to my
I have an excel template that has preset formulas, then have my wpf application fills in data in other sheets then the preset formulas takes the data from the o
With xlwings, I am trying to move a worksheet within a workbook to the end. For example, a workbook contains a collection of the following she
Is there a way to have a macro changed when the value is changed is changed, not necessarily when a user changes the value? For example, I have a check box th
The user has hundreds of text files and requires making a change in the data before saving and closing them. Below is the code I have for a single file; how can