python

I saw the new Python function is added to Excel since August 2024. How effective do you think this new feature is? I always prefer macro-free excel. I was happy at first when LAMBDA feature was released, such revolutionary. I used it for many custom functions. Then I realize it slows down my...

I cannot figure it out. I am trying to scrape a table from the website CapWages - NHL Salary Cap Data which will scrape the first 50 rows but because the website makes you click next page, it will not display the next ones. Normally, websites add to the url to advance the page...but this site...

so hello, I am using beta M365 Excel and I am working on some sort smart solution for some. What would be great is to get Python code that generates path to a desktop ( or at least Windows username ) My problem is that I tried: # importing os module import os # using getlogin() returning...

I am new to Power Bi. Are not DAX and PQ suffice? What could Python and R programming languages add to power Bi?

Hi guys, I am looking for a way to filter out elements from my column that adds up to a target sum, and I thought that I have found a great solution online from Combination of numbers that sum or match a target value. However, the program takes forever to load for negative values. I have found a...

Hello, I've seen some options to use Python, Java and C# in Excel. Wondering if anyone has tried it and if they are considered "safe" to use. Saw this: Excel-DNA where I could build classes in C# and call them using the "=" inside cells in Excel. (Perhaps this is also possible with VBA?) Felt...

I am attempting to call a python script from VBA and wait for the script to finish before continuing with the macro. However, It doesn't seem to be calling the python script.. any ideas what I may be doing wrong? Code I have so far: Dim objShell As Object Dim PythonExe, PythonScript As String...

Hi, I am interested in a way to merge/copy sheets from multiple Excel files into a single Excel file. Some tool or script (python/java?) that will work in Unix and Windows systems, with/without MS Excel installed. While preserving existing cell format/style. Something equivalent to going over...

Using Plotly (with Python), I have generated an interactive 3D graph. Please could you help me in finding a way to plot the graph in Excel, so that it keeps its interactive features (i.e. Graph is replotted within Excel if data of the axis value is changed)? i.e. Imagine that there were four...

Any help would be greatful! Looking for a way using python or VBA to basically transfer data from workbook one to workbook two. The yellow cells and the light grey cells are the areas where data will be put into. I know it may show two rows, but the user is able to have multiple. As you can see...

Hi, I want to write a formula that computes the normalised Gibbs entropy, which is computed as follows: The values that I want to test this for are located in column Z, AD, AH, AL, AP, AT, AX, ..... CL etc. so 3 columns are skipped every time. I want to test for values 0 - 10. I already...

I am trying to handle an error in a macro from another workbook, but on error is not working within any error occurring in the macro from another workbook when I use application.run. Anyone know why it is not working and how to solve this? Set wb = Workbooks.Open(workbookpath) On...

I think I've found a bug in Excel, related to the print area. When I print to PDF on a VM that I don't have an open window to (using python to control Excel), the print area is ignored. Has anyone else experienced this, and has a workaround? Apologies for cross-posting to Stack Overflow, but...

I am processing over Excel files in Python, and opening it as a part of it. I suspect my code doesn't execute fully because it doesn't recognize warning messages In my VBA code I use the following: Application.EnableEvents = False Application.ScreenUpdating = False But I am not sure how I...

I want to import ,say, D column from .xls (not csv) file, data is range, not table. How to do that ? I found how to import named column, but not basic

Hi Someone told me learning Python and Matlab is a must these days. Many job ads are asking for to be good in one of the following: VBA, Python and Matlab!! Which one you think it better to learn? Thank you very much.

So far throughout my searches I always end up being offered MS Cognitive or Azure. Is it possible to somehow teach Power BI to recognize phrases with Python/R (or any other accessible tool) or build some neural network in Power BI to recognize them. Word Cloud is not helping much, as it...

I've been working with VBA and Python recently but I've never combined the two. I'm just trying to get my head around how the 2 communicate with each other. Is it possible to set a variable in VBA and then Python can read the value of the VBA variable? For example, if the VBA variable was from...

Hello, I'm trying to figure out how to use the new filter function in Office 365 Insiders. =FILTER(tblCourses[Name],tblCourses[Name]=B1) works perfectly fine if the text in B1 explicitly matches the text in the Name column of the tblCourses table. What I'm trying to do is incorporate a loose...

Hello Everybody, I am myself an excel VBA programmer as well as programmer in other languages i.e. Java, JavaScript, Python and C++. Currently I got a project where I have a huge dataset (more than 20,000 records spread over 25 columns) and not only that I have to search each record, I have to...