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
votes0
answers29
viewsPossible lock in file creation
Hello folks I am testing a java system that generates forms in excel but on the server it is it works smoothly generates the report but when I share the folder and try to access from elsewhere…
-
1
votes1
answer774
viewsSpecific Treatment for Groups of Objects inserted in the VBA Toolbox (Excel)
Due to repetitive actions with groups of objects that I create to work as if they were a single object, I grouped some of these objects (right-clicking and selecting group...), and dragged into the…
-
1
votes1
answer1060
viewsPython - "Error: Indexerror: list index out of range"
I cannot find the cause of the error. The program runs well, displays all rows in the table, however, this error message appears. import re import xlrd wb = xlrd.open_workbook('exemplo.xls',…
-
1
votes1
answer2369
viewsRead excel information in matrix form with python
I’m using Python 2.7 to read values from an Excel document. When I have only one row of values with respective header I can read, doing from openpyxl import Workbook from openpyxl import…
-
1
votes1
answer242
viewsLaravelexcel is converting the header values of an excel sheet. How to disable this?
I am using the Laravelexcel library to import data from an excel to a database. To get the header data from my spreadsheet, I do the following: Excel::load('file.xls', function($reader) {…
-
1
votes1
answer880
viewsGeneration of Excel in classic SP generating blank sheet
I have a testeexcel.Asp file for excel generation: <%@ Language=VBScript %> <% Response.AddHeader "Content-Disposition", "attachment; filename=excelTest.xls" Response.ContentType =…
-
1
votes0
answers74
viewsNeed to Update a Pivot Table in an Excel Web Access
I have a Sharepoint application that uses a graphical element of a Pivot Table in an Excel Web Access (Web Part). The point is that I can’t get a very viable way to update the data, I have tried the…
-
1
votes1
answer573
viewsMacro Excel - Save graphic image export to directory and import to form
I updated my Office version for 2016 and some macros stopped working properly. The routine when executed in isolation works properly, but when it enters a process it stops working. The macro in…
-
1
votes0
answers317
viewsProblem when exporting data to Excel
I have a problem when exporting the data to Excel, the number fields of the residence and misinterpreted by EXCEL Example: if the client puts in the Number field of the residence 100 A, goes normal,…
-
1
votes1
answer5445
viewsExport a datamatrix from Matlab to excel
I have a file with several matrices, as described: Name Value lat <162x168 single> lon <162x168 single> obsData <162x168x4929 double> time <5844x3 double> v6Data…
-
1
votes0
answers599
viewsSend Excel macro message to Skype for Bussiness
I have a code that sends messages via lync but the system was migrated to Skype for Bussiness. Could someone help me as I change the code to send. When trying to execute macro it presents the error…
-
1
votes4
answers1444
viewsExcel transpose row to column and preserves columns and replicate them in row
Hello, Next, I have a CSV as follows: A;B;C;D;1;2;3;4;5 E;F;G;H;6;7;8;9;10 The columns of letters have a regular structure, whereas the columns of numbers do not but you could blow them up and put…
-
1
votes1
answer193
viewsChange Destination of a File Shortcut with VBA
I am changing the name of several worksheets at the same time, but some of them have shortcuts, and in the middle of the change I want the shortcuts to follow this change. Sub changeTargetPath() Set…
-
1
votes1
answer8493
viewsGenerate Excel in SQL SERVER
Good afternoon. I need to generate an excel file by SQL SERVER. And I need to specify the data type of the cells in that file. For example, in the value cells, set the data type to "R$" for example.…
-
1
votes0
answers510
viewsExcel with more than 300 thousand lines
Good evening, I have a problem with Excel. The spreadsheet has more than 300 thousand lines and when I run the application with 30 thousand lines I have no problem. The error only happens with files…
-
1
votes2
answers1752
views -
1
votes2
answers480
viewsDeleting lines only if any cell in the worksheet is empty (using a script)
I have a spreadsheet from Calc (libreoffice)/Excel (actually it’s a text file that I opened as a spreadsheet for easy viewing) that contains some blank cells (not the entire line): I would like it…
-
1
votes2
answers1586
viewsApply conditional formatting individually to each sheet line
I have a spreadsheet with dates and cities. I need to highlight (paint of some color) the cities that are repeated on the same date I can apply conditional formatting for this, but doing one line at…
-
1
votes1
answer4844
viewsHow to change the icon of the Excel document
I want to change the icon of the excel document, to have another face and look like an executable, or something like that, can help me?
-
1
votes1
answer51
viewsExcel SES returning #N/D
I’m creating a check to see if the value of heaviness this between:…
-
1
votes1
answer1678
viewsReturn all values of a matrix with conditions
I’m trying to get a list of products from 2 values in excel. Vi in this tutorial I can make a formula as follows:…
excelasked 8 years ago mrlucasrib 641 -
1
votes2
answers899
viewsApache POI - Error opening file generated in MS Excel
Hello, I’m running some tests with Apache POI, version 3.15, for reporting purposes .xlsx, using the example code below, only to generate a file: package exemplousoapachepoi; import java.io.*;…
-
1
votes0
answers146
viewsMultiple Intel Control Tables
I need to assemble a control table of many other tables, it is basically a multiple index control that informs the position of these data tables. Editing: after several attempts even using SQL…
-
1
votes2
answers11636
viewsLine breaking in Excel (2013) via formula
How to break line in formula in Excel 2013 (above)? I used to do it this way: ="linha1"&CARACT(13)&CARACT(10)&"linha2" Current result: linha1linha2 Expected result: linha1 linha2…
-
1
votes2
answers125
viewsEXCEL - ELEGANT FORMULAS
Hello, I need help to create a more elegant formula than the one I present below: =IF(OR(AND(C11>=3302000;C11<=3303999);AND(C11>=3602000;C11<=3603999));…
-
1
votes1
answer41
viewsExcel automation
I need some way to automate a recurring work in my company: I automatically want to take tables generated in Excel, extract information from it is write in a new table. Since new tables will always…
-
1
votes0
answers212
viewsFill a Chart chart with excel data
I’m creating a Dashboard based on an excel spreadsheet, I was able to create the charts using Chart.js but I don’t know a way to get the data to be taken from the spreadsheet, anyone know a way to…
-
1
votes1
answer42
viewsDoes Excel include columns alone from a range?
Hello, I’m new here, but I have a little problem in excel. I need to make a table that includes columns with a number from the name. In the base table the user will fill in the name of the person…
excelasked 7 years, 4 months ago jessica_drika 11 -
1
votes0
answers56
viewsRotation parameter in Jasper or iReport does not work when exporting to ODS format
Hello! My code: <staticText> <reportElement mode="Opaque" x="282" y="0" width="59" height="82" backcolor="#C4C4C4" uuid="8c5029ee-1b1d-41e8-a82f-ef2f879009c0"/> <box> <topPen…
-
1
votes0
answers57
viewscapture excel formula with php
I need to capture the formula behind the generation of data from an excel with php, but in all my imports I could only capture the value of the field, how to proceed?
-
1
votes1
answer1369
viewsFill the formula horizontally but increment the cell references vertically
I need to fill a table with horizontal reference to values that are vertical from another table In the horizontal table I am doing the following ='Tab 3x3'!G10 Only when I drag it to the side it…
-
1
votes1
answer604
viewsPROCV Excel - Use of connections
Connections with other worksheets can be used in a PROCV ? Ex: I added a connection to another worksheet I use. There are columns. I can apply a PROCV or some other formula to consume data ?…
excelasked 7 years, 2 months ago Kennedy Mota 13 -
1
votes2
answers13773
viewsSQL query in VBA Excel
good morning! First I would like to say that I understand almost nothing of Visual Basic and that all I have learned so far is in the race on forums. So if this is too simple to resolve, forgive me.…
-
1
votes0
answers45
viewsNormalize database (unpivot columns per month)
Good night, An Excel table with PERVASIVE SQL connection with one column per month, that is, 12 columns. In order to better work the data, I need to transform the 12 columns into only 2: - a first…
-
1
votes1
answer535
viewsProblems reading all lines of an Excel with OLEDB and C#
I am developing a program to import spreadsheets Excel with language C#, using the component OLEDB, when importing a spreadsheet with 100547 lines the program can only read 54046. Follow the source…
-
1
votes0
answers62
viewsIs it possible to create columns with formula? Excel
Good afternoon. I wonder if it is possible to create a column with function/formula (when we use the = symbol)? In the same way that we use in many functions, type of =SE, =CONT.SE, =PROCV ... If…
-
1
votes1
answer345
viewsCheck exact sum in a cell from a range
I have a range in Excel with N values. I also have a cell with a value x. It is possible without using vba, that I know exactly which cells are in this range that summed, result in the value of my…
excelasked 7 years, 1 month ago Lucas Augusto 159 -
1
votes1
answer2146
viewsExport SQL query data to Excel
Good afternoon, everyone. I created a database to control the receipt and delivery of cards. The inclusion of the data is done through a form in excel. This form also has the option of consulting…
-
1
votes1
answer922
viewsSave query results to an array
good afternoon! I need to get the results of this query: sql = "SELECT controle.ID FROM controle WHERE BP = '" & controlectform.nmbpbox.Value & "';" And save to an array. Later I’ll do a for…
-
1
votes0
answers43
viewsExcel is crashing when using xlwings
I’m using python with excel through the xlwings package. The problem is that excel stops working whenever I try to import a function in the xlwings tab. I already restarted the pc, but the problem…
-
1
votes1
answer2823
viewsVBA: Putting a space before or after uppercase letters in a given text
I have a string of texts that represent customer names, but which are without the proper spacing between each word/name (for example: Carlosalbertogomes). However the words can be differentiated…
-
1
votes1
answer190
viewsWrite dates (month/year) between two dates
Hello, I have two dates: Initial Before Jan-11 Oct-10 Feb-11 Sep-10 I would like to know how I can have a macro that writes the date between them adding these dates in two new lines and look in the…
-
1
votes1
answer153
viewsJava - Import Excel with combo and checkbox
I need to import an excel spreadsheet using java. Only the spreadsheet has selection values like checkbox lists and combos. As in the example below: Someone has an example of java code that can…
-
1
votes1
answer86
views -
1
votes2
answers792
viewsUSERFORM: I can’t remove items from my Listbox (Error 80004005)
I have a Listbox in a Userform that I "reconstruct" based on a Textbox that I use as a filter. The idea is to bring all items to the list with Rowsource and remove all items that do not contain…
-
1
votes1
answer6730
viewsExcel validation list - runtime error 1004 - Application definition or object definition error
Here’s how it works: I have an array that contains the items for a drop-down list in excel. The code just below creates drop-down lists on cells D5 through D108 on 12 month vector tabs. The expense…
-
1
votes1
answer9195
viewsFormatting to change Color and Status depending on another cell’s Conditional
VALOR= A/B 0 1 PERIGOSO 2 3 POBRE IA= A (400)/ 3 4 QUESTIONÁVEL 70 5 6 CONFIÁVEL 5,71 7 8 BOM > 9 EXCELENTE I want to automate a spreadsheet to get the result of the division that would…
-
1
votes1
answer1326
viewsExcel - Tables - Identifying the Next Row
good afternoon. This is my first question here. I thank those who can guide me. I made a spreadsheet with some tables (tab "Home page", "Format as table"). Then, I made a VBA to clean this table and…
-
1
votes1
answer679
viewsCopy columns from matching rows
I have a spreadsheet containing 100 rows with country names and 12 columns (months of the year) containing values. My need is to compose a macro that: sweep the columns and copy to another…
-
1
votes1
answer2090
viewsEdit data from a Dropdown List in Excel
I have a list of items in a dropdown in excel. These values must be selected by the user and from there, edit it as requested. However, I don’t know how to edit these dropdown values. Can anyone…