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
votes1
answer1147
viewsHow to import data to Json from a table in Excel
I want to generate charts with Chart.js and need to import data from an excel spreadsheet to json in order to elaborate the chart. var data = { labels: ["January", "February", "March", "April",…
-
2
votes0
answers156
viewsHow to inherit a VBA form?
I need to inherit a form in a VBA to use it as a basis for other forms. For example, a form called "Table" contains a list of two columns and buttons for 'Edit', 'Include' and 'Rule out' the items;…
-
2
votes3
answers1955
viewsHow to scan data from an Excel spreadsheet
I have a Mysql database and I want to take the data from an excel spreadsheet and send it to him. I already know how to save the data in the table, just need to know how to scan the spreadsheet and…
-
2
votes1
answer693
viewsIs it possible to recover the selected values from a multiselect (not active X) list box?
It is possible to recover the selected values from a list box (Form control) with the option of multiple selection, by formula or Vba?…
-
2
votes1
answer1590
viewsOpen another instance of Excel while VBA runs
I created an Excel application that extracts information from the internet, directly to it through the Selenium IDE Webdriver. However, while this application runs, I cannot open a new spreadsheet,…
-
2
votes1
answer269
viewsError generating excel file
When the system runs on the server this error occurs: ERROR: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error:…
-
2
votes2
answers1097
viewsExcel vba - Httprequest GET
I am trying to do a GET in VBA in Excel, and found several examples, below is what I am using: Sub http() Dim MyRequest As Object Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")…
-
2
votes1
answer739
viewsHighlight Textbox if the loaded value is equal in the worksheet
In a Registration Form when clicking search the textbox are completed. And if any of these Textbox has a value that is on plan1 from the "AS" column then this Textbox has the highlighted text (e.g.…
-
2
votes1
answer2823
views"Build Error" message (Loop without Do)
I don’t understand why I ever put Do Until! Private Sub cmdPequisar_Click() 'Verificar se foi digitado um nome na primeira caixa de texto If txtCPF.Text = "" Then MsgBox "Digite o CPF de um cliente"…
-
2
votes2
answers640
viewsAre there security problems by Auto Macro Run when calling Excel?
The link below deals with auto macro execution when starting the Excel I had the purpose of controlling the use of a VBA.…
-
2
votes1
answer1139
viewsVBA. I try to convert a txt to excel
Hello guys I have this macro to convert several txt for excel, but when it converts it does not separate the file by column ";" Sub Convert_Csv() Dim File_Names As Variant Dim File_count As Integer…
-
2
votes1
answer114
viewsConsolidate macros
I need to create a macro that allows me to choose all . xml files and import them into excel. At the moment the process is as follows: - I open the first one manually and then call the macro that…
-
2
votes1
answer1338
viewsComparing lines from a file with data from a spreadsheet
I’m new to Python and I have a problem that’s getting me out of the picture... Here’s the thing, I want to get the strings of a file and compare its elements with the sentences written in the…
-
2
votes2
answers2141
viewsUSERFORM: What is the difference between Initialize and Activate routines?
What’s the difference in using Initialize and Activate as a Userform boot routine? Private Sub UserForm_Initialize() Private Sub UserForm_Activate()…
-
2
votes1
answer729
viewsXML mapping in Excel 2013
I have a spreadsheet where on each line I register a test case and then export it to XML, then upload this xml into another system we use. The problem is that I can only do 1 to 1, I can’t fill…
-
2
votes1
answer3446
viewsHow to import data from internet to excel vba
I’m trying to download a table from the site: "http://www.scoutscartola.com/mercado", and I already "got". But there is a problem in my code. I want the user to define the team. This is done by…
-
2
votes1
answer312
viewsError while trying to read excel file C#
public partial class FrmEditar : Form { private OleDbConnection _olecon; private OleDbCommand _oleCmd; private static string _arquivo = string.Empty; private string _stringConexao = string.Empty;…
-
2
votes2
answers1037
viewsMove only part of a text to another column
I have a spreadsheet as an attachment that in the street column is the address and the number, however, I want to separate, ie remove the number of the addresses that are in the street column and…
-
2
votes2
answers1655
viewsCreate spreadsheet by C# without having excel installed
I am developing a program that should export data to an Excel spreadsheet. I need to know how to build a spreadsheet with C#, but only found tutorials that require excel installed on the computer. I…
-
2
votes2
answers512
viewsJSON to XLS in java
Is it possible to turn a JSON into XLS with java? I’ve done an algorithm that writes JSON to CSV, but not XLS. If you can post libraries or examples.
-
2
votes0
answers274
viewsGenerate an excel file in Vb.net without excel installed
Hello, I have an application that generates Excel spreadsheets, but some users are having several problems (users without license or office). Today I use the COM method (using the office dll). I…
-
2
votes1
answer360
viewsExport Table to Excel, Problems with String Numeric
I looked here in Stack, but maybe I did not find the right question, I am exporting data from PHP to Excel with HTML tags, it exports in a good way, I happen to have a column that is String, for…
-
2
votes2
answers421
viewsHow to expand range of numbers with data?
As I would in excel to expand a huge list with data to instead of grouping value data, it shows the content in total. Example: I’d like to transform that: Therein: Remembering that it will be a huge…
-
2
votes1
answer6622
viewsMacro VBA for inserting images automatically based on a column of codes
Good afternoon, I have a spreadsheet, in which there is a column with the code of the photos and in the other column beside with spaces to insert the images. I wonder if there is any way to…
-
2
votes2
answers2802
viewsExcel/VBA file more than duplicates in size for no apparent reason while being saved
I’m working with the Excel and using some programming resources of the VBA via modules (without using forms), and there has been a problem, the file currently has 8MB and I saved continuously with…
-
2
votes3
answers962
viewsHow to make the automatic recalculation of Excel trigger a routine in VBA?
I have a graphic scheme on Excel which is done by way of conditional formatting (see figure below), ie in the colored cells there is no content, only the background colors are changed based on…
-
2
votes1
answer561
viewsFormula Excel - Apache POI
I created an excel file using the Apache Poi API, in it I set one of the cells with a formula, but when I open the file I need to "enter" the cell with the formula so that it prints the result in…
-
2
votes1
answer139
viewsCell selection
I need to select the line with the value of combobox 1 and with the date of combobox 3 to select the desired line to delete. This is the problem I have to solve. Someone can help me? This is the…
-
2
votes1
answer83
viewsExcel DISTF equivalent in R
I wonder if there is in the software R a function similar to the function of the software Excel, DISTF? The excel DISTF function returns the probability distribution F (right-tail) (diversity level)…
-
2
votes2
answers691
viewsExcel: Create scale with 2 known points
Hello, I have a problem - q I believe to be much more mathematical than a formula in Excel. I have a list with percentages of results and need to "scale" these values according to two known points.…
-
2
votes1
answer573
viewsCounter to insert blank line every 5 equal cells
Hello, I’m trying to make a macro for a button, which puts a blank line every 5 cells with equal content, but I’m quite layy in VB syntax and I’m not sure if the logic is correct either, example of…
-
2
votes1
answer482
viewsHow to delete or hide the password entry to access the data of a server with SQL Server from the VBA or Excel macro?
I’m running a database migration service from a server with SQL Server in a company, but requested that I broker the migration in Excel, because they want so in this first phase to advance some…
-
2
votes1
answer216
viewsC#: how to identify sheet title
Good morning guys, I’m making an excel converter to txt and a doubt arose, I was trying to make an algorithm in which it detects the column title and returns error if the column had the same title,…
-
2
votes1
answer141
viewsProtect Excel spreadsheet in C#
In a C#application, you can have from 1 to 2100 hours of data collection. Data is saved in a CSV Excel spreadsheet every minute. With the code below we can hide and show the file. #region string…
-
2
votes1
answer5260
viewsVBA code to delete line
Guys, I have a code that checks the line if there’s a word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> "Defeito" Then Rows(i).Delete Shift:=xlUp However I in the spreadsheet…
-
2
votes1
answer340
viewsCombobox does not update and accepts wrong values
Good, I have this code for a combobox, and I have two problems. First: I can’t get the combobox to accept only the list values Second: the listing has only one value Private Sub TempCombo_Change()…
-
2
votes1
answer150
viewsfunction if - true copy cell and glue in another
I need a little help. I have an excel sheet and I want to do the following: In this capacity = SE(F10=O11;Copia valor celula G2 e cola na celula G10;"falso") I want to make a comparison and if true…
-
2
votes1
answer36
viewsExcel - Match Rows in Another file
The question is: The Question is: I have 2 csv files, one of them has only one "email" column with several lines of valid emails, I also have another file that has the same emails and some more, in…
excelasked 7 years, 4 months ago Miguel Pinto 21 -
2
votes1
answer1024
viewsHow to compare two columns of a spreadsheet, and keep the information that is equal?
Hello! I am working with a spreadsheet in Excel that has this structure: Coluna_A Coluna_B A A B B C C C_1 E D E F What I want is to find a way to assemble a third column, which has data present in…
-
2
votes3
answers1421
viewsforeach - Browsing CSV archive
I need to scroll through a CSV file to capture a value and print it on the screen. Example: Column "N" line "2", in this case it is cell N2 that is written: 2,98 How to print this N2 cell on the…
-
2
votes1
answer74
viewsCreate image in another form
I have the following project: When I click the button works perfectly, no problem, but I wanted q the QR Code was generated in Spreadsheet 2 for example. Below the macro code Sub GenQRCode(ByVal…
-
2
votes2
answers2756
viewsChecking and Filling Excel Cells
I have the following spreadsheet as image below, I would like to create a VBA to check if the content inserted in the range of cells of this spreadsheet exists in the list of the second image below,…
-
2
votes1
answer86
viewsHow to read an excel file and map
I would like to know how to read an excel file and then map to a datagridview. Code I tried on : var fileName = @"C:\Users\HP8200\Desktop\test.xlsx"; var connectionString =…
-
2
votes3
answers824
viewsExcel rounding value 7,256E+18
That old Excel cell formatting question is causing me problems now. I use the Laravel framework and to export the data I use the Laravel Excel. I’m formatting the cell to type text and yet Excel…
-
2
votes2
answers126
viewsIs there any Excel function that returns the body of another function?
Simple example of what I want: suppose in cell A1 I have value 2, in cell A2 I have value 3 and in cell A3 I have formula =A1+A2. If I put in cell A4 the formula =A3, it will obviously return me the…
-
2
votes1
answer169
viewsProblems with the excel connection string
I have the following code snippet that connects to Excel, but returns the error: string sFileXLSX = ConfigurationManager.AppSettings["ExportPerformanceEntrega"]; string strConnXLSX =…
-
2
votes1
answer84
viewsHow do I make a customer list appear in a search from the name in Excel?
I have a client list; I want to do a search where you type in part of the customer’s name and then appear all the customers who have that name. Example: Social Status of Clients: João da Silva ME;…
-
2
votes0
answers269
viewsHow to read an excel and insert the data into a table?
I wanted to send data from a file Excel for a table on Sql. I tried using the bulkcopy.ColumnMappings.Add but you’re making a mistake. System.Invalidoperationexception The Given Columnname does not…
-
2
votes2
answers68
viewsexcell’s formula
I have three lists of scores, the first and the second vary from 5 to 10 and the third from 0 to 150. When summing up the data, obviously the variations of the third will be greater than in the…
excelasked 7 years, 1 month ago Carlos Filgueiras 31 -
2
votes1
answer107
viewsError inserting data from an excel file into sql
I have a problem when I insert data from excel file into the database because a field that I am entering says it is not of the type time and does not allow inserting , but in the excel file the text…