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
-
4
votes1
answer2127
viewsHow to add Microsoft.ACE.OLEDB.12. 0 to my app’s installer . NET?
Hi, I have an app that I programmed through Visual Studio 2017 using the Microsoft.ACE.OLEDB.12.0 to consult on files Excel and return data. Now that I finished the project I had to publish. But…
-
4
votes1
answer1069
viewsHow to merge multiple Excel spreadsheets into one?
I have a set of worksheets (for example, suppose they are called file01.xls, file02.xls, file03.xls etc.), all with the same columns in the Sheet1 tab and with the other empty tabs. How do I join…
-
4
votes1
answer141
viewsBring value from another cell to the formula without being String
The formula in excel PROCV vertically search for a value in a specific table of an X column. Having said that, I have the following problem with this formula: =PROCV(J7;JUL;6;JUL!C4:C35) With this I…
excelasked 5 years, 5 months ago Marcos Henzel 797 -
4
votes1
answer608
viewsVBA - Automatically Clear Cell Information - Event Change
The script below causes when selecting the column "H11" automatically clear the column "I11". How do I make the same script erase the I12 cell when selecting the H12 cell and so following the same…
-
4
votes3
answers125
viewsHow to add one column of data based on another in excel through Pandas?
I have a spreadsheet with multiple import data. The problem is always the format as the data comes. For example, I have a column called "Imported Goods" that has values like the below: 1 X 40…
-
4
votes0
answers47
viewsHow to format a cell number in excel for hours type through Openpyxl (Python)?
Whoa, you guys are fine? So, I’m developing a Python test API that when it’s called, it has to return me an Excel file with pre-defined data. One of these data is a time variable that must be…
-
3
votes1
answer554
viewsDynamic source of graph data
I have a table in Excel, Tab_Visitas, who has the visits per day of the month. What I wanted to do was a line chart, but only with the selected date and the date before the selected one, like this:…
excelasked 10 years, 8 months ago Miguel Borges 277 -
3
votes4
answers11775
viewsDynamically set the Excel column size
I am working with the generation of spreadsheets in EXCEL, and for this I use the framework’s default api. Imports Microsoft.Office.Interop.Excel However, when I have a column with very long text,…
-
3
votes1
answer7604
viewsExcel 2007 - Buttons to Create / Remove Rows
I have an excel table with only one row (plus the header) and six columns. The entire sheet is protected except this line. At the end of the table I wanted to have a button (+) that adds a new row,…
-
3
votes1
answer11000
viewsUse the R1C1 property
I want to use the property Range.Formula R1C1 in a check copy form for automatic filling of cheque nominal. How could I use this property for this purpose? I found a code described as follows: Sub…
-
3
votes4
answers15143
viewsHow to create an Excel macro to delete duplicate lines
Have someone show an example of Macro in Excel that removes duplicate lines, but comparing all cells of the same, or selecting which compare, example para linha_atual em todas_as_linhas faça para…
-
3
votes2
answers1405
viewsString Connection excel . xls . xlsx C#
I have a connection string with excel, but it is only the . xlsx and is giving this error Serverversion = 'connExcel.Serverversion' threw an Exception of type 'System.Invalidoperationexception' I…
-
3
votes1
answer668
viewsCreate xls file and store in a folder
I have my file gerar_xls.php and is creating a file .xls and I want to keep it in a folder. What you are doing now is downloading the file. I have the following: header("Content-type:…
-
3
votes1
answer203
viewsSeparate result in different worksheets
I have a problem in which I have to take all my information (information from each cell of the spreadsheet), make them go through a condition and for each result of the condition write in a new…
-
3
votes1
answer1041
viewsSplit a string
I’m trying to make a simple code using the split, but some mistakes are occurring that I’m not able to solve.. no if with asterisk VBA informs me that the subscript this out of range.. Sub…
-
3
votes2
answers2574
viewsRead more than one. xls file in python
I posted a very similar question a few days ago, but this time, I’m trying to do something much more generic. I want to get the information from line 0 and 1. The code below is complete, and is…
-
3
votes1
answer7292
viewsGenerate random number when activating spreadsheet in Excel
I am here because I believe that only with the help of VBA I will achieve what I want to do, which is the following: I am developing a small game in Excel and I have to use random numbers, it…
-
3
votes2
answers357
viewsRestart Numbered VBA Excel Word List
I am trying to create a macro in VBA to create a word document from Excel. Right now I’m having trouble with the lists. I want the list numbering to be linked to my Header1 and Header2 Styles so…
-
3
votes1
answer1955
viewscont.if it doesn’t work in Excel
I have a column in Excel with 38 lines. Inside there are two words: Yellow and White, I want to count how many times those words have been reported. I used the following formula:…
excelasked 9 years, 10 months ago Felipe Viero Goulart 3,693 -
3
votes1
answer337
viewsForce numeric/language format to document
Where work is very common we have problems with excel macros, which generate tables and charts, depending on the language and version of Excel the client is using. How to force a language (for…
-
3
votes1
answer674
viewsFormula excel SOMASE
I put this formula in Excel and it didn’t work because? =SOMASE(E2:E158;"<=4>=10";B2:B158) I can’t put it above 4 and below 10, he only accepts one of two hypotheses... how to do?…
-
3
votes1
answer1088
viewsEXCEL Paint a certain amount of cells
I have a spreadsheet that works like a chart of Gantt, that goes from day 01 to day 31, and my doubt is simple, based on the day calculation of an order, 12 days for example, have how I make excel…
excelasked 9 years, 6 months ago Denis L. Murara 645 -
3
votes2
answers4025
viewsSplit EXCEL file
I have an excel database with 1 million emails in it, and I need to split it into 4 files of 250,000 emails each, does anyone know how I can do this with any excel function ? thank you
excelasked 9 years, 5 months ago Luana Souza 39 -
3
votes2
answers128
viewsCreate spreadsheet by adding images and changing color of lines
This method creates an Excel spreadsheet, with int and string: public function arrayToXls($input) { // BoF $ret = pack('ssssss', 0x809, 0x8, 0x0, 0x10, 0x0, 0x0); // array_values is used to ensure…
-
3
votes3
answers1827
viewsExcel - Extract only numeric fields from a selection containing text and numbers
Using Excel, I need to extract numerical data from a selection. Example: Coluna 1 123 456 Bom Ruim 789 Ótimo From the above data, I need to extract the following data: Coluna 2 123 456 789…
-
3
votes0
answers2256
viewsRegressive chronometer but when it reaches zero starts again?
I adapted a regressive timer that I found here on the net and adapted to what I want. It is to be used in a cycling race and in a time trial stage where cyclists depart every 2 minutes. It works but…
-
3
votes2
answers550
viewsLogic with date in excel
People, I am developing a spreadsheet to better control the production of the factory in which I work, I do not understand much of excel and I have a doubt that it may be simple to solve. Next, I…
-
3
votes2
answers5064
viewsHow to use the name of a cell of the Excel spreadsheet in VBA, not to indicate row and column?
How to use the name of a cell of the Excel spreadsheet in VBA, not to indicate row and column? For example, I named "Client Name" to cell B20, when I use this name in VBA to put in label (…
-
3
votes1
answer324
viewsHide results in Excel
Good afternoon, guys. I have the following problem: I have several lines and each one of them is protected with a different password for the edition, each corresponding to a company unit. I need the…
-
3
votes1
answer478
viewsFormula - receive values from one cell range to another, except empty cells
I have a range of cells containing empty cells and others not, arranged in a row and need a formula that receives these values in a column, except empty cells, below an example of what I need,…
-
3
votes0
answers380
views -
3
votes2
answers140
viewsExcel - Reports
Good morning, I have been making reports in excel in which both my client and I entered data in it. I would like your help to know how to do so so that both I and the customer have not introduced a…
-
3
votes2
answers599
viewsSpecial characters in excel spreadsheet generated in Delphi
I found on the internet many codes related to generating EXCEL spreadsheets in DELPHI. Follow the code I am using: objExcel := CreateOleObject('Excel.Application'); objExcel.Visible := True;…
-
3
votes1
answer1485
viewsCreate tabs dynamically in excel
I am doing an MVC project and I would like to know if there is any way to create dynamic tabs in Excel according to filters and export it later. Example: If the filter only comes with "School"…
-
3
votes1
answer1216
viewsSeparate Even, Odd and Equal values in Matrix by VBA (Excel)
how to make a 10x10 matrix, separate pairs and odd and equal without using Mod ?…
-
3
votes1
answer5212
viewsUse the formula "if" to calculate a certain time interval
I’m trying to create a condition but I’m having trouble, Can someone help me? if the cell number C15 is between -00:10 and 0:10 (minutes) the cell D15 should appear 0:00, otherwise the cell D15…
excelasked 8 years, 4 months ago Ricardo Piovesan 31 -
3
votes1
answer1405
viewsRunning text as code in VBA
The code below calculates the formula contained in the variable Text (String): Private Sub CalculeFormulaNoTexto() Dim Texto As String Texto = "= 90 / 3 + 7 + COS(0) + 1/7" ' A variável Texto recebe…
-
3
votes1
answer310
viewsReading of Excel file
I’m trying to use the C# to read an Excel file, but every time I run the code the last column is not stored Reading Code: //Cria conexão com a planilha OleDbConnection conexao = new…
-
3
votes2
answers1433
viewsExcel move un-duplicated values between two columns to a third
I’m having a doubt and I can’t get a plausible answer. I have a spreadsheet in which I would like to make a comparison between two columns and say to it that if there is a value that is not…
-
3
votes1
answer451
viewsHow to delete/delete repeat lines by comparing different cells?
I want to know how to delete a row that is repeat along my table. The image below can help Possible solutions: 1. Browse with Macro from file Excel1 this pass the dice to the file Excel2. Prevent it…
-
3
votes1
answer2178
viewsQuestions about executable program generation in VBA/Excel
I compiled a VBA program that interacts with an Excel spreadsheet. After having no more faults pointed out when compiling, the compilation is executed and no action is presented at the end. I did…
-
3
votes1
answer1348
viewsAuto run macros in Excel/VBA
I made several attempts to execute a macro when starting Excel as indicated in the searches I did, although these indications are very simple, in my case did not work. I followed the following…
-
3
votes1
answer361
viewsHow to programmatically format Excel Numbers in C#
I’m putting together a C#Orders report, I’m using the library Microsoft.Interop.Excel and I face a problem: It is necessary to include in this report the Request number and when presented in Excel,…
-
3
votes1
answer950
viewsErrors in using the Application.VBE object inside the VBA
In support of the solution of the question "How to inherit a VBA form?", executed the guidelines and examples of the site support.microsoft.com/en-us/kb/204330 for the purpose of dynamically…
-
3
votes0
answers62
viewsDisplay image in Excel using binary code
I have a report on Excel where the data is displayed through a stored procedure. I have a problem because when I look for the value of the image field that is blob, it displays binary code instead…
-
3
votes1
answer9329
viewsExcel - Create QR Code with 4 cell data
Good, I am trying to create a document in Excel that will fetch the entered data for example (B1, B2, B3, B4) and with this data generate a Qrcode. I don’t have any software yet that creates Qrcode.…
-
3
votes1
answer1312
viewsSelect an option that is only possible through mouse click with vba
I’m trying to develop a script with vba, no excel, to facilitate a routine we have at work, which inserts about 9,000 data into the internal system. Currently we manually enter this data. This data…
-
3
votes0
answers137
viewsUpload excel (.xlsx) with jsp
I am developing an application to submit Excel files to an application. However if I try to submit a file .txt,works properly if I send a file .xlsx the file copied to the server directory appears…
-
3
votes1
answer347
viewsSelect column with Excel *** value
Good morning friends! I need some help. I am making a "Select" of an Excel spreadsheet in VB.Net to import the data in the database but a column is not bringing the data correctly. This column has…
-
3
votes1
answer384
viewsMedium function does not work
Hello, I created several random numbers with ALEATÓRIOENTRE() and I awarded them with the CONCAT() I copied these values and pasted them in another part of the spreadsheet. I was trying to media…
excelasked 8 years, 4 months ago mrlucasrib 641