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
answer989
viewsProblem with VBA and Internet Explorer integration
I am trying to use VBA to collect data directly from the internet. I saw several examples of the use of the Internetexplorer Object, as below: Dim IE as Object Set IE = New InternetExplorer…
-
1
votes0
answers291
viewsWeb Pages - Show, impute and search data in an Excel file
I created a page WEB to function as a FAQ in the Sharepoint 2010. But I don’t have much knowledge Sharepoint nor HTML and JavaScript. I am researching to gain more knowledge on the subjects. On my…
-
1
votes1
answer875
viewsSum quarterly data in columns
I have the following doubt: I have five columns...each with quarterly information; Consolidado 31/12/2006 31/03/2007 30/06/2007 30/09/2007 31/12/2007 .... Reserva de Lucros 12300 12300 646 646 33283…
-
1
votes1
answer477
viewsPROCV - How to avoid the window to select external spreadsheet when non-existent
I have a planilha using access to lookup of other planilhas PROCV, but they are floating formulas, that is, they change according to the input in specific fields. This change occurs through Macro,…
-
1
votes1
answer5403
viewsMacro to exclude filtered table row
I created a table with data from an account balance and I am doing a macro to select only a few values. An assignment of the macro would be to filter in one of the columns all zeroed values so as to…
-
1
votes1
answer1200
viewsObtaining data from excel and turning it into a list by Python
import xlrd def ler_arquivo(teste_termal1): tt1= xlrd.open_workbook('teste_termal1.xls', formatting_info=True) eajp60= workbook_r.sheet_by_index(3) Coluna_4=[3] Coluna_13=[12] return {…
-
1
votes0
answers70
viewsHelp with logic of a system that writes data to Excel columns
Guys I have an application and I can pass the data to excel, the problem came up now because I have to make a loop and I’m not finding the best way to do it. I have several lots, for example,…
-
1
votes0
answers2077
views -
1
votes0
answers551
viewsHow to insert an image in the xsl spreadsheet with php? Since the database is saved only the image path in a folder on the server?
What is being passed to the spreadsheet is only the image path, but I need the image to be passed to the spreadsheet. The image in the server folder, only the image path is saved to the server.…
-
1
votes1
answer10265
viewsMacro to copy from a spreadsheet and paste only into cells visible from another
I need to copy the "L" column of the sheet "DIVISAO" to the filtered cells of the "L" column of the sheet "DPTO". That is, I need a macro that looks for the information in a spreadsheet and sticks…
-
1
votes1
answer281
viewsExport XLS content in Wordpress admin
I need to export specific content to XLS within the administrative area, and am using the following code: $arquivo = 'planilha.xls'; $html = ''; $html .= '<table>'; $html .= '<tr>';…
-
1
votes1
answer2459
viewsVBA - excel does not recognize comma of external data
Good morning to all! I am trying to integrate excel to other software (the EES - Engineering Equation Solver) through a code in vba. My program copies certain columns of a table, transfers to the…
-
1
votes1
answer660
viewsExport table content to an Excel file
I wonder if it is possible to create a function in PHP and/or Javascript that allows to export the contents of a table in HTML (table inside a div) straight to an Excel file. I’m trying to take…
-
1
votes0
answers618
viewsPhpexcel - Library automatically converts the notation of the date when importing Excel spreadsheet, from dd/mm/yyyy switches to mm/dd/yyyy
I’m going through a problem that’s already making me bald.. In a certain part of an application, I need to import the user’s data through an Excel spreadsheet, for this I am using the Phpexcel…
-
1
votes2
answers2421
viewsHow to compare the values of one interval with another, following a formula?
I have my championship leaderboard, which has a row "Number of Laps per Race" and, below, "Turns Completed". I want to go through all the values of the line "Turns Completed" and compare with the…
excelasked 8 years, 8 months ago Bruno Santos 13 -
1
votes1
answer485
viewsHow to Extract Data from Excell to Generate Graphics?
I have an Excell table with 50 rows and 10 columns, containing data students enrolled in a contest. I have to create charts from this data. Could someone suggest a way to extract and work this data…
-
1
votes1
answer2192
viewsTool to convert Excel to Json
I have an Excell table and I need to generate a chart with Charts.js which uses json to build the database. So how can I convert an excel table with 50 rows and 10 columns into JSON data.
-
1
votes2
answers71
viewsDo not modify cell for a given result.( History)
In a management table I have two columns a Status(Coluna A) and another Estado Anterior status. In this I want to keep the same value as in column A, except for some case. So that it keeps a status…
-
1
votes1
answer44
viewsInaccuracy of column sum result
Environment: Excel 2013 Example: When adding the values of a column with 1110 lines, the result obtained is 302,204,548.38 If you add the value of 249,998.78 in row 1111 of the same column, you…
excelasked 8 years, 6 months ago António Jesus 21 -
1
votes1
answer182
viewsHow to copy multiple excel files in an access 2010 database using vba
am new in VBA programming. I need a vba code in excel that copies several excel files to an access table.
-
1
votes2
answers1837
views#REF! when deleting cells in another spreadsheet
Good morning, I have an Excel file with two spreadsheet, in 'Plan1' all data are deleted, and a MACRO I made, imports a TXT file and populates the 'Plan1', inserting data and calculations. In…
-
1
votes0
answers219
viewsFiles with extension . XLX of excel have converted to extension .xlx.crypt on my desktop where saved. What to do?
The xlx file extension in excel went to .xlx.crypt. I think it caught a virus. Would you know how to remove and not lose the files? Thanks for your help in advance
-
1
votes1
answer36
viewsDecimalize in Excel
Guys, I have a spreadsheet where the length and height are like this: 0.07 (example) I need it to look like this: 7 (example) How do I do that in all the cells at once? Thank you…
-
1
votes1
answer72
viewsReportviewer - Data merges columns when exported to excel
I am generating a report and exporting to excel, using Reportviewer and Dataset. Reportviewer consists of a table and two textbox, that refer to the title and company, and an image. After doing some…
-
1
votes1
answer795
viewsJoin data from 2 sheets and point differences
I have 2 excel spreadsheets, one has project management data from a fictitious company and another the same data from a fictitious factory: PLANILHA 1: Empresa ------------------------------ Projeto…
excelasked 9 years, 1 month ago Eduardo Silva 3,449 -
1
votes0
answers59
viewsHow to pass the Excel worksheet(s) name to a Jlist
I would like to know how I pass the sheet names of an excel workbook to a Jlist when I click on a button. Since I already have the button created and it simulates a Shell to locate the file. Taking…
-
1
votes1
answer116
viewsHow to find various values from a spreadsheet
Hello, I have a spreadsheet with lots of data, and I would like to separate them each into a spreadsheet by category, example: all products that are with the date of September are shown in another…
excelasked 8 years, 4 months ago mrlucasrib 641 -
1
votes0
answers352
viewsGenerate graph in Excel - C#
Hello, I would like to ask a question: I am exporting the data generated in a gridview to Excel, and at the same time I am generating a Graph in Excel itself from C#. I would like the chart size to…
-
1
votes1
answer1014
viewsIs there any way to read an XLS file and manipulate it in Python?
Is there any way to read an XLS file and manipulate it in Python? Does any library allow this?
-
1
votes1
answer63
viewsHow to merge several Excel tables into one?
I have 3000 tables like in this example: I need to merge them into one and I’m using the remote: =ÍNDICE(TXT!$B$1:$B$200,CORRESP(MAIOR(SE(TXT!$A$1:$A$200="Last…
-
1
votes1
answer3806
viewsHow to generate Forms without title bar in VBA/Excel?
I need to work with some forms without the title bar in VBA/Excel. I found many similar solutions, but all for 32 bits (mainly in old versions of VBA). The indications they gave to adapt to 64 bits…
-
1
votes0
answers87
viewsIdentification of a VSTO solution
I implemented a project of the type Excel Workbook in Visual Studio. The project runs right, my problem is how to install it on the client’s computer. I don’t want an installer Clickonce, because…
-
1
votes1
answer10425
viewsSave an image pasted in Excel spreadsheet through VBA
The code below copies a strip of cells of a spreadsheet that is pasted as image in another spreadsheet, but I did not find a way to save it as an image file in a folder, or even select it to work…
-
1
votes1
answer1160
viewsCreate JSON with Hierarchy through Excel
I have a table with a tree of products. Category, Group and Subgroup. When I export json by excel the file exits without hierarchy: As in this example: [ { "id_cat": 4, "desc cat": "Acessorios para…
-
1
votes1
answer648
viewsError trying to create Excel table with Closedxml
I’m trying to create an application that generates an Excel spreadsheet through Visual Studio 2015 using Closedxml as a reference. As I found some examples on the web, I added it to the code (using…
-
1
votes2
answers1416
viewsHow to create objects dynamically based on vector? (VBA/Excel)
I created two Labels dynamically based on a vector according to the code below, however, in the form only remains the last Label created (Newlabel1), both the first (Newlabel0) and the Label I used…
-
1
votes2
answers763
viewsHow to delete dynamically created objects based on vector? (VBA/Excel)
The code below creates Labels dynamically based on an array, occurs that I did not succeed in trying to eliminate (destroy) these objects. I tested 'Nothing' and other features indicated, but none…
-
1
votes1
answer810
viewsWhy do ASCII characters differ from Excel for presentation by code in VBA?
Does anyone know why this occurs? I need to use font characters "Wingdings 3" in Labels dynamically created in a form of VBA. If these Labels are created directly in the form the problem does not…
-
1
votes2
answers1155
viewsInsert text in the header of a spreadsheet from text in a cell
To configure the header of a spreadsheet I go to Configure Page > Header/Footer > Customize header. Let’s say, in the center section, I want to see a headline that’s in cell A1. How can I do…
-
1
votes0
answers57
viewsHow to find the input field ID (Text and Listbox)?
I ran the code below and was able to identify the field ("body_x_tabc_x_identity_x_prxidentity_x_selBscenCode_x_txtselBscenCode_x_x") through the line of the Set objInputs. But I cannot identify the…
-
1
votes1
answer101
viewsHow to Batch Generate Excel Files in MVC?
I need to generate separate excel files. I tried to do in a foreach foreach (var item in listExtracts) { DataTable table = Mytable; var grid = new GridView { DataSource = table }; grid.DataBind();…
-
1
votes2
answers123
viewsGenerate dynamic table in Excel from MSSQL with 8 million records
I have a table in MSSQL with currently 8 million records. I use Pentaho to analyze this data. I’m trying to use Excel as well. If I set it up to take the data and put it right on the dynamic table,…
-
1
votes1
answer2150
viewsPhpexcel, select sheet when importing data to mysql
I want to import data from a spreadsheet but from sheet 2 and I’m not getting it. I have indicated sheet 2 (index 1) as active in this way, but it always enters sheet 1 (index 0): $objWorksheet =…
-
1
votes0
answers309
views(Spreadsheet/Google Docs) Auto-fill if cell is filled
Basically, what I’d like to do is: Whenever person 1 (p. example) added a date to the table on the left side, the calendar on the right side was filled autom. with the day and color of the person.…
-
1
votes1
answer932
viewsIssue with importing CSV into Mysql
I am importing csv file information into mysql database some spreadsheets were imported correctly, however some worksheets when importing to the bank appear a double quotes that does not exist in…
-
1
votes2
answers758
viewsValues based on the last day of each month (Excel)
Edited: Guys, this is my Excel file. I want the last value of each month of column A to be referenced by column C, that is, for the month and year of each row of column A I must find the value of…
-
1
votes2
answers433
viewsHow to locate next values of the same customer
If you could just help me out with this one, and I think you’ll be good for someone else, too. I am trying to make sure that by clicking search the Textbox are filled with customer data, and…
-
1
votes0
answers148
viewsHow to convert a string from a spreadsheet to date format for mysql?
I’m taking a spreadsheet excel in date format but in the database inserts as string in text format in excel despite this in date try to convert by mysql however in Insert appears the following…
-
1
votes1
answer64
viewsDivide the first record of a column by the last record
I have a table showing data reported during the one month period: DATA REGISTRO 01/06/2016 02/06/2016 03/06/2016 04/06/2016 05/06/2016 50 06/06/2016 60 07/06/2016 10 08/06/2016 20 09/06/2016 50…
excelasked 8 years, 5 months ago Chefe Druida 1,086 -
1
votes1
answer3337
viewsIs it possible to edit Listbox data?
When double-clicking on the line to be edited from the Listbox opens the Userform with the data of the selected line. I cannot get the changes to be modified in Listbox and Spreadsheet. Code when…