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
votes1
answer50
viewsUpdate Data Power Query and Copy Values by VBA
I need to update some cells in my spreadsheet as soon as an update in the Power Query table is done, but cells only update the second time I run the code. Sub AtualizarDadosPowerQuery()…
-
0
votes0
answers27
viewsHow to troubleshoot incompatible types error in vba?
I am trying to go through a list of filtered results in VBA and found the following syntax, however when running appears "Incompatible types" loc13 = Workbooks("Histórico…
-
0
votes2
answers158
viewsIncorrect formatting of string to decimal during Excel import
I am making an excel import for a dataGridView and the formatting of the field type Value does not bring the comma, period and decimal place, example: In the Excel it’s like this: 995.800,00…
-
0
votes1
answer136
viewsHow to check different data and get the first SQL record?
I need to create a filter in SQL that follows some rules, I have a spreadsheet in Excel and in it I need to apply the following filter, the spreadsheet has the fields: GSM MOTIVO_ENVIO DATA_ATIVACAO…
-
0
votes1
answer424
viewsEXCEL - Query list and return values
I have a database with the following information: I need to represent this information in graphic, and the need arose to create a query to search the values according to the selected week and month.…
-
0
votes2
answers928
viewsCreate folders from cell information, with the file "test.txt" inside each folder created (VBA)
I have a spreadsheet with some information, I need this information to become folders and within each folder there is a file called "test.txt" In a search, I found the following code: Sub…
-
0
votes0
answers135
viewsConditional formatting between columns in VBA
I need help with conditional formatting. I have a VBA code to compare two columns, one that is in a hidden tab, contains a series of systems that we use in the company and another one contains a…
-
0
votes1
answer28
viewsFormula to transform Minnutos into Days/Hours/Minutes/Seconds
How can I make a formula to turn minutes into Days/Hours/Minutes/Seconds but it doesn’t leave the stake 0 I’ve tried several ways but I’m not getting it. O valor em minutos é: 7188,15 =INT(D8/60/24)…
excelasked 3 years, 3 months ago Arthur Valenca 11 -
0
votes0
answers6
viewsOracle Apex upload data via csv file
I have a problem in my system, I have a demand where I need to implement a functionality to be possible preencher dados através de um arquivo csv, a company would create in Apex the records for the…
-
0
votes0
answers7
viewsHow to remove a specific item from an array in vba?
In my code I have an array, and when performing a validation (the ranges cannot be greater than 6) I would need to exclude from the array the items that do not meet this validation. If tempos(t)…
-
0
votes1
answer54
viewsHow to calculate the total value considering a given attribute as increment or decrement parameter?
I have a spreadsheet in excel where purchase shares (C) and sale (V) are recorded in the same column, already in another column I have the traded values. Example: Ação | Valores ---------------- C |…
excelasked 5 years, 9 months ago Fábio Jânio 3,407 -
0
votes1
answer1575
viewsYou can open excel in Excel without Excel installed;
I am supporting a system that the programmer made use of Oleobject to open and read an Excel file It turns out that I work with brOffice and error Delphi when I try to open excel because the Ole…
-
0
votes1
answer1219
viewsPython Pandas insert records into a column according to the data present in a Dataframe
Good evening, I have an Excel spreadsheet that has a column called Cod and within that column are the valores: 01, 02, 03 I need to create another column in this table that does the following:…
-
0
votes1
answer1245
viewsHow to create a CSV file via Python by keeping the decimal separator in the same place?
I have a Python script that makes a request via API and saves the data in a CSV file. The data is stored in different lists in Python and should be saved in different columns in the CSV file. The…
-
0
votes1
answer74
viewsRead data over file . csv
I have a PHP system reading data from a csv file. It displays the barcode number where I will relate to the database for update according to the file sent in the system. Example: User sends CSV file…
-
0
votes1
answer805
viewsSending e-mail with excel attachment - Python
import smtplib from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText from email.mime.base import MIMEBase from email import encoders email_user = '[email protected]'…
-
0
votes3
answers132
viewsExcel vba - bug when inserting several cells at the same time
I need to assemble a table in which information will be inserted in columns A B and C, and the date and time of when it was modified will be inserted in column D I created a simple program q saves…
-
0
votes1
answer200
viewsUndefined object reference for an object instance. '
Hello, In my code there is this error System.Nullreferenceexception: 'Undefined object reference for an instance of an object.', _oleCmd was null. How do I fix it? (I’m a C beginner#) using System;…
-
0
votes0
answers955
viewsImport Excel data to Mysql
I am trying to make an import of an excel spreadsheet with 536 thousand records by mysql Workbench I saved the spreadsheet as csv but at the time of import it can import all lines but it pulls only…
-
0
votes1
answer48
viewshow to work with genus and species of various tables unifying them to graphics
I am 3 weeks studying java, I have a spreadsheet and in it coast. Genus and within it the species that in column 1 of Excel. In column 2 it has the amount of individuals of this species in a given…
-
0
votes1
answer492
viewsExport HTML table to dynamic Excel with the user
I have a table in html where the user will put the values, after informing the values in this table, I must export as excel. Currently the code is exporting only the values "th", I can not identify…
-
0
votes2
answers220
viewsClientdataset for Excel
I’m exporting a clientdataset for excel with the Clientdatasettoexcelfile function, but one of the information is CPF/CNPJ ex: 00112312312, that is, it contains zeros(0) at the beginning of the…
-
0
votes1
answer281
viewshow to populate a site field using excel vba
I would like to know how to fill the field. I have tried several combinations to fill the highlighted textbox in the photo, but nothing works. I tried things like: IE.document.all("stk…
-
0
votes1
answer697
viewsHelp with VBA Excel - lock cell after fill
Hi, I’m trying to improve the control spreadsheet of the company I work for, but I’m having trouble. We have to register a customer’s call, I have already been able to fill in the Date and Time…
-
0
votes1
answer108
viewsHow to create a chart with the last row data automatically when closing the form?
I’m making a VBA form with information about some municipalities (that are in Combobox) and their respective goals to be hit (which is like a direct formula in the spreadsheet). In the form I insert…
-
0
votes1
answer181
viewsEmpty columns of a spreadsheet when using pandas read()
import pandas as pd wb = pd.ExcelFile("meus_dados.xlsx") sheet_1 = pd.read_excel("meus_dados.xlsx", sheet_name=0) print sheet_1 that line of code brings me that answer: Nome CPF ... Unnamed: 8…
-
0
votes0
answers115
viewsWeb Scraping on Infomoney page
I have the code below that accesses the Infomoney page and selects the All option from the button to return all results. The problem is that it only selects, but does not click to return all…
-
0
votes1
answer58
viewsHow to generate a report from a recorded macro?
Good afternoon to you all, I recorded a macro to generate a report from a spreadsheet that I am feeding with data. Basically the macro will create another workbook in the same worksheet and paste…
-
0
votes2
answers551
viewsExcel with slow macro
Good afternoon After a simple copy macro, to update a planning sheet, the excel file becomes progressively slower, both in the execution of the macro and in the normal workability (write, drag…
-
0
votes1
answer276
viewsHow to save an Excel spreadsheet from R without blank lines?
I’m working with a large database and it has a few lines with blank Ids. And I want to save only lines without blank ID in an Excel file. Whereas the Ids are in the first column of my matrix, here’s…
-
0
votes1
answer157
viewsConditional completion
I need a help with VBA. My question is this:: I need cell "B" and "C" to receive a specific value when I type a value into cell "A": For example: When I type the value "1" in cell "A", cell "B"…
-
0
votes2
answers239
viewsActivecell.Formula compatibles types
I am Using VBA and I came up with an impasse: I can use a variable I created as a parameter to fill a spreadsheet? I created an interactive Button and I am developing an algorithm that fills the…
-
0
votes1
answer38
viewsDo Excel formulas continue to work after being imported into a Datagridview?
I have a spreadsheet in Excel where I import it, to present the data in a DataGridView, i wonder if the formulas that are contained in the spreadsheet still work in the DataGridView. To be more…
-
0
votes1
answer73
viewsProblem with exporting xls
I am making script to export a table pro Excel when I open it shows null follows the code: function M(){ var nProcesso = document.getElementById('nProcesso').value; var Autor =…
-
0
votes2
answers189
viewsHow to locate information by considering a range (range of numbers)
In the company where I work we are automating the process of calculating variable remuneration, and for this we are transposing all the logic that was in the EXCEL to the database. However, I’m…
-
0
votes1
answer157
viewsUse VBA in excel to fetch data in . Docm files located in Subdirectories
Good morning, I have following problem in a VBA code that I use in Excel to pull data from forms created in Word. If the files. Docm are inside the same folder I can pull all the data I need from…
-
0
votes1
answer244
viewsTake the code in a cell and format the e-mail using this value (VBA) (EXCEL)
My problem is this: I use a company tool that gives me a specific number for each client. When I send email to the client, I need the subject to contain this number. With that in mind, I found a…
-
0
votes0
answers28
viewsTEXTJOIN searching for duplicated inputs and concatenating result in the same cell
I need to show only the domains that a particular account is part of. I tried a few ways with TEXTJOIN, IF, INDEX, and the most I got was the result below, that it ends up showing the whole array as…
-
0
votes1
answer289
viewsVBA Variant array position for String
Good morning, I have in the Excel a search that returns a ARRAY of Variant filled with the full address of the found files. I need to pass each array position to one STRING, I’m trying to wear a bow…
-
0
votes2
answers118
viewsError inserting formula into a cell in Excel via C#? Worksheet?
I have the following code: newWorksheet.Cells[1, 1] = "Status"; var var1 = newWorksheet.Cells[2, 1] as Excel.Range; var1.Formula = "=CONT.SE(Planilha1!B2:B7;'Ativo')"; newWorksheet.Cells[3, 1] =…
-
0
votes1
answer59
viewsInsert Formula Matrix in Excel, via C#. ? (If you insert directly through excel, I have to give Crtl - Shift - Enter) - How to do this command with C#?
The following Code inserts a Formula into a cell in Excel. Based on the Spreadsheet "DATA", AND According to the column beside. However, this formula is a Matrix Formula, which in Excel needs to be…
-
0
votes1
answer249
viewsSearch the Dynamic Table with a macro
I’m trying to set a button to copy the value of a cell, paste it into one of the children of the dynamic table and give ok. Sub Botão17_Clique() ' ' Botão17_Clique Macro ' ' Range("H3").Select…
-
0
votes1
answer123
viewsHow to use PROCV to search for code in two spreadsheets?
In Excel 365, version 1907, and Windows 10, I have an XLSX file with two almost equal sheets - Sheet 1 and Sheet 2. Contents of the Spreadsheet1: Contents of the Spreadsheet2: I want to check in…
-
0
votes2
answers581
viewsCreate a spreadsheet with folder names listed from a directory in excel
I’m using this code to list the folders that contain some names I need to spreadsheet. Option Explicit Sub CreateList() Application.ScreenUpdating = False Workbooks.Add ' create a new workbook for…
-
0
votes1
answer194
viewsMacro VBA to organize records in employee point report
I need to organize the data that’s in chronological order for a report that’s in date. Macro must first iterate through the CRM column, then through the DATA column and organize the same date…
-
0
votes1
answer366
viewsExtract file . zip Password protected
I am doing a VBA macro in excel, to extract . zip files (which would be a barbada to do), except when the file is protected. I searched everything that is corner, there are several tutorials to…
-
0
votes1
answer42
viewsAdd exception in Cell.Delete
I was using this Sub Clearcontents to clean up all the content I had in the Sheets, I need to add an exception that is the G1 cell and I found this other Sub, but I don’t know how to mix the two Sub…
-
0
votes1
answer63
viewsSort Worksheet by something by clicking on "explore"
Good Afternoon everyone, I am trying to filter a specific spreadsheet. The idea is to filter a spreadsheet by a subject. By clicking Explore. Example "Worksheet to be automatically filtered" I put…
-
0
votes0
answers264
viewsRuntime error '424' when running SQL
I’m trying to send data from excel to access through a macro. I edited on top of a ready and it seemed to me that I was doing the same thing, but it gives "Error at runtime 424 - the object is…
-
0
votes2
answers133
viewsUnify multiple worksheets from different workbooks
I have 800 Excel folders containing 1 sheet each, I need to unify these sheets into a single... I only need the columns A and B of each sheet and that it always paste the columns in the next free…