Background:I have a large 40MB XLSX file that contains client data which is Grouped over multiple levels, like so: Expanded - Not Expanded (sorry about the ter
Some Excel native functions like VSTACK permit of infinite number of arguments, and they have an intellisense as follows: I would like to know how to define su
I've been successfully using the Yahoo Finance API cookie/crumb technique to get historical stock quotes for many years. On April 28th, 2022, it broke, and exc
I have an excel spreadsheet that has drop down comboboxes on sheet 1. I am trying to find out how to autofill the 5 boxes to the left of the combobox with conte
I am trying to select a worksheet every time when i open up a workbook using an inputbox in VBA. here is my code for opening a workbook but after i open up my w
I need to place a userform next to a selected cell. Here's my code. Excel 2013. In the userform module: Private rangePosition As Range 'Property passed to for
I have created Excel addin project using Visual Studio to insert a data into database. The problem is I'm unable to open a File upload box in this. I am getting
Good morning, I need to set cells background colors using PHPExcel, but I don't know how to do it. This is for my header and It's working: $styleArray = arr
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