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
answers5617
viewsExcel VBA delete Listbox item
I’m having a hard time deleting an item from a listbox. The code works like this: will have the listbox with the list, and when the user wants to delete some item, he clicks on a button that opens…
-
0
votes1
answer45
viewsVisualization accompaniment (pop up)
Hello, I have a question about HTML, I need to control how many times a pop up is opened, it is programmed to open every time a computer starts. I need to throw this data to an excel (due to the…
-
0
votes2
answers1366
viewsGenerate an excel file from a data grid C#
I am trying to generate an excel file from a datagrid, and this is generating the following error: An unhandled Exception of type 'System.Invalidcastexception' occurred in Eletronictaxnotes.exe…
-
0
votes0
answers998
viewsTake data from excel spreadsheet and insert into SQL SERVER database
I want to know if you have how to take the records of a spreadsheet and play for an SQL-SERVER table, there is this possibility ?
-
0
votes2
answers72
viewsExcel Formula for formatting tables
Is there a formula for chaining the colors of a table? I don’t want "normal" (e.g. red|white|red). What I want is whenever the name of a given cell is equal, then the background is color A, when the…
-
0
votes1
answer245
viewsError while generating file
I have a method that generates a file that method is generating the file in fact, There I have another method within my service that returns the file to the download and to that return a List until…
-
0
votes0
answers587
viewsError opening the generated excel in php warning that this corrupted
I have a system that generates forms for the client, and when it fills such automatically saves an Excel with the data, but when I open Excel appears the error: O formato de arquivo e a extensão de…
-
0
votes1
answer358
viewsEdit Excel spreadsheet with C# in Microsoft Azure
I have a web application that reads an excel spreadsheet and imports the cell values into the database automatically. I am using COM, so it is necessary on the machine Microsoft Excel installed.…
-
0
votes2
answers2198
viewsImporting EXCEL data into PHP!
Hello, I come to ask for help regarding EXCEL and PHP; A little while I joined a company, where has a Dashboard made in VBA in EXCEL, however, I realized that it gives much problem. So I decided to…
-
0
votes1
answer892
viewsApache POI: how to know if a spreadsheet has come to an end?
I am developing a personal project, and for this I am using Java along with Apache POI to read XLS files, how can I know if the spreadsheet has reached its end? Thanks in advance!
-
0
votes1
answer292
viewsHow do I install a library (Phpexcel) in a codeigniter application using NPM?
I am developing an application that needs to export data from an array that received the result of a query in Excel format, in a dynamic way, and I wanted to know how to import the library, I…
-
0
votes1
answer1630
viewsVba + Google Chrome
I have been having doubts for some time and even after several researches I did not succeed. I am creating a function in VBA capable of handling a web page using Google Chrome. Although I set Chrome…
-
0
votes1
answer48
viewsDoubt with excel files
I have a list of dates in a BTH.cvs excel file. I want to copy the entire file to another new.cvs, but a.exe stops working. #include <stdio.h> #include <stdlib.h> int main(int argc,char…
-
0
votes1
answer1221
viewsAutomatic classification with tiebreaker criteria
Good afternoon, using the automatic classification of excel, is it possible to create levels and sublevels? For example, I am creating a football spreadsheet and want to sort first by score and if…
-
0
votes1
answer607
viewsHow to run macro with locked project?
Hello, I have a spreadsheet whose project has a password, however I want the macros to work and if the user tries to enter the macros he will have to put the password (I put in the project). I put a…
-
0
votes1
answer1517
viewsHow to insert photos from a folder into a cell in Excel automatically?
I need to insert several images in Excel, however it is difficult to insert one by one, are more than 300 photos, and there will be updates of these photos. I was wondering if there’s a way to…
-
0
votes1
answer244
viewsHow to insert excel table in mysql using php
I have a table in excel with more than 300 lines and would like to insert the data of this table in mysql in phpmyadmin php usage currently Thank you for your attention!
-
0
votes1
answer725
viewsRunning time error '91' The object variable or the block variable with has not been defined
I do not know how to play very well with excel, I have to make a graph using buttons and gave this error Sub logs_acumulador() ' ' logs_acumulador Macro ' ' ActiveChart.SetSourceData Source:=Range(…
-
0
votes1
answer65
viewsHow to hide a table in excel without resizing the chart
I would like to hide a table but it feeds a graph, I would like to do this without resizing the graph. This chart uses selection buttons that have been formatted with macros.
-
0
votes1
answer45
viewsFormatting graphs in Excel
How to make so that when I take the information from a server using mysql, this information appears in the chart sheet already formatted in excel?
-
0
votes0
answers174
viewsEXCEL: Form filled in specific places
In this image I have 7 "blocks" to be filled via form, they are side by side. As I do in vba a function that fills these blank fields of TM1 and TM2 automatically, I want to include this function in…
-
0
votes1
answer115
viewsTranspose data in an automatic way
I have the following problem, I need to create a "robot" that reads the data of a given cell in Excel and enter this data in another software (own software of the company in which I work), but it…
-
0
votes0
answers60
viewsPhoto of a database
I have a spreadsheet that I need to place photos pulling from a database. The trigger would be the product code. When entering the product code, the photo of the product would go up to the…
-
0
votes1
answer655
viewsHow to only get a cell from a CSV file with PHP?
How do I pick up only one row of a specific column? In the code below it shows me all the rows and all the columns you have in the CSV file. I just want a specific cell. Example: Column B - Cars…
-
0
votes1
answer41
viewsField of view of surveillance cameras in Excel
Good afternoon Commonwealth, I have a question about Excel, where I do not know if it is possible to make such a request. My goal is to take a plant and through a Solver, put surveillance cameras at…
-
0
votes0
answers184
viewsChange field format in excel to import into sql server Wizard
I need to import data from an excel to sql server. My big problem is that the data coming from the source, from an excel column is being interpreted by this Wizard as varchar, even though I make all…
-
0
votes0
answers43
viewsQuery with return #num! for columns string in excel
I made a query in excel that when running it in VBA was generated a result. Among the generated columns, one that was text appeared with #num! in all values that were not empty before. I believe…
-
0
votes0
answers58
viewsBring the last date according to entered code!
I have a spreadsheet where I bring the client’s code and a visit date, I would like a formula where through the code I bring the last example date Cod. Date of Visit 1 01/04/2018 2 01/04/2018 3…
-
0
votes1
answer66
viewsSelect ROW_NUMBER from an excel table
Today I wear SELECT * FROM [Plan1$] To select the Excel spreadsheet data, I would like to know how to select the record row as well.
-
0
votes1
answer871
viewsCopy data from one column (B), to another sheet, if column condition (F) is met. excel
I tried and I keep trying several codes to automate the data copy (column B, spreadsheet proposals) to another spreadsheet (Projects), also in column B, if the F column of the worksheet "proposals"…
-
0
votes0
answers565
viewstake excel cell value below or next after checking the field name
good. I have an excel file that presents information below. i intend to extract some information and assemble a single table with the following columns: the original file, it breaks the information…
-
0
votes1
answer81
viewsReference all cells with a given string
I do not know if it is possible or not, but it is possible to reference all cells with a certain String in a single cell? For example, at this point I wanted the cell in column F to be all the…
excelasked 6 years, 5 months ago msm.oliveira 642 -
0
votes1
answer106
viewsDifference between dates with condition (only count given month)
It is possible to calculate the number of days between two dates of only one month ? For example 28/5/2018 to 2/6/2018 and I just want the number of May days (result = 4)
excelasked 6 years, 4 months ago Ricardo Santos 11 -
0
votes1
answer197
viewsHow to set the line height of an Excel in NPOI?
I am trying to create a line in an excel file through the library NPOI. The problem is that I don’t know how to set a line size. Currently, the line is covering the text content. How can I set the…
-
0
votes0
answers230
viewsHelp in Procv to select data
I have a database where an employee has three dependents or more when I do a PROCV to pull one dependent at a time, appears only the first and the last. =PROCV(B35;'SÓCIOS COOP'!C:G;5;1) How do I…
-
0
votes1
answer110
views -
0
votes0
answers234
viewsExcel file creation error with Phpexcel
I would like to know the correct way to align the text in all columns; adjust the width of all columns; and also apply bold in ranges of cells. The way my code is, it does correctly, however,…
-
0
votes1
answer40
viewsChanging excel cell values
Need through MACRO to change the value of a cell in excel. A field of the accounting type has the following value: R$15,326685459. I need to change the cell automatically to stay: R$15,32000000000.…
-
0
votes0
answers238
viewsExcel VBA with slow array s to taratar data
I am developing a code to be applied in excel that summarizes the number of defects in a summary table. The data is imported from an xml file, which is opened by excel and created "layout" by excel.…
-
0
votes2
answers1830
viewsExcel - How to concatenate cell range?
How do I concatenate a range of cells in Excel? For example: I have a column with many cells containing text information and I would like to concatenate them, but when using the concatenate function…
-
0
votes1
answer55
viewsAlternate text of sharpes for saving config
hello would like to know if there is any problem/risk of using the Alternativetext property of sharpes objects to store working parameters has some risk of out of nowhere these data being…
-
0
votes2
answers1823
viewsVBA - How to search words from one list in another and point "Found"
Good morning. Got stuck, in that. In the plan1 column A I have a list with 20 different words. In the plan2 Column C I have complex texts in each cell. I need to walk the plan2 Column C searching…
-
0
votes2
answers16823
viewsWhat is the logic for calculating the percentage of victory, draw and defeat?
I’m wondering the logic of how to calculate the percentage of tables in a football game. For example, I put a quick Excel tabelinha here just for demonstration. In red is the real percentage, and…
-
0
votes2
answers838
viewsPass txt database to mysql
Hello, I’m with a txt file where I wanted to get its contents to put in a database, but I’m having difficulties following an example of how this file: [03471] Nome=fulano Idade=20 Sexo=Masculino…
-
0
votes1
answer44
viewsHow to resolve Invalidformatexception in xls file generated by Jett?
I have a way of generating reports done with Jett: Map<String, Object> beans = new HashMap<String, Object>(); beans.put("fichasTecnicasMateriaPrimaResumo",…
-
0
votes2
answers1260
viewsHow to paste a dataframe over a pre-formatted Python worksheet?
I have a template pre-formatted in Excel this way. I would like to paste values from a dataframe into pandas on these cells, creating a new file formatted with values and keeping the original file.…
-
0
votes1
answer1278
viewsMacro VBA for Exel - copy data from one sheet to another with one condition
Hurray for you guys, I’m completely new to VBA and a major programmer. I need help to build a macro for Excel. Context: In the Excel book that is found in the following link, I intend to develop a…
-
0
votes1
answer815
viewsAutofilter Excel VBA
I have a problem, when trying to make an autofilter in vba it is trying to filter the values I chose but ends up not filtering value, I searched a lot and found no explanation. The code is as…
-
0
votes0
answers42
viewsExcel, modify duplicate line data
Good afternoon, you guys. I am very bad of Excel and appeared a demand to me that to do manually will give a monstrous workmanship, so I come to you. This is the scenario. A | B | C | 1- Tiago | | |…
excelasked 6 years, 2 months ago Tiago Camargos 13 -
0
votes1
answer157
viewsMessagebox in VBA in Excel
Dear friends, good afternoon I am working on a dynamic table in excel and I would like when the store text 10 was typed, it displayed a warning that this store is unavailable, I know I need to call…