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
-
1
votes1
answer282
viewsHow to create a dynamic table with multiple line fields using VBA?
I want to create a dynamic table with several line fields. But, these line fields need to be changed according to the data entered in the Excel spreadsheet. I tried to define the variables and use…
-
1
votes0
answers88
viewsPython - How to organize an excel line from python?
Hello, this is my first question here, I don’t know if I’m asking you correctly, but come on. From the "Concat" functionality of the pandas package, I am joining several excel files, the code that…
-
1
votes1
answer2720
viewsVBA - How to send specific cells of a spreadsheet in the body of an email
Hello, I’m trying to make an application for my work in VBA, however I’m having difficulty sending only some cells in the body of an email directly via outlook. Private Sub CommandButton1_Click()…
-
1
votes0
answers225
viewsBrowse Json VBA Object
Good night, I’m having difficulty traversing the object to get the result of a API Object to be covered Sub AtualizarJogadores() DoCmd.SetWarnings False Dim Movie As Object Dim R As Object Dim…
-
1
votes1
answer55
viewsReturn all correspondence in excel
Hello, everybody! I am developing a table that returns the activities performed by each employee of my company. The reference table is as follows:: Based on this table, I am developing individual…
excelasked 5 years, 6 months ago Paulo Duarte 11 -
1
votes1
answer81
viewsVBA Add "-" every two characters to form MAC Address
I would like to form a MAC address from the data collected from a barcode reader. I need every two characters to be added one "-". Entry text: A9B8C7D6E5F4 Output text: A9-B8-C7-D6-E5-F4 So far I…
-
1
votes0
answers45
viewsWeb Scraping with error
I have the code below that is wrong on this line: Set JSON = JsonConverter.ParseJson(response) Below is the complete code. Option Explicit Sub GetCompanyInformation() Dim hReq As Object, JSON As…
-
1
votes1
answer287
viewsExcel x Web Scraping - FIPE table giving error
The code below works perfect to return data by Excel with Web Scraping. I installed in the file the module VBA-JSON-2.3.1 - module name Jsonconverter.bas. I enabled the Microsoft Scripting Runtime…
-
1
votes1
answer37
viewsError: Unrecognized escape Quence
I am developing a program in c# to read files. xlsx and it is giving error in the path "path" on line 9 of that file and I don’t know why. static void Main(string[] args) { static…
-
1
votes1
answer554
viewsExcel cannot locate spreadsheet
I have a very strange problem: I made a program using Winforms in C#, and this program manipulates data from an excel spreadsheet. This spreadsheet is saved on the company network, to which we all…
excelasked 5 years, 5 months ago krobelusmeetsyndra 113 -
1
votes1
answer145
viewsPHP Excel is exporting data skipping line
I would like help to understand why when generating the report the data are not matching with the information tags , the same keeps skipping lines Example of how the file looks <?php $dadosXls =…
-
1
votes1
answer574
viewsReset a dynamic array - Redeem or Erase?
I have a UserForm with three OptionButton and three ListBox. When opening the UserForm all three ListBox are loaded with different texts, because each one relates to a type of data as is explicit in…
-
1
votes1
answer4825
viewsManipulation of Excel in python
I would like to update excel every time the program runs, but the library only lets me write a new excel, and not update it. How can I do that? import requests from bs4 import BeautifulSoup import…
-
1
votes1
answer60
viewsHow to generate and download excel from a large volume of data in ASP.Net MVC?
Hello I have web application that provides a download of contents of the database in excel format, I am using in my controller a method of type Fileresult. Below abridged version of the code. Simple…
-
1
votes1
answer483
viewsError when transporting excel data to python - date format
My code consists of pulling information from an Excel file and transporting it to a database through Python. But in data type fields (formatted in Excel itself) when importing the data they are…
-
1
votes1
answer177
viewsApply button - Visible cells
I have a form where there is a Listview, and textbox for data input and already by login I can filter a column, to appear only the fields I want. Where is the problem? the intention is, I click on…
-
1
votes0
answers211
viewsHTML+ PHP extraction for EXCEL large numbers with wrong formatting
I have a web system that converts a table HTML for EXCEL, however it has a field corresponding to the CNPJ , when I transform this table to EXCEL, it return me with 1,111111+14 instead of…
-
1
votes1
answer55
viewsHow to get information from Excel cells using VB
I’m trying to get information from a column in Excel using VB. Let’s assume that I have 5 lines and only 2 of them are filled with some information and the other 3 are null. I need a code that takes…
-
1
votes1
answer44
viewsPanda does not create new lines in Spreadsheet
When creating the program in Python I take some information and put it inside a list. When trying to write this list in an excel file the data ends up getting all in the same block without creating…
-
1
votes0
answers256
viewsCount values from a column ignoring whether the value is already repeated
I have this following spreadsheet with each column being a date. And on each date I have these following records, however they may repeat this record on other dates forward. As is the case of record…
excelasked 4 years, 11 months ago Leandro Pedrosa 11 -
1
votes3
answers426
viewsSelect area escpecify in excel VBA spreadsheet
I have the table below in the photo, and would like to create a stacked area chart based on benchmarks (column values). I’m using the following code Private Sub CommandButton1_Click() Dim planilhaB…
-
1
votes1
answer2453
viewsPython - how to create spreadsheet in excel (with 100 columns)
Good afternoon! I already know how to create a spreadsheet in Excel by Python, when I know exactly which columns I need to create. But how can I make the creation of columns dynamic? for example: to…
-
1
votes0
answers91
viewsRstudio - Update and add new data
Hello, I’m looking for IBGE data (library("sidrar")), df <- get_sidra (api = "/t/1846/n1/all/v/all/p/all/c11255/90707/d/v585%200") #Selecionando as colunas que me interessa df1 <-…
-
1
votes1
answer448
viewsError reading file . xlsx in R
I have a file .xlsx which I need to read in R. The tab is variable, so I use a code first to check which tab is the most recent, but when using the function read_excel package readxl, returns the…
-
1
votes2
answers351
viewsindex 5 is out of Bounds for Axis 0 with size 1
Well, I have this code, I want it to take specific columns of 3 sheets and join in one, ams is giving the following error: index 5 is out of Bounds for Axis 0 with size 1 import pandas as pd Corp =…
-
1
votes0
answers201
viewsEXCEL - VBA - SQL - Doubt in the query using CAST
Hello, First I apologize to ADM if there is any error in formatting the question, I am novice here rsrs. I have a question in the QUERY query using MAX and CAST Goal: Return the highest value in the…
-
1
votes1
answer284
viewsRuntime error 13. Incompatible types
I was building a simple listing, and came across the 'Runtime Error 13. Incompatible Types'. When I Clear it tells me that the error is in the two lines of code of my 'If', referring to the dates.…
-
1
votes1
answer1287
viewsCorrect formatting for excel vba time
Good afternoon! I’m finding a problem that I thought was basic but that I couldn’t solve. I have a Userform (Entradas) to register entries. These entries are played to my spreadsheet in Excel. In my…
-
1
votes1
answer337
viewspython and excel(doing automation)
this code below it takes dice from a spreadsheet and plays on a list then want the dice from this list plays on another spreadsheet. Until the list get but when it comes to moving to another…
-
1
votes0
answers18
viewsReadjustment of an LPU using Python
Hello, I am writing a code in python, using the citizen calculator library, to readjust the items of an LPU to register 12 months, the LPU will be inserted by an excel, the base date of the reajsute…
-
1
votes1
answer51
viewsHow to exit the VBA loop
Hi guys vcs can help me, I’m running two loops, but I need to stop running the loop when the rows2 variable equals 38. I’m a beginner in programming. I don’t know how you solve. Sub qty() rows1 = 2…
-
1
votes1
answer133
viewsAbstract class 'Excelwriter' with Abstract methods instantiatedpylint(Abstract-class-instantiated)
I’m trying to save some Dataframes in an excel file but the same is giving error, I saw some tutorials and even leaving identical still gives error. writer = pd.ExcelWriter('pandas_simple.xlsx',…
-
1
votes1
answer49
viewsI am having trouble synchronizing the execution of this program -- JS, Promise, async and await
Guys, I’m having a question, I’d like to read an Excel spreadsheet, store your content in a variable and then display it on the screen. However the method that reads the file -- parseExcel -- occurs…
-
1
votes1
answer29
viewsVBA error while deleting tab
My dear good day! I need your help with the code below. Sub atualizar() Application.DisplayAlerts = False Sheets("Reembolso").Delete Application.DisplayAlerts = True Sheets("Modelo").Copy…
-
1
votes0
answers55
viewsCut a number of characters inside a VBA cell
I have a VBA doubt! Using a VBA code I imported data from a spreadsheet in excel to another spreadsheet. However, in column A, starting with cell A2 the copied information is in the following format…
-
1
votes1
answer215
viewsvba excel to save sheets of a pdf file with the name of each sheet
I don’t know much about VBA, but I need a routine that saves each of the spreadsheets of a file in separate Pdfs, for example: The excel file RELATORIO has within it 24 spreadsheets (nominees:…
-
1
votes0
answers23
viewsBest way to eliminate duplicate rows in a mysql table (Best Practice)
Expensive, I’m doing my first project on Mysql - I’m not an expert yet - so forgive me if the question is too easy. I am migrating data to the Mysql database - it should have about 4-5 million…
-
1
votes1
answer29
viewsHow can I analyze several distinct elements in excel using 3 logics for the same column?
So, guys, I have to sort out an excel table of investments, but I have no idea how to do that. They are 2 logic for a column where appears the (Difference of a product purchased the previous day…
-
1
votes1
answer54
viewsMy dataframe skips a line in excel when Columns receives more than one line (pandas)
I’m trying to make dataframes and pass them to excel, but when I do a dataframe with more than one header line, it skips a line before plotting the data in the spreadsheet (leaves an empty line). It…
-
1
votes1
answer55
viewsProblems with web automation in VBA - Radio Button
Hi, I’m new around here, I am facing a problem with my VBA code, I am trying an interaction using the internet explore, I need you to do the following steps access the site:…
-
1
votes1
answer39
viewsVBA - I cannot reference there is a Range using the Cells method - ERROR 400
This first method gives me an ERROR 400 Worksheets("RELAT").Range(Cells(i, 3), Cells(i + 1, 12)).Value = Worksheets(mes).Range("P5:Y6").Value This second method works normally…
-
0
votes3
answers2192
viewsIncompatible date format when importing data from Excel to Mysql (00-00-0000 VS 0000-00-00)
I am trying to import data from an Excel spreadsheet to Mysql, the problem is that I have a column in Excel that dates are in format dd-mm-yyyy and the format accepted by Mysql is yyyy-mm-dd. I want…
-
0
votes1
answer438
viewsExcel button to choose
I want to know if it is possible with buttons or list or with some formula. For example I have a list with name of countries (Portugal, Spain, Brazil) and I want in the other list just show me the…
-
0
votes1
answer3120
viewsValidate field in VBA
In Mozambique there is a unique tax identification number (Nuit), and this number takes 9 digits. How an application would look to validate the Nuit meeting the following conditions? If there are…
-
0
votes1
answer2156
viewsIP control with Excel + VBA
I’m building some functions to analyze an IP table. I just used VBA for the first time in my life and in my research I found nothing that could help me. I need to create a function that looks for…
-
0
votes2
answers300
viewsRead file . xlsm (Excel) from my application
How I read a file .xlsm (excel spreadsheet) from my application? Basically I need to get the data from this spreadsheet. Get the value of each of the cells that this has. Is there anything native…
-
0
votes0
answers441
viewsMysql For Excel and options to import Excel table in Mysql
I am trying to import a database that is in Excel format to Mysql. I was trying with Mysql For Excel, launched same company. As you can see in the image below it is already installed: In my Excel…
-
0
votes1
answer1459
viewsGet name of worksheets containing in an excel file with c#
I have a problem regarding getting the name of the spreadsheets that have to in an Excel file. I need to read a file that contains several spreadsheets, and would like to get the name of all and…
-
0
votes0
answers60
viewsAutomatically add line
I wanted an sql script or excel function that runs along the line and when find "Out of Compliance" add me a new line Name Food from Approved Source (C) Food Protected from Contamination (C) 16…
-
0
votes1
answer16582
viewsMerge duplicate names into one line
I have this spreadsheet: I have in the spreadsheet the client ELISMAR CARLOS RODRIGUES DA MATA, who made 3 purchases, two on the date 10/08/2014 and one on the date 20/08/2014. What I need is to…