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
600
views
My first vba-selenium code
I have been obtaining financial information on an annuity I have which is invested in multiple funds which are proprietary to the insurance company.
The asset value is not available other than on ...
2
votes
0
answers
409
views
How to speed up the VBA scraping process
I want to scrape 25000 addresses using Column A cell values as search strings. I'm using the following code, it is working fine but it's too slow to extract 25000 results. Is there any way to speed up ...
2
votes
0
answers
37
views
Speeding up my Python code for reading from Excel, performing geospatial analysis and writing to Excel files
I have written a Python snippet that reads lat and long stored in an Excel file. Converts them to a point which is then used to perform multiple geospatial analysis including buffer, intersection, and ...
2
votes
0
answers
82
views
Modeling data from Excel sheets to parse to Excel sheet
Background:
I have close to 50 excel files - I cannot change the data source - and I steadily get more.
My task is to make sense of all that data and, lo an behold, save that as another excel file (I ...
2
votes
0
answers
44
views
Create a distribution from .xlsx file using Java
I have an Excel file with 2 columns, names and numbers. I want to know for each name what is the probability for each number. I prefer to do it in Java so I would be able to combine it with the rest ...
2
votes
0
answers
1k
views
Extracting Excel cell format with Microsoft.Office.Interop.Excel in C#
I am trying to fetch the format (e.g. background color, border settings) of each cell in Excel file with Microsoft.Office.Interop.Excel class. I know that there are many tools could be used well in ...
2
votes
0
answers
442
views
Generic function for interpolating missing values in power query
I have written a (relatively) generic function for interpolating values in power query (also useful for power bi and m code).
I am looking for any improvements or input, but especially:
speed
handle ...
2
votes
0
answers
117
views
Copying Data from multiple workbooks -> Into One Worksheet (continuous data)
I have a macro created by my predecessor that I run on a monthly basis. However, it does take a while to get through, and I would like to clean it up for efficiency please.
It copies data from ...
2
votes
0
answers
997
views
Excel to Json getting file data into state in React JS
I am using dropzone and XLSX to load excel documents and then convert them into json.
The goal is to upload as many documents as possible and it will create an object with a key of the file name and ...
2
votes
0
answers
59
views
VBA Excel bulk data loop for few columns at once
Good afternoon,
I have a set of working code, which works as a loop between values i = 0-90 step 0.25. It gives 360 combinations exactly.
I used to do this loop separately column by column. It takes ...
2
votes
0
answers
300
views
Optimizing the openpyxl program
Purpose of the code:
Let's say I have 3 excel files to deal with.
Those file have already been filtered or hidden because the content is very large. And I only need part of the content for every ...
2
votes
0
answers
2k
views
Resolve parent child hierarchy in Power Query M code with sorting columns
Based on this article
And this question posted on the power bi forums
Objectives:
Resolve a hierarchy (parent - child relationship) in Power Query adding levels and their corresponding sorting ...
2
votes
0
answers
80
views
E-Mail Automatisation Project with smtplib but did not use MIMEMultipart
The goal of the project is to automate sending the same e-mail to a list of people with the same text (except the salutation "Dear Name of Person") with an HTML signature and a PDF attachment.
For ...
2
votes
0
answers
176
views
Intersect Method Slows Down Code In Large Selection Of Cells
I have picture in certain cells. When I run following code (With Intersect Method) in smaller number of selected cells, it runs correctly but when the number of selected cells increase - say above ...
2
votes
0
answers
139
views
VBA code to account for multiple users too heavy on save actions
I have a worksheet I use with a small handful of colleagues on a daily basis to share information with about orders we place. To make sure we always have the same up to date info we use a shared excel ...