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
votes1
answer173
viewsSummarize data in Excel without VBA or dynamic table
I’m sorry if this question has already been answered, but I’m not able to even elaborate the question to do the proper research. I have a list of products sold in excel, and I need to select the…
excelasked 7 years, 11 months ago Tiago Gomes 111 -
1
votes1
answer2078
viewsxlrd opens files in xls format?
excuse my ignorance on the subject, but I’m developing a Python script that reads Excel files to get certain information on these, and for that I’m using xlrd, I was wondering if xlrd is able to…
-
1
votes0
answers293
viewsC# Asp.Net.MVC - How to read Excell spreadsheets (xls and xlsx) using NPOI and generate a datatable?
I would like to read an Excel spreadsheet (XLS and XLSX) in my C#application, using the NPOI library and generate a Datatable. Since I’ve never used this library someone could provide me with a…
-
1
votes1
answer2259
viewsExcel vba: Saving data from a spreadsheet in . txt format
Good afternoon. I have the macro below and it already does almost what I want (creates a txt file with the data of the Historico spreadsheet, always rewriting the file, ie, does not create several…
-
1
votes1
answer2650
viewsAutomatically leave dates in order
How do I leave my table that has dates organized in order, type, has the cells: date of issue; name; expiration date; situation, I wanted my table organized by date of expiration automatically when…
-
1
votes1
answer340
viewsSave Chart of a spreadsheet in a folder by VB
Hey there, guys. I’m a beginner in VB programming and I’m with a project, where I access a spreadsheet and insert data into it and this data is shown in graph. How do I save this graphic as an image…
-
1
votes1
answer677
viewsHow to set the filters in a Pivotchart through a macro in Excel?
I made a VBA form and wanted to click on a button the filter properties of the dynamic graph associated to a table in Excel if they changed.
-
1
votes1
answer992
viewsHow to write a . csv file in Python including file settings?
How can I create a csv file containing column width information and configured header and things like that, is it possible? or we can only write the data without any configuration?
-
1
votes0
answers44
viewsMysql for Excel
I connect to the BD, click but when editing the folder is password protected. I tried to enter the BD password and nothing. Someone had that problem, could give a help?…
-
1
votes1
answer913
viewsExport tabulated text in Excel
Hello I need to generate a text file based on this layout for it to be imported into a system. I’m trying to use Excel, create the cells with the proper sizes as you request the layout. In Excel I…
-
1
votes2
answers242
viewsSplit date format
I have the following value 14/02/2018 13:53:12 in excel. Cell with value is in text format. When having concatenate the value the date above is like this: 43145,57861111111 Does anyone know how to…
-
1
votes1
answer347
viewsImprove performance when generating excel spreadsheet
I’m using this generated NPOI to create excel spreadsheets and am facing the following problem: The generated spreadsheet has 300 lines and takes 1 minute to be generated and sometimes error…
-
1
votes1
answer1136
viewsCount values if values in two columns of the same row are specified
I have two tables in excel, Suppliers and History: I need to count how many times supplier A made mistake A, supplier A made mistake B... and so on, I thought I’d build something with CONT.SES, but…
excelasked 7 years, 10 months ago MarceloBoni 6,385 -
1
votes0
answers1090
viewsFunction to export table in html and php to Excel
The function really works in Chrome, but I have a problem to make it work in IE and Firefox and I need to export in Excel to these two browsers, for one project. What changes would be needed? I’ve…
-
1
votes2
answers508
viewsSearch in Table of Values in excel
Hello! I’m doing a cost chart for my company and I’m needing to do a search on a value chart, but the only way I currently know how to do it is through various chained Ses, which will take a lot of…
-
1
votes0
answers265
viewsDuplicate record when saving data from a form in vba/useform
Good afternoon friends, How do I duplicate a record in a spreadsheet with data saved from the useform. Being more specific, I will use an example of a health plan where I have a form that registers…
-
1
votes0
answers1074
viewsWrong value when using ADD.SE using a cell criterion
I have problems applying the formula SOMAR.SE.S. In the image the sums in column N use the following formula (N4):…
excelasked 7 years, 9 months ago Pascual Felicio 11 -
1
votes2
answers1488
viewsChronologically order VBA date and time
Good afternoon, I would like to know how I do to sort by date and time by excel. It would be 1 hour column and another date column. Oh my doubt is how I order the schedules chronologically without…
-
1
votes1
answer487
viewsUpdate Frame Selenium VBA
Expensive, How can I update a frame with Selenium in VBA? Updating frame is an option that exists when right-clicking on some frame. I can’t update the whole window, only the frame.…
-
1
votes1
answer683
views -
1
votes1
answer1675
viewsHow to read data from an excel table in C?
I know how to read data and write to files .txt code C through functions fscanf(), fprintf() etc. But now I would like to know if there are functions or libraries in C that allow me to process data…
-
1
votes0
answers40
viewsPivottablewizard() "Connection" parameter
Hello, could someone provide me an example of using the appropriate parameter connection of the method PivotTableWizard()? When I use this parameter I get the error: Unable to obtain the…
-
1
votes2
answers65
viewsExcel, analyze condition in data table
I need to change one column of values in excel according to the condition of another column. For example, analyze tax ratings and if they are "sales returns" I need to change the quantity to…
-
1
votes4
answers6070
viewsExcel VBA - Runtime Error '13': Incompatible Types
I’m getting Error '13' Incompatible Types on the First If Line: Count = 0 For x = 1 To LastRow Step 1 If Cells(x, 8).Value = "Materiais" Or Cells(x, 8).Value = "Imobilizado" Then If Cells(x,…
-
1
votes2
answers9649
viewsAutomatically fill cells in excel using VBA
Good afternoon community, I am trying to work with VBA in Excel in order to try to apply this knowledge in my master’s thesis, but I have some doubts. I am trying to create a VBA function that fills…
-
1
votes1
answer289
viewsRemove duplicates based on one column value
I would like to know how I can perform the following filter: ===> That is, how to remove duplicates in the "action" column, but leaving the record with higher priority (in this case, '1' is the…
-
1
votes0
answers60
viewsHow to get Excel formula in C# using Oledb?
I need to get the formula contained in an Excel cell. I am using Oledb to access the spreadsheet, I wonder if you have how to use it to access the formula of a cell?
-
1
votes0
answers94
viewsJava - Apache POI for Excel
I need to extract the information from an Excel file (xls) in Biff4 format, and Apache POI, although it is great for reading Excel files of version 97-2003, does not help much with these older…
-
1
votes0
answers89
viewsGenexus X Ev. 3 - Problems reading Excel(xls)
Hello, I’m having a problem reading xls, just loading and appears at the bottom of the browser "Waiting for localhost(or the server)", I did the test with xlsx works normal. I have done tests on…
-
1
votes0
answers403
views0 the left power query
I’m having some problems, what is the command to add 0 to the left in the M language? I’m using the power query excel, I have data starting with 0 but it does not consider this value and brings me…
excelasked 6 years, 10 months ago John Hebert 151 -
1
votes0
answers66
viewsExcel with password for editing
I am mounting an Excel file where I Gero an array of bytes and the UI downloads the file in xlsx format, I need to open this file with password to perform edits, there is a way to do this right in…
-
1
votes0
answers301
viewsFor Each In . Control GROUPED Shapes for excel
hello would like to make a For Each In . Shapes "those shapes" but they grouped I was able to assemble with them disaggregated, but grouped it seems that the procedures are different what I’ve…
-
1
votes1
answer710
viewsHow to generate a report in excel with tables from a database using C#?
How to pass the data of a query to the columns and rows of a sheet in excel? Example: OleDbDataAdapter oda = new OleDbDataAdapter("select * from usuario", conexao.cn); DataTable dt = new…
-
1
votes1
answer1556
viewsProblem with waterfall drop-down list
Contextualization I am trying to create a drop-down list for cells in the Model column, which depends on the corresponding cell value in the Manufacturer column. The above table is in the tab Plan2…
-
1
votes1
answer18482
viewsCompare two columns in EXCEL and if they are equal return a certain value
I’m having a hard time generating a logical structure (If) to validate some data. It’s for a survey. follows the explanation: There are two columns (B and H). In the column B there are all Brazilian…
-
1
votes1
answer1532
viewsVBA - Copy and paste data without column sequence to rows
Hello ! I have a spreadsheet with two tabs: In PLAN1 I have a single column with several data, but they do not follow a sequence. The values that can be found in this column are: Product code (Ex:…
-
1
votes1
answer347
viewsHow to separate Edit String in Excel
I need to separate this type of string (Example): 1 Estruturas lógicas. 2 Lógica de argumentação: analogias, inferências, deduções e conclusões. 3 Lógica sentencial (ou proposicional). 3.1…
-
1
votes1
answer87
viewsHow to write data from an excel to an xml file
I would like to be developing a program that has to read excel files and write to an xml file but I don’t know how to write the data to the xml file. I’m reading the excel file like this : var…
-
1
votes3
answers8269
viewsHow to add character after last word written on line
Dear community, I have a doubt that I’ve tried everything, but I can’t solve. I have a list of former names; José Mario da Silva Mariana Cristina William Caio Jorge Luiz Campos de Silva Andrade In…
-
1
votes1
answer520
viewsImport an Excel table into Genexus
I started messing with Genexus recently due to my internship, I need to pass the information from an Excel spreadsheet to GX to use in BD. I am aware of a Pattern that does this, but it is still in…
-
1
votes1
answer83
viewsHow to format data extracted from datagridview to excel
private void button1_Click_1(object sender, EventArgs e) { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();…
-
1
votes1
answer699
viewsFunction "=SE" with Excel "up" only works in column? but I did not proceed in line
In a small table, I inserted the function "=If" with the ":", but it only works if I put the numbers with their respective colored spheres in column, when I specify what I want from the cells…
excelasked 6 years, 6 months ago Elienay Junior 527 -
1
votes1
answer1600
viewsIF condition - Show or Hide Textbox
Expensive, I have 4 optionButton (2 different groups), where 2 represent "Yes" and "No" for two different questions. What I want to do: When the user chooses the NO option in group1 and then chooses…
-
1
votes1
answer190
viewsError writing and reading CSV file
I have the following problem in writing a CSV file. The file appears this way: NULL My class of Archive import java.io.BufferedReader; import java.io.BufferedWriter; import java.io.File; import…
-
1
votes1
answer152
viewsVBA - Maximum character in dropdown-list
' Validação Motivo Columns(motivo).Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:= _…
-
1
votes2
answers561
viewsIMPORTHTML in Google Sheets with error
I’m trying to create a file to get the data from Alexa’s Audience Geography area/table (https://www.alexa.com/siteinfo/twitter.com) but google Sheets whenever I try to pull appears an error.…
-
1
votes1
answer123
viewsIs it possible to pull information from a specific site in an excel site?
My question is this... I got a topdesk call. I would like to pull information like opening date and completion and status (open, closed, solved)... I was wondering if in excel there is a way I do…
excelasked 6 years, 4 months ago Sandson Costa 509 -
1
votes1
answer1450
viewsOpen Excel spreadsheet and copy the Data into VBS
Hello, I have a simple spreadsheet (3 cols and 2 Rows) and am trying to create a script to open it, copy your data and insert into another. Path =…
-
1
votes2
answers1235
viewsIdentify the position of the first empty cell
I have a web integration that automatically sends values to my spreadsheet. In one of my columns I have a URL that is concatenated with the value of a column ID on the side. I need to add in this…
excelasked 7 years, 2 months ago Fábio Junio Alves Sousa 283 -
1
votes1
answer1003
viewsHow to close an alert in IE in with VBA
I have an Excel macro that connects to a local tool and extracts the information. Basically I take a report according to the user. I have a column with users, however if the user does not present…