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
-
29
votes1
answer22467
viewsMacro to access site with login
I run a daily routine of accessing the Serasa site and make the CNPJ query. I need to develop a macro to access this Serasa site, log in and then query, and then play the information in Excel.…
-
26
votes5
answers7637
viewsIs Excel a programming language?
No, I’m not asking for an opinion. I’m asking this question here because today I found this unlikely question: HTML is a programming language? And, I confess, I voted in favour of the second comment…
-
13
votes1
answer1673
viewsHow to do a text break in Excel programmatically with a C check #
I am using the Microsoft.Office.Interop.Excel to create an Excel report from a txt file. Everything works perfect, but sometimes some columns become extremely large and when we need to print, it is…
-
12
votes7
answers8546
viewsHow to implement a linear regression algorithm?
I need to implement a linear regression algorithm. Preferably that gives equal or near results to the function TENDENCY (or TREND) excel. I’ve found a lot of material that tries to explain the whole…
-
12
votes2
answers1686
viewsVBA/Excel Combobox : Disable Auto-Complete
I’m typing a text that’s in a Combobox of VBA/Excel, but the initial part of the text matches another already included in the list, besides completing it automatically (which I do not want), it…
-
11
votes3
answers3977
viewsOrganize data in Excel to open as table in R?
I have a file with 50 observations and 3 variables in Excel file (.xlsx), and turned to .csv. I used banco1<- read.csv("teste1.csv") to create the table in R, however my 3 variables appear in the…
-
11
votes3
answers10308
viewsHow to calculate direct treasure custody fee
Consider the following investment: Capital inicial (C) = 1000,00 reais Juros (J) = 12% ao ano Período (n) = 8 anos Taxa de Custódia (TC) = 3% ao ano The custody fee (TC) is a fee charged annually on…
-
11
votes2
answers2937
viewsHow to compare intervals?
I believe that it is not difficult to do this, but as I could not do despite having tried to wonder if someone could help me. In an Excel spreadsheet I have random numbers from A1 to A6 and I would…
excelasked 9 years, 2 months ago Tatiana Andrade 113 -
10
votes1
answer15267
viewsHow to generate a full value in Portuguese in MS Office Excel?
In an Excel spreadsheet, having a cell with a numerical value, how to calculate its value in full? For example, in the cell A1 have the value R$ 587,32. I need a function that passes the cell as…
-
10
votes1
answer17922
viewsMacro VBA search information on site
I need to search information on a real estate site and bring them to excel. I did the macro below: Sub zap() Set ie = CreateObject("InternetExplorer.Application") With ie .Navigate…
-
10
votes2
answers160740
viewsFormula to calculate numerical ranges in Excel
I need some help to make a formula in Excel. =SE(C11<=6;"G4";SE(6<C11<=10;"G6";SE(10<C11<=16;"G10"))) What I want to do is: If the cell C11 is less than or equal to 6 write G4. If the…
excelasked 10 years, 5 months ago ChrisAdler 1 -
9
votes1
answer877
views -
8
votes4
answers19992
viewsHow to transport data from R to excel?
I calculated a series of data in R and would like to know which command I should use to transport them to an excel spreadsheet.
-
8
votes3
answers34320
viewsHow to import excel data pro R?
I have a table in excel that I need to import to R. I could do it quietly with the function read.csv when the table in question was online, but I’m having difficulty importing the file directly from…
-
8
votes2
answers2097
viewsMysql connection failed via VBA
I am trying to connect to a Mysql database via Excel VBA, but returns an error stating catastrophic failure. I made a test by putting the wrong password, or the name of the wrong database, and it…
-
8
votes1
answer399
viewsHow to export a Datatable to Excel without formatting the information?
I need to export a number to Excel, but it always formats in an inappropriate way. Expected form: -8,0902322222234 Received: -809.023.222.222.234 The data from the Datatable are typed with string.…
-
8
votes2
answers9843
viewsExport to excel via javascript, put name in file
Guys I use the very simple routine below to export to excel, it works cool, but I would like to give a name to the file when exporting, but I didn’t want to use plugins or huge functions just add a…
-
7
votes1
answer1225
viewsVBA - Backpack problem
In excel I have the following table | Produtos | Preço | | Produto A | 100 | | Produto B | 250 | | Produto C | 200 | | Produto D | 800 | | Produto E | 560 | | Produto F | 970 | ... And I would like…
-
7
votes3
answers7634
viewsError importing CSV into phpMyAdmin
I need to import a file .csv for phpMyAdmin, but the special characters do not appear, nor the text that follows them. What may be the problem?…
-
7
votes1
answer657
viewsSave files from a Datagridview
I would like to know how to get all the content that was passed to a Datagridview and save it in an Excel file. So far I have it: private void btnDiretorio_Click(object sender, EventArgs e) {…
-
7
votes2
answers1310
viewsIs there any way to transfer Mysql data directly to an Excel table?
Is there any way to transfer all data from the database to a table in Excel? It can be with any language.
-
7
votes1
answer1438
viewsGenerate header when exporting data to excel
I did an export routine for the excel, using StreamWriter, but it causes me a problem. I can’t get the name of the columns that come in select. To make the header, I had to put it in the hand. This…
-
7
votes1
answer2081
views -
6
votes2
answers5503
viewsExport from html table to excel
I am trying to export an html table to an Excel file. This jquery plugin works almost perfectly for me. My problem is with accentuation, which comes to excel with strange characters. Some tip on how…
-
6
votes1
answer5017
viewsExport formatted R to Excel data
Suppose a data.frame like this: tabela <- structure(list(vendedor = structure(1:4, .Label = c("A", "B", "C", "D"), class = "factor"), Total = c(3300, 440, 1020, 200)), .Names = c("vendedor",…
-
6
votes1
answer1345
viewsJoin data to Direct Mail | Parent and child table
I have a spreadsheet with data of students. For each discipline of the same student there is a specific line. I would like to do a direct mail with only one email per student, but that imports the…
-
6
votes2
answers1475
viewsHow to access a value that was placed via Javascript from a site via VBA?
I’m trying to access the values that appear on the site: http://www2.bmf.com.br/pages/portal/bmfbovespa/boletim1/BoletimOnline1.asp?caminho=&pagetype=pop&Acao=BUSCA&cboMercadoria=DI1 I…
-
6
votes2
answers2501
viewsDelete a macro using another
How to program one macro to delete another? Would it be something like, when, I need to call? Ex.: Sub callmacro() Call macro1 End sub And better yet, if I want to program it to delete itself? Ex.:…
-
6
votes1
answer23089
viewsHow to pass excel data to Mysql?
First, I have a newsletter system that I modified for email marketing, it’s all in PHP (obvious) and first, I add the emails manually through a part of the site add.php but there are over 3000…
-
6
votes1
answer270
viewsVisual Basic Excel - Delete an array name
I’m here with some problems, I never touched Visual Basic and I was wondering if it would help me to make a list I have in Excel faster (Through Visual Basic Excel). It’s very simple, I just want to…
-
6
votes1
answer462
viewsVBA/Excel - Subroutines stop while typing
I am working on a spreadsheet where the user has to type a given text into a cell at a certain time. I want to put a countdown side, so he can check how much time is left. However, when I start…
-
6
votes1
answer901
viewsVBA Download pdf
I am developing a macro in excel that through a list of id and passwords in excel logs into a website and tries to download a pdf. I can log into the site and navigate to the button that generates…
-
6
votes1
answer22028
viewsAdd photo in excel spreadsheet from local folder
I have a spreadsheet in Excel with a list of people. For each person I have a code. In a local folder I have photos of these people and the file name of the photos is the code of the person. Do you…
-
6
votes1
answer1200
viewsFind column and position cursor in it
I have a spreadsheet that contains: COLUNA A1 CABECALHO (PRODUTOS) COLUNAS B1 A BK1 COM DATAS I will read a database ordered by product and date and have which automatically fill in the spreadsheet…
-
6
votes2
answers242
viewsGet only given last month using R
I need to extract the last monthly values from dataframe column 2 ntnb45. Is there any direct way to do this in R? library(GetTDData) ntnb <- download.TD.data('NTN-B') ntnb45 <-…
-
6
votes3
answers1307
viewsCount elements between two quantities
I’m creating a Dashboard to a religious organization, which will include the age group of its members among other data. The ages of registration and promotion among their religious education classes…
-
6
votes2
answers915
viewsCreate filter based excel table
Hello, I have a table in Excel of 3 columns: Pessoa | ID | País João | 1 | Flórida Maria | 2 | Flórida Ana | 3 | Miami Ana | 4 | Califórnia Pedro | 5 | Califórnia João | 6 | Flórida etc.... I would…
-
6
votes2
answers670
viewsAn Exception of type 'System.Outofmemoryexception' occurred in mscorlib.dll but was not handled in user code Asp.net
I’m having a hard time solving this mistake. My goal is to collect data from an Excel file and store it in c#variables, which in turn will be inserted into SQL Server 2012. Reading is done line by…
-
6
votes4
answers7295
viewsHow to generate a spreadsheet from another using VBA
I have the worksheet below with the following columns: I would like to generate a second spreadsheet based on the above information, following the following conditions: a) If categoria ==…
-
6
votes2
answers2083
viewsBlock cell filled with VBA
We are setting up a routine where when filling a cell (C1, for example), automatically is filled date (A1) and time (B1) in the spreadsheet. Only right after the auto-fill I need the 2 cells to be…
-
6
votes2
answers419
viewsExport graphs from an Excel spreadsheet without Interop
I need to read and write data from Excel spreadsheets, and export some charts using C#. But I cannot use the interoperability library (Microsoft.Office.Interop) for that reason. How can I do? Does…
-
6
votes1
answer6469
viewsMacro email range + signature
Good morning. I need help in a macro for sending emails in Outlook 2007. I have a macro that selects a certain range of cells (all right and all down from a referenced cell) and pastes in an email,…
-
5
votes2
answers2591
viewsHow to set the width of columns in a generated Excel spreadsheet as HTML?
I need to convert an HTML table and generate the file in excel. How to set column width in excel? I create the HTML file using PHP and export using : header ("Expires: Mon, 26 Jul 1997 05:00:00…
-
5
votes1
answer1029
viewsSave automatically generated excel in ASP MVC application
I am generating Excel files in my application using Epplus. Now there is a need to automatically store these files in a folder, regardless of whether the user downloads them or not, in order to make…
-
5
votes1
answer1048
viewsExcel How to find the current cell address
I have a column on my chart where I place the arrival date of a product. I would like to create a conditional formatting (put the cell in red) when there were 15 days or less for the product to…
-
5
votes1
answer9035
viewsName the tab as the contents of a cell in Excel
How do I put the tab name equal to the contents of a cell? For example, if cell content A1 for 01, the name of the guide is 01 also.
-
5
votes1
answer957
viewsMerge Excel cells via Delphi code
I am updating an old system made in Delphi that uses a class to create an Excel file without the need to use OLE objects or have Excel installed. Class works normally using the code that is just…
-
5
votes1
answer4116
viewsuse excel spreadsheet to fill web form
I have a spreadsheet in Excel, it was generated from a form of a system and then some data were selected. After that I have to put this data in another web form, this form is in another system other…
-
5
votes3
answers257
viewsError in formula with OR
Some reason this doesn’t work? I intend that he counts how many situations exist within one or another criterion. Both this formula: =CONTAR.SE.S(E:E;">120";E:E;"<139" OU…
excelasked 9 years, 6 months ago Ricardo Simoes 83 -
5
votes1
answer1654
viewsmacro to copy and paste
I have data in column "M", which are entered automatically, on an average of 70 rows per month, only it has empty cell ranges (the 12 months of the year are in column "M"). So I wanted to copy this…