Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
111
questions with no upvoted or accepted answers
2
votes
0
answers
413
views
VBA Array Functions: insert element, remove element
An extension to array functions I am building for my snake game. This one allows you to remove / insert particular elements.
https://github.com/Evanml2030/Excel-ArrayFunctions
API CALLS
...
2
votes
0
answers
2k
views
VBA array functions: push, pop, shift, unshift
I want to write my snake game procedurally, using as much windows call as I can so as to practice. Looking into GetAsyncKeyState to capture keyboard inputs and play sound functions. Also making a ...
2
votes
0
answers
133
views
Fixing Medical Claim Files through Text File Read/Write v2
This is another review on a program I've asked about before, with a different target in mind.
Program Function
As before, this program makes emergency changes to medical claim files, delivers all ...
2
votes
0
answers
86
views
VSTO add-in for Excel to solve systems of linear equations
This code is part of a VSTO add-in for Excel. As the title states it solves systems of linear equations by allowing the user to select the appropriate ranges. The code works and covers most issues I ...
2
votes
0
answers
96
views
Use arrays to perform 'VLookUp' type activity between workbooks
Background
I have the below UDF that opens a workbook (this workbook has extracted data from a queue within another app). I get the used range from this workbook and assign it to an array (...
2
votes
0
answers
114
views
Excel for travel expenses
Every Month I need to make an excel sheet with travel expenses, since this is a tedious task I decided to make a little python script to do this work for me.
Everything works correctly, but any ...
2
votes
0
answers
1k
views
Regex search to Excel
I made this to track my variable changes while I experiment in Python. I tend to use the same variable names and fit different values to them so it's nice to be able to see what I've tried, especially ...
2
votes
0
answers
636
views
Create and email an Excel report of data retrieved from SQL
This is my first Python (3.6) script which I would appreciate some critique of.
I am generating a daily alarm report. The data is gathered from an SQL Server database, presented in an xlsx file ...
2
votes
0
answers
99
views
Programmably Typing the Tables, Views, and Columns Properties of a Database
Programmably Typing a Database gives you the advantages of Intellisense and Compiler Type Checking.
Notice that single public DatabaseAlias variable of public Type DatabaseAlias is used. The ...
2
votes
0
answers
88
views
R code to read table, perform calculations, and write excel
I hear loops are best avoided in R.
Is there a better way to do something like this perhaps using lapply, etc.?
...
2
votes
0
answers
69
views
Updating Excel sheet with information from a DataTable
Basically, I'm trying to update an excel sheet using a DataTable (The columns structure between the two are not the same) with respect to the following rules:
...
2
votes
0
answers
11k
views
Use NPOI to read string value of all cells in a row in xlsx file, including merge cell
I'm currently using NPOI library to read the value of all cells in one row of a xlsx file and return a List<string>. However, if a cell is part of a merged ...
2
votes
0
answers
726
views
Speed issue when controlling Excel from Access VBA
I have a very hard time figuring out how to proceed. I built an Access DataBase which I use to process data in order to build several weekly and monthly reports. I wrote VBA codes in Excel and in ...
2
votes
0
answers
48
views
Creating an Excel sheet and appending namings for a matrix
I'm working on some VB.Net code to generate data sheets for giving user rights on a per folder level. I came up with this code but it's very slow and I feel like it could be improved.
...
2
votes
0
answers
131
views
Multithreaded download of images from a spreadsheet
I've been wanting to go async with my HTTP calls but all the methods I tried have not worked, so I resolved to implement this as a task and then improve upon it.
This is what I've come up with so far....