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
-
2
votes2
answers547
viewsColumn problems in Python XLRD
I am a beginner in Python and am trying to make a script to sum all the values of an excel column and write the sum value in the spreadsheet. I’m using the Python xlrd and xlwt packages. The code…
-
2
votes1
answer4338
viewsCommand for Fill Effect in Excel VBA
Friends, I’m using the tip, described in the "Excel Guru" script in Creating Interactive Maps in Excel: Sub ColorirMapa() Dim Microareas As Range Dim Celula As String For Each Microareas In Range…
-
2
votes1
answer95
viewsReturns Excel in C# List is returning null
This code reads a file Excel and plays a list, the problem that is occurring is it is returning null, like there’s nothing in the Excel, but the column names are correct: string PathConn =…
-
2
votes2
answers4561
viewsExport data from an array to a table using VBA
In the Sheet1 i have a table only with the Header of each column but empty values, I run a VBA that creates an Array that has the same number of columns of the table. Is there any way to export all…
-
2
votes1
answer962
viewsChoose a file in a folder and save it as text automatically
I want to make a VBA code that opens a specific spreadsheet and save it as tabulated text. I am with this code formulated Sub gerararquivotxt() Dim intChoice As Integer Dim strPath As string…
-
2
votes1
answer61
viewsProblem using common Controls 32 bit in 64 bit
I’m having a problem with common Controls in excel 64-bit(checkbox for example), are necessary to run a code in VBA but in version 64 bit I cannot select them. NOTE: common Controls were…
-
2
votes1
answer1822
viewsConcatenate address in VBA Excel Range Object
I need to concatenate an address in the Excel Range Object and I’m not getting it. The value is an Integer variable. Follow the line of code: Range("O10").Formula = "=SUM(O12:O" & "valor)"…
-
2
votes0
answers159
viewsHow to convert the tags of a . ris file into table variables?
I have a file . ris with data from researchers and would like to convert the labels of this files into labels of columns excel variables.
-
2
votes1
answer647
viewsRead and write xlsm file in php
I have a very big hand problem: I have an xlsm file with macros to read, write and finally download. It is a 4 MB file with inline formatting and images. I’ve been using Phpexcel only I haven’t been…
-
2
votes2
answers3272
viewsHow to find information from another spreadsheet in Excel
I have a system that generates spreadsheets . xls daily, example "matriz_070120150900.xls". Where the numbers represent the day and time 07/01/2015 at 09:00. I created a spreadsheet for managing…
excelasked 9 years, 11 months ago Andre Oliveira 21 -
2
votes2
answers501
viewsError canceling file import in Excel
I’m building a Macro for importing a file in Excel. At some point, when the file location is requested, in case the Worksheet cancel import option, the following error message is returned: Excel…
-
2
votes3
answers888
viewsRange in Excel VBA
I have the following code snippet: ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;C:\Users\Contoso\Desktop\ArquivosDoContoso.csv", Destination:=Range _ ("$A$1")) In part Destination:=Range _…
-
2
votes1
answer1315
viewsError while exporting to Excel (Corrupted file)
I am making an application to export the result of a query sql for Excel. After the file created the time I will open it gives a corrupt file error. SaveFileDialog sfd = new SaveFileDialog();…
-
2
votes1
answer196
viewsError placing other parameters in Shell() function
I’m trying to use the function Shell() of Vba in the office 2010, but is returning me the following error: Build error Erra Esperado:= My code is like this: Dim programa As String: programa =…
-
2
votes0
answers765
viewsAccess websites and extract contents to excel via VBA
Hello, I’m wanting to learn how to move around websites and extract images values, or insert passwords and logins via VBA, however I do not know any of this. I would like to know if it is necessary…
-
2
votes1
answer716
viewsProblem with encoding in Excel file reader for Java
I have a relatively "common" problem. I have a program in Java that imports an Excel spreadsheet and one of the column fields has words with accents, cedilhas, etc. When reading the variable, it is…
-
2
votes1
answer241
viewsHow to export Reportviewer to Excel while maintaining field types?
I have a report in Viewreport in VS2010 and when I export to Excel, the default VS button does not maintain the format of the fields. This way I cannot use Excel functions as SUM for example because…
-
2
votes1
answer472
viewsExcel Convert Rows to Columns
I have a spreadsheet with several lines this way NOME: | EDSON SOBRENOME: | CARLOS TELEFONE: | 1299232322 NOME: | TESTE SOBRENOME: | AMANDEU TELEFONE: | 1499252322 NOME: | JOSE SOBRENOME: | PASTOR…
excelasked 9 years, 3 months ago ForeverSJC 23 -
2
votes1
answer952
viewsHow to calculate the value of one cell only what exceeds the other
What formula would you use to calculate a value above a certain number? Example: Area to calculate above 2.00M². The multiplication value was 2.75. How do I record in the cell only 0.75 - and in the…
-
2
votes1
answer504
viewsADO Command / Parameter in Excel (VBA)
Hello, I am developing a code in VBA in Excel 2010 in conjunction with a database Acces 2010. In this code, I use ADO Command to manipulate the data in the database, but I am receiving an error…
-
2
votes3
answers3217
viewsHow to read an excel file in c# and save the data in strings?
Guys, I need to make a c# console application that reads an Excel and saves each data in a string!! I’ve tried several libraries and nothing has worked out
-
2
votes3
answers173
viewsFunction =VLOOKUP(MAX($B$5:$B$11);$A$5:$A$11;1;0) Excel 2010
I’m using the function: =VLOOKUP(MAX($B$5:$B$11);$A$5:$A$11;1;0) in cell B23 in Excel 2010. Result: #N/A! Can someone help me fix my formula? Thank you very much, Silvio.…
-
2
votes1
answer8849
viewsHow to send only a spreadsheet by email in VBA and not the whole file using the code below
Option Compare Database Option Explicit Public Const C_Title As String = "ef3.Cinco" 'Metodos Public Sub SendMail(obj As MailClass) 'Nome da classe... Dim appOutLook As Outlook.Application…
-
2
votes1
answer960
viewsIs it possible to use a "SOMARPRODUTO" to calculate values in various spreadsheets?
I have some tables with store names and I would like to know the sums of values of these stores that are in different spreadsheets. Is it possible to do this using the "SOMARPRODUTO" or "SOMASE"? I…
-
2
votes1
answer1121
viewsCan a macro create another macro?
I have a spreadsheet of analysts, but when you change the analyst or enter a new one I need to copy everything the same as the other analysts just by changing his name. I wanted to know if there is…
-
2
votes1
answer427
viewsGet value of steps
I wanted to know what(s) a(s) formula(s) to get a value from a predefined table. For example, consider that in a spreadsheet I have the following table: | A | B | |-----|------| | 245 | 4,5% | | 256…
excelasked 8 years, 11 months ago João Filipe Rocha 53 -
2
votes0
answers524
viewsFind values with text part
I have a problem, I have a problem spreadsheet. Currently I can do the search by name, but I wanted to type only part of the name, for example, instead of typing "Raquel", type "Ra" he already bring…
-
2
votes1
answer403
views -
2
votes3
answers3061
viewsHow to use a Command Button inserted in the Spreadsheet in the VBA code?
I have a command button that I inserted in a spreadsheet, and wanted to know which function I have to assign in vba code, to know when a user clicks on it !
-
2
votes1
answer630
views -
2
votes0
answers865
viewsWeb Query at Login Site
I need to access a site to make an import of data from the web, but this site needs login and whenever I leave the spreadsheet and enter again I have to edit the query and connect again! The idea…
-
2
votes1
answer1118
viewsVBA Excel - Change Cell between True and False
I’m making a code but since I’m still very green in the VBA I don’t know how to make it work. It’s very simple, I want to press a cell and it will change a Boolean between True and False. When I…
-
2
votes1
answer2502
viewsHow to use Laravel Excel Library
I have a .csv where I need to import your data into the database. I am using an Laravel library to import it. What is this one: https://github.com/Maatwebsite/Laravel-Excel In the code I’m doing…
-
2
votes2
answers85
viewsCalculate date with Javascript or otherwise, even in excel?
How to arrive at an end date from a start date multiplying by N weeks, not taking into account the last week of the year. I can calculate the dates, but I can’t cash the last week.
-
2
votes2
answers236
viewsFunction SE, SUM or what?
I’m trying to put together a formula, but I know less than the basics about Excel. I made a spreadsheet for sales control, and I put the cakes, sweets, salty, in columns and until then everything…
-
2
votes1
answer255
viewsError opening exported excel file in PHP
I use the following code: <html xmlns="http://www.w3.org/1999/xhtml" lang="pt-br" xml:lang="pt-br"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible"…
-
2
votes3
answers1164
viewsCalculate Value Present in Javascript
I need to calculate the present value equivalent to Excel formula, I have the following data: VP(2,5%;48;-2052,50) which in excel returns me the value of 57,000.00 rounding down. Can anyone help do…
-
2
votes1
answer469
viewsHow to read an excel file in a console application in c#?
Guys, I’m trying to read a data from an excel table in c#,my code is like this: string resp; string rota= "D:/Users/e608871/documents/visual studio 2010/Projects/CEMIGID/CEMIGID/CEMIGID.xlsx"; var…
-
2
votes1
answer667
views"Trace" no (VBA/Excel), how do I get the name of a subroutine?
How do I take the name of a subroutine (VBA/Excel) within itself to use in a code of type "Trace"? (see basic code in block UPDATE after the example code) The idea is to use something like…
-
2
votes2
answers784
viewsPhpexcel generates broken spreadsheet
I’m using the Phpexcel class to export a BD table. But I’m having trouble downloading the spreadsheet. To test, enter values manually without making any select in the BD. However when it generates…
-
2
votes1
answer264
viewsHow to add value of one conditioned cell to the value of another?
I’m trying to do this sum in excel. I have the products with prices and kits that they participate in, but I don’t know how to calculate the total value for each kit automatically. I would like to…
-
2
votes2
answers363
viewsError '15.0' is not a Valid floating point value when saving . xls
While trying to save a file. xls I am having the following error: '15.0' is not a Valid floating point value I’m trying to save like this: var HCalc : THojaCalc; vArquivo : String; vArquivo :=…
-
2
votes0
answers479
viewsFormat excel cells via Behind code
I have a routine that generates a spreadsheet in excel, coming from an Oracle database. What happens is that in BD I have values like this: 3456.90 or 1900.00 When these values arrive in the…
-
2
votes1
answer743
viewsHyperlink customization in excel
Does anyone know if there is a way that I can create a hyperlink in an excel cell where the value specified in this cell is passed to the id value of a URL? Example: Cell with value: 100531, when…
-
2
votes1
answer4284
viewsCopy a range of Excel cells to an "image" object by VBA
I need to copy a track from an Excel spreadsheet that contains a graphic scheme made with borders around some cells, with some background colors and text, and view this scheme in a VBA "image"…
-
2
votes1
answer4840
viewsCan you take the button to close forms in VBA/Excel?
I want to take the close button of some forms in VBA/ Excel. For example, I am customizing the presentation of some messages to differentiate from VBA options that are unattractive. In addition to…
-
2
votes1
answer972
viewsSkip column to each N counted rows
I need help with vba. When inserting values using Line counter, I want to change column, every N number of rows. E.g.: every 100 rows counted and automatically inserted values, the column is…
-
2
votes1
answer556
viewsChange lag and height of Excel cell using xlwt
I need to change the height and width of the Excel cell I’m using the library xlwt. I can’t find any references, someone can help me?
-
2
votes1
answer443
viewsTurn multiple columns into one
Hello, I do not program VBA and I am not able to make a code that did the following: |A |B |C | ---------- |1 |6 |11| |2 |7 |12| |3 |8 |13| |4 |9 |14| |5 |10|15| My table has several columns like…
-
2
votes1
answer75
viewsReduce code that refers to the same object?
Here the code, would you have any way to reduce it? (Just for learning reasons) worksheet.Row(1).Style.Font.FontColor = ClosedXML.Excel.XLColor.White; worksheet.Row(1).Style.Font.Bold = true;…