Most voted "excel" questions
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X that allows advanced use of mathematical formulas and functions and statistics. For questions about programming in VBA Excel, also use the excel-vba tag. Note that non-programming issues are within the scope of the Stack Overflow, for example those involving the basic use of the tool.
Learn more…1,117 questions
Sort by count of
-
0
votes0
answers321
viewsVBA running python - Script does nothing
Good afternoon, I have a VBA command calling a specific Python script. What happens is that if I run the script manually, it works perfectly, no problem at all. Running by VBA it only gives the…
-
0
votes2
answers184
viewsDifficulty to loop in VBA
I made a code Visual Basics to identify the maturity of insurance policies and raise a pop-up and fire an email alerting you if you are close to maturity. The database is displaying the Policy…
-
0
votes2
answers127
viewsDifficulty in identifying min value and sending selected Cells by email. VBA
I’m trying to do a macro where I can identify if there’s a due date in the column L which expires within a month, and if any, launch a msgbox and send an e-mail via Outlook pasting the entire table…
-
0
votes1
answer474
viewsTransform excel file into array - python
In the code below I am assigning values within the code itself, I tried to pull the values directly from excel using pd.read_excel, but I don’t know how to turn it into an array for this code to…
-
0
votes1
answer569
viewsError reading a column of a file . xlsx using Python pandas library
I need to create a Python list from a column of an Excel file using the pandas library. I have already installed all library components and the files are in the same directory. from pandas import…
-
0
votes0
answers85
viewsVBA - Union of two non-adjacent ranges and transposed paste into another sheet
In order to minimize the number of selections for a spreadsheet in an iteration of 75000 records, I am trying to merge two non-adjacent ranges (2 separate columns, a total of 10 rows) in a…
-
0
votes0
answers57
viewsCopy some columns from the same row, from all worksheets to the start sheet (first) if it meets the criteria
I am doing a project where I need to find the variable in column Q of all worksheets valor procurado, and, if found this criterion, I need to copy the columns from L to Q of that row to the start…
-
0
votes1
answer269
viewsQuery Excel with cell criteria
I have a spreadsheet based on an SQL code powered by our database. But every month I have to enter the code and change the dates to get this information right. I want Power Query to use the values…
-
0
votes1
answer57
viewsVB Visual Studio Cells error
First of all, thank you for your help. I’m new to code and I couldn’t get an answer to these questions even with searching on the net. I am trying to develop a code in the visual studio in Vb.net…
-
0
votes1
answer3450
viewsHow to read an excel table in pandas by skipping the first lines without losing information?
Hello, I have a problem to solve a little complicated, I have several xls tables in which I have to remove some data, these tables are with their content organized strangely... TEXTE TEXTO TEXTO…
-
0
votes2
answers62
viewsGet value by taking into account two columns
I’m trying to get the number of anti-virus licenses per department and I can’t come up with a formula that can return this information to me. Basically, I want to get how many licenses there are in…
excelasked 4 years, 11 months ago RekcsGaming 1 -
0
votes1
answer133
viewsI need to take a column with a lot of redundant information and just take one of them
I own a combo-box where I need him to go coluna "A" and take only one information of each (because it has redundancy of it), an example would be departamente in the case there is redundancy and not…
-
0
votes1
answer34
viewsAutomatic lap update with last 12 data
So guys, I’m already trying for hours and nothing. I want the chart to update automatically with the last 12 data placed. I am trying to put the following formula in the NAME MANAGER:…
-
0
votes1
answer514
viewsRead special characters (such as accents and cedillas) in the html body
I am trying to read a news site, but the special characters (like accents and cedillas) are coming wrong. Example: In html code (and news site) is, for example: Examples 1: "Brazil prohibits people…
-
0
votes1
answer96
viewsvba creating tabs that exceed 31 characters - error
the data exceeds the character limits to name tabs in excel. How could I fix this? Sub compilação() linha = 1 linha_fim = Range("A1").End(xlDown).Row Range("B2:B" & linha_fim).Copy…
-
0
votes0
answers31
viewsFind out the week of the month and deal with special cases
I am trying to do a function that identifies which week of the month belongs to which day and, if the first day is at the end of a week, that it is counted as the day of the previous week, that is,…
excelasked 4 years, 8 months ago Felipe Jaworoski 11 -
0
votes1
answer261
viewsI’m getting this error message >>> Typeerror: Cannot read Property 'pop' of null (line 5, "Code" file)
I’m trying in Google Sheets to sum the values of cells that have the same color background. The problem is that the code is returning me the following message: " Typeerror: Cannot read Property…
-
0
votes2
answers684
viewsSave Path Name and Worksheet Name to a Cell
Good afternoon, Guys, I need a function in VBA that I can select a file and write the file name and its path in two cells. The file path I got, according to the code below. But the file name no, can…
-
0
votes1
answer262
views -
0
votes1
answer26
viewsCall to Undefined Function storeExcelView() using Maatwebsite
I have the following problem, I’m getting this message: Call to Undefined Function App Jobs Pit Reports Placar storeExcelView() Detail: I am using PHP 7.2 and Laravel 6. The same code in PHP 5.6 and…
-
0
votes1
answer267
viewsHow to delete an object in . json using Python?
I use an Excel processing system, which uses Python to make most of its features. I’m having a hard time in this situation: I want to edit a file. json using Python, in particular, I want to delete…
-
0
votes0
answers73
viewsExport data to excel using html javascript
I would like to know how to use a javascript library called Exceljs in the browser I’m importing it into html like this <html> <body> <script src="exceljs.js"></script>…
-
0
votes1
answer51
viewsError while trying to load excel tabs in Spoon Pentaho
I am in need of help, I started to study the tool of the PDI I am doing several tests to learn how to use the tool, but when I try to load an EXCEL file. I cannot load the tabs from the archive. I…
-
0
votes0
answers115
viewsHow to force Excel to respect formatting while expanding a dynamic table?
Good night, you guys. I reached my limit of reason with excel. I created a template for a checksum checklist. However, when inserting more rows dynamically, through the use of userform, excel simply…
-
0
votes0
answers59
viewsVBA item comparison and amount additions
Personal hj I came to insert the image description here a doubt that will be very specific I do not know what problem of this code in vdd Xp I spent a few days breaking my head in it but I have not…
-
0
votes1
answer66
viewsListing in chronological order | Visual Basic
Good afternoon, how do I order the times chronologically without affecting the dates in excel, using Visual Basic? I have a spreadsheet where are saved the entries I do by VBA. In column G are the…
-
0
votes0
answers172
viewsError: Attributeerror: 'Nonetype' Object has no attribute 'write'
I performed some operations on a dataframe by the pandas but I need to keep some cells of an xlsx with a formula. For this I imported a library xlsxwriter but I am not able to evolve my script…
-
0
votes1
answer64
viewsExecution Error 424 - Import multiple XML files in VBA
I’m completely new in vba and I’m having a problem with my code. I need to extract data from some tags from various files XML. When I execute the code or perform Debub, the error of 424 "The object…
-
0
votes1
answer48
viewsI need to insert photos automatically in a spreadsheet in Excel but my VBA code does not work the way I want
Well, I looked for a solution to my problem, (for many photos at once and organized in the spreadsheet) on Youtube, forums and etc., but the nearest solution was this one, which originally filled by…
-
0
votes1
answer26
viewsExcel VSTO: Iterate cells according to their properties
I’m doing an Excel Add-In in Visual C# (VSTO)... I wanted to iterate on the cells of a selection (which may be discontinuous) that are not "Hidden" (hidden). This selection may be large. So, if you…
-
0
votes0
answers45
viewsRemoving Existing Excel Connections with Python
I need help to remove the Excel connection, where I have an SQL query inside Excel that feeds several tabs that are inside Excel, but when I use the code below returns me with an error conn.Delete()…
-
0
votes2
answers334
viewsImport excel spreadsheet with many records with php
Good morning!! I have the following situation, I need to do an Excel spreadsheet import (.xml). Only the problem is that my spreadsheet has over 100,000 records and php can’t read everything. The…
-
0
votes1
answer59
viewsI’m starting in VBA, can you help me?
I need to make a code that when I click on a button (in the "MARC" spreadsheet), it copies the information in the row (which would be a variable) and columns A through G, and leads to another…
-
0
votes1
answer53
viewsMacro that compares value and returns the difference between them
I have a spreadsheet Home and another BD, in BD I have data of various types of cars (Name, Type (Sports, Casual), Color, Seats(2 or 5) and Price. And in Home I have 1 group of Buttons option, with…
-
0
votes1
answer135
viewsRead certain columns of xls file in Python with XLRD
I am a beginner in language and I am trying to display the contents of a spreadsheet on the front end with Python. With this code I am displaying the result of the columns name, surname, city and…
-
0
votes0
answers76
viewsI have an automation error in excel VBA
My code gives an error and closes Excel for no reason. Follows the photo and the code Sub inserir() Dim tabela As ListObject Dim n As Integer, id As Integer Set tabela = Planilha1.ListObjects(1)…
-
0
votes0
answers14
viewsSearch listbox index from two inputs ofTextbox
Good afternoon, The goal is to find the index in the Listbox corresponding to two textbox values. Textbox1 looks for the value in column 0 and textbox2 in column 1. Both of these values in listbox…
-
0
votes1
answer100
viewsHow do I use Python to validate the product column versus its corresponding tax by the xlsx file
Hello, everyone, good evening! I’m new to the community and need help to solve a code. I have a spreadsheet in Excel with several products and their respective tax rates. Only! Therefore, I need to…
-
0
votes2
answers40
viewsCompare the value of a cell with the name of a tab in VBA
I have the following problem: I have 2 tabs a so-called "List" where are the names of the employees and the position that each occupies, this list with names changes monthly, as an example Official…
-
0
votes1
answer42
viewsRepeat image for lines below - MACRO
The VBA formula to insert pictures in the spreadsheet works, however I need to repeat the same code for lines below, however the image is deleted from the previous line, appearing only in the line…
-
0
votes1
answer339
viewsClick on the link with vba
I need to click on the object that has the hyperlink to continue browsing the page. Error occurs on line: ie.document.getElementsByTagName("td")(0).CLICK. Sub busca_desc()…
-
0
votes1
answer31
viewsRefreshall crashes VBA execution
Hi, I looked, but I couldn’t find anything similar to my problem. I work in a company where we have some reports, in a remote terminal, which have queries to databases, after the query always…
-
0
votes1
answer138
viewsHow to identify the last row of a VBA formatted table
Personally I have a seemingly simple problem: I have to identify the first empty row of a table, but this table received a formatting of the excel itself "Format as tables". When I ask to identify…
-
0
votes1
answer81
viewsPython 3 - CSV to Excel conversion problem with list output
Good afternoon. I am facing a problem while converting a CSV file to an Excel file, via openpyxl. The code structure aims to convert a PDF to Excel, and paste the PDF information into a Sheet from…
-
0
votes0
answers27
viewsVBA Progamation to Enter Worksheet Password to Update Information
Great day, you guys! I have a spreadsheet matrix where pulls the information from four other spreadsheets. These four spreadsheets are password protected. I created a VBA code for when open the…
-
0
votes1
answer119
viewsHow to access menu mouseover with VBA
Good afternoon! I’m trying to automate the filling of a form for a website, however, I’m having difficulty entering the menu where the form is. It works like this: I login to the site through a…
-
0
votes1
answer80
viewsInsert signature already made in macro VBA
I would just like to insert a signature made in Outlook itself with image and text in this VBA, but I do not know how. Follow the code: Sub Aplicacao_Fundo() Dim OutlookApp As Object, OutlookMail As…
-
0
votes1
answer154
viewsVBA excel perform action from dropdown selection
Talk people, good afternoon, all right? I came to ask for help from the university because I’ve been racking my brain for days and I can’t seem to solve my problem. I basically have this table: By…
-
0
votes1
answer22
viewsValue calculation and result print in cells on the right
I am developing a macro in VBA and I need to take each of the cells in this range and go through a select case function. So far so good, the problem is that it makes me calculating prices and…
-
0
votes1
answer24
viewsProcv without the last character
I have a procv, where I wrote the following: SE(ÉERROS(PROCV($A2;'PLAN2'!$A:$C;1;0));"Não Encontrado";"Encontrado") It works very well in exact cases of searching for values, but some cases have…