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
votes2
answers392
viewsI need to join several excel files in a single split into python folders. I did this method but wanted to create a function:
I made this function that receives the destination directory and the month that was generated the reports, I wanted to make it smaller using a for that goes through this list: ufv_name = ['CB1',…
-
0
votes1
answer365
viewsExtract specific information from an excel cell using pandas in Python
I need to extract information from a cell in excel using pandas and pyautogui. The cell has a date contained and accurate take out the numbers without the "/" bars. Example: 25/12/2000. What I do at…
-
0
votes3
answers42
viewsAverage function in excel
I need to insert the average function in excel in ranges. For example, from A1:A5, just after A6:A10, A11:15 and so on. How do I make excel understand this logic? I thought to make him understand…
-
0
votes1
answer26
viewsVBA - Copy and paste column to the new tab with the given code
Hello! I have a VBA code in the format below. It takes all the information from column B and sends it to another tab, whenever the value of B1 is changed (only does not create another, if you…
-
0
votes0
answers17
viewsPOI ( Execel column reading is different)
Boys, good afternoon, boys ! I have a column in Execel that contains the value : Import used : import org.apache.poi.ss.usermodel.Cell; When I read it like this : spreadsheet.getRow(i). getCell(1).…
-
0
votes1
answer28
viewsdata types inside the vba
I have a macro that does a conversion, it brings a fixed width txt converts to excel and saved in csv. what happens is that I need the last column to be saved in txto format because it deals with…
-
0
votes0
answers62
viewsAutomate excel in python sequence
In a google form that transforms all filled data in excel spreadsheet, I did in python a programming that copies the data of the first line and fills a form I need. There is the possibility of this…
-
0
votes0
answers15
viewsI would like a help to transform this VBA code to the Google Apps Script script script
I would like a help to transform this VBA code to the Google Apps Script script script. Dim HTMLDoc As HTMLDocument Dim oBrowser As InternetExplorer Sub Login() Dim oHTML_Element As IHTMLElement Dim…
-
0
votes0
answers20
viewsHow to write an . xlsx file permanently, using the Closedxml library?
When you run the code for simulation, you notice that it is changing the file test.xlsx as expected, however, when closing the execution it does not save the changes as, when running the program…
-
0
votes1
answer57
viewsHow to use a python command in Windows?
I made a Python code that takes an excel spreadsheet with data from all over Brazil and creates several files separated by states. Ex: spreadsheet contains data from SP, RJ, BH, RS and etc... Python…
-
0
votes0
answers19
viewsLoad table in Listview
I’m trying to load a table into listview but when I press the button it gives me a mistake saying that the Required object(error 424). Private Sub btnPesquisar_Click() With txtResult1 .Gridlines =…
-
0
votes1
answer60
viewsError: string indices must be integers in loop
good evening, I’m needing to do a for a request based on an excel, with that I’m doing so: df1 = pd.read_excel('D:/repositorio/python/leitura.xls') count = 0 for y in df1['EAN']: data…
-
0
votes0
answers48
viewsHow can I reference filtered results from a list in VBA?
I am currently working on a code where I have to filter a certain list and go through the filtered data with a FOR and also perform some comparisons with IF. Follows the code Sub compararValores()…
-
0
votes0
answers38
viewsExcel export
It needed to export some elements of R: distribution tables, Plots, etc to excel in order to "fill" predefined and formatted spaces (namely as regards colors, font etc.) in excel. How can I do?…
-
0
votes0
answers9
viewsHow to Save File Inside Folder(Variable Name) Excel VBA?
am having trouble saving workbook in created directory Code to create folder Sub CRIARPASTA() Dim VAR As Object, NOVAPASTA Dim Nome As String Dim OS As String Nome = Worksheets(3).Range("f5").Value…
-
0
votes0
answers8
viewsNumeric value 0 (zero) is exported as empty using Alasql
I need to export to excel a data set that comes from an API, this API is external and I cannot modify it. I’m using alasql to export excel, but when the column is numerical values I’m having…
-
-1
votes1
answer1250
viewsBest way to work with XLS and XLSX files
What is the best way to work with Excel, XLS and XLSX spreadsheets in C#? I need to perform cell readings according to the column name, which is specified in the first row. Follow an example below:…
-
-1
votes2
answers5251
viewsEXCEL FUNCTIONS FOR COMPARING VALUES
I have a hidden macro with some values in several columns. In my main and only tab visible to the user, I want to compare if the value of the Macro’s J2 cell is greater than 4 , if it is greater, in…
excelasked 8 years, 6 months ago Mateus Rocha 23 -
-1
votes2
answers54
viewsWhat function to use
As a beginner in Excel, I’m having difficulties to use a function that I believe is the solution to what I want, the function (SE). The thing is, I have a sum of values that start at 54 and go to…
-
-1
votes1
answer84
viewsAre there security problems when implementing and using "add-ins" in VBA (Excel)?
Due to security problems with macros in VBA/Excel, I was wondering if the same occurs (or something similar) when adding a supplement and use it later in projects of VBA. This would impact a user…
-
-1
votes2
answers3298
viewsHow do I view VBA button properties of an excel spreadsheet?
I have a spreadsheet with buttons that hide and re-export fields according to the filled data set. When I try to see or change the properties of the controls, I can’t. VBA only shows the properties…
-
-1
votes1
answer1356
viewsHow to load an Excel table and turn it into an HTML table using Javascript?
I intend to create a button to load a xls or csv file and turn this Excel table into an HTML table, how can I do this using Javascript? Please...
-
-1
votes1
answer3141
viewsUpdate dynamic table last. VBA
I created a spreadsheet connected to my ERP via ODBC and have some dynamic tables in the same spreadsheet. I’m trying to create a macro that updates all the data, but using ActiveWorkbook.RefreshAll…
-
-1
votes1
answer685
viewsImport workbook from another worksheet to a new workbook in the current worksheet
Using the example past in Microsoft MSDN, the following error is displayed: Run-time error '9': Subscript out of range VBA code: Sub Principal() Dim PathName As String Dim Filename As String Dim…
-
-1
votes2
answers2874
viewsSeparate fixed headphones from furniture to add ninth digit
I have a spreadsheet with almost 60 thousand lines, with 3 columns: Name | Phone 1 | Phone 2 In the two speaker phones I have fixed and mobile phone numbers and for me the logic is simple: Fixed…
-
-1
votes1
answer807
viewsHow to Compare More than One Piece of Data Between Two Sheets and Sum That Data Based on a Condition
I have two spreadsheets, they have basically the same data, but they are not 100% equal. I need to take the Id(column A) of the client in worksheet1 and check in the row where it exists in…
excelasked 7 years, 7 months ago LP. Gonçalves 883 -
-1
votes2
answers902
viewsExcel form (Block fields)
I have a question about what formula I can use. I have a box with 3 options (Example: 1 , 2 , 3) and if I select the option 1 I can fill in the field 1 and are blocked options 2 and 3. If you select…
-
-1
votes2
answers2049
viewsVBA Code Adaptation to fetch photos from a folder
Good afternoon. I have a macro, which searches a spreadsheet for the name of the photo (e.g., IMG0102.JPG), searches a predefined folder for the related photo and inserts it into the cell that bears…
-
-1
votes1
answer439
viewsExcel change only part of a cell text
In an excel document I want a certain text of a cell to be automatically enumerated when I copy the entire group of cells. Example of the explanation. - What I want is to copy the whole text and…
-
-1
votes1
answer108
viewsreport filter excel
I am trying to make a report but I need a help the spreadsheet has to search by date and paste in another spreadsheet the data of that same date (example on the line that is dated today copy…
-
-1
votes1
answer546
viewsTime 0 with negative signal
I have an excel spreadsheet which I changed the date system to 1904 to be able to display negative hours. The problem is that often happens to appear values -00:00 when I subtract schedules. From…
-
-1
votes1
answer324
viewsProblem downloading a php export
Good afternoon, I have a script where generates an excel spreadsheet with information, but after the exchange of the server started to give problem, before it generated and downloaded normally but…
-
-1
votes1
answer252
viewsEXCEL. "Right" function how to set an automatic size for separate cells that exceeds the number of defined characters
I used the right function in cell "L33" but when I went to click and drag the values defined in the first cell, cell "L34" displayed not only the word 'technologies' but half the word 'software' and…
excelasked 6 years, 1 month ago Elienay Junior 527 -
-1
votes1
answer357
viewsExcel VBA Advanced Filter Problem
I made a program in VBA to calculate the cost in my company. For this I used two connections with the Oracle database. What’s strange is the fact that when I try to use the advanced filter manually,…
-
-1
votes1
answer360
viewsView excel table in html
Hello guys I’m trying to use the iframe tag for by an excel viewer. Com pdf works, but when I put a file . xlsx it downloads the file to preview ivés. Someone could help me?
-
-1
votes2
answers40
viewsDataframe using R
I am with multiple files . xls and all have the same layout. I want to leave them in a single dataframe, for example: df1 nome idade sexo Fulano 22 M df2 nome idade sexo Fulana 27 F dfJuncao nome…
-
-1
votes1
answer924
viewsVBA to fill empty cell
good morning, I have a spreadsheet in excel that I would like when I impute a date and press the macro button to paste into the next empty cell in column A, 74 times. And also copy two columns (B:C)…
-
-1
votes1
answer125
viewsformat Excel timestamp
Is there any formula in excel for formatting in the timestamp column and move to 1 column type time which is the value that interests me.…
-
-1
votes1
answer192
viewsPython Convert XLS (2003) to XLSX
Good Morning! Guys, I have a directory with several spreadsheets exported from my system in XLS format (Excel format 97 - 2003), I need to write a script to go through this directory and convert…
-
-1
votes1
answer175
viewsHow can I open Postman by excel vba?
I wonder how I can open the POSTMAN by the EXCEL VBA. I would like to instantiate the application as an object but I do not know how to do. Example: Set IE =…
-
-1
votes1
answer184
viewsHow to print only the first page
Good afternoon, I have this code on my spreadsheet. Sub Imprimir() Dim LocalPDF As String 'DEFINIR O LOCAL ONDE SERÁ SALVO O ARQUIVO LocalPDF = ThisWorkbook.Path & "\" & Range("H5") & "…
-
-1
votes1
answer1188
viewsFormula to return the date only with working days
Is there any formula I can use for the cell to return the date corresponding to the term? If I enter the date 03/01/2020 in the cell, I want another cell next to return the date with the calculation…
-
-1
votes1
answer227
viewsThe file is locked - Excel and VBA
I have an excel spreadsheet with userform to control a database that is also in excel, this database for having many accesses is shared, but today I saw that VBA does not get along very well with…
-
-1
votes1
answer116
viewsSelect python - Pandas
I am developing a python program where I import two xlsx files directly with the Pandas library, I can import them easily, but I need to create a report between these two files. How can I do?…
-
-1
votes1
answer64
viewsHow to execute formula when the cell is filled?
I want the formula HOJE to stop running when filling or pasting information into the A4 cell that is part of the data. =SE(A3="";"";HOJE()-A3)
excelasked 3 years, 11 months ago Sairo Coelho 1 -
-1
votes1
answer37
viewsWebscript VBA array specifies
all right? I’m making a web scraping to update a spreadsheet of mine in vba. But the site I want to pull this information use td and tr and do not put class or id in the syntax. For example: I am…
-
-1
votes1
answer29
viewsLines in export excel
I am exporting a listing to excel, but when I open excel it comes without the partitions. <?php require_once '../../classes/xajax.inc.php'; $db = new SqlSrv(); //$sql = "SELECT * FROM cad_pessoas…
-
-1
votes2
answers20
viewsIf cell changed, move old value to side
I’m starting to use VBA with the office package, as I still know little I’m having difficulties to get this functionality. I was trying to do something simple and I needed help to understand how it…
-
-1
votes1
answer28
viewsCapturing values with multiple conditions in excel
Below is the link to a Google Sheets file that I need your help with: https://drive.google.com/file/d/1ejSffpo56lGFTRHTmueysF3WFZOIP2dO/view?usp=sharing There are 2 spreadsheets in this file, the…
-
-1
votes1
answer102
viewsVBA to save in PDF the Excel spreadsheet with the name of two Cells
The spreadsheet I save in pdf with this code: Sub Salvar_PDF() 'Antes de executar o código é importante definir a áreade impressão ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF,…