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
-
3
votes2
answers1413
viewsHow to verify which is the name of the spreadsheet tab Excel C#
How to verify what is the name of the "Tab" (Sheet$) of the Excel spreadsheet before performing the import pro SQL ? My code so far: protected void btnProcessar_Click(object sender, EventArgs e) {…
-
3
votes1
answer340
viewsImport Mysql data to Excel
To want to import data from Mysql to excel using Python, when I try to make it from an error of tuple. Someone with more experience can help me? I followed the code and the error: # coding=utf-8…
-
3
votes1
answer10539
viewsHow to take the value of a cell with dynamic reference
For example: In the cell A1 will contain a number, which will be the line to be considered. In the cell A2 need a function to display the value of a cell as typed in A1, something like =B"A1". As an…
excelasked 7 years, 7 months ago GilCarvalhoDev 769 -
3
votes1
answer100
viewsfmBackStyleTransparent does not work in Excel VBA
I have a problem in VBA of Excel, and why I searched other users as well and are unanswered so far, as in this link. Property Backstyle = fmBackStyleTransparent does not work It turns out that the…
-
3
votes1
answer7859
viewsIncrease list source in Data Validation
Hello, I have a field of my spreadsheet that has a list by data validation, I would like to know how to increase this source, leaving it more visible. NOTE: Without the zoom scheme. That is the…
-
3
votes1
answer253
viewsUsing Access to export in Excel, Parameterized Query
I am using the database Access, need to export a query to excel. My problem is this:: I am using a parameterized query in Access for the access itself to export to excel. When I make the export…
-
3
votes0
answers461
viewsMachine Learning using R and excel
Hello I have some data that I tabulate in excel monthly, which is very repetitive. I wonder if there is any way to use machine learning in R to teach an algorithm, based on the data I already have,…
-
3
votes2
answers1241
viewsHow to create a macro that enters the site and takes the data from the last day?
Good afternoon, need to access a website and grab the data from the last day and copy them to a folder in excel, the site is highlighted in the macro below, but I don’t know how to proceed to select…
-
3
votes1
answer86
viewsExcel spreadsheet with unreadable cells when filtering
I’m creating a spreadsheet of Excel using the phpExcel(). When placing filters, the result of the cell C3 and C4 where the subtotal is located SUBTOTAL() looks like this: Unfiltered Filtered Does…
-
3
votes2
answers1389
viewsOptimization in VBA code?
I have two spreadsheets, both have the same header, with 77 columns. For testing I put 4 rows with data filled in one of the tables. In the table with the data filled, I have the button with the…
-
3
votes2
answers1367
viewsConversion failed to convert varchar 'No' value to tinyint data type
I am trying to solve a patch error of converting a variable created by me to store data that is in an Excel sheet. The error happens when I try to insert the data that is in this variable in SQL…
-
3
votes1
answer100
viewsExcel cannot read cell in VB code
x.Range("A1:z1").Select x.Goto Reference:="R2C4" verificaCel = x.ActiveCell.FormulaR1C1 if verificacel then I am not able to read the specific cell in the excel spreadsheet, in which I will send the…
-
3
votes1
answer433
viewsData handling in excel
I need to get the generated data from a proc save in any variable that is and make a UPDATE in a worksheet already existing in a fixed path on the system. It is possible to do this process via code…
-
3
votes1
answer156
viewsExcel days function Dates does not work
I do not know what to do, excel does not show me the correct result in the date formula below, the expected result should be 30 days, but appears 30/01/1900…
-
3
votes1
answer137
viewsImage with time interval - Excel
Need to assign an image that appears every 1 hour in EXCEL, how?! It will probably be necessary to use VBA. But I am not very familiar. And close alone after 1 minute.
-
3
votes1
answer29901
viewsExcel formula to search part of the text in a table
I have a table of banks and codes in two columns. Ex.: Banco do brasil S/A 001 Banco do Estado do Rio Grande do Sul - Banrisul 041 Banco Santander do Brasil 033 Banco Mercantil do Brasil 208 Banco…
-
3
votes3
answers13786
viewsVBA: Use Excel to rename files in a folder
I’m thinking of using Visual Basic from Excel to standardize the name of 6000 files in a given folder. These files are mixed between photos and documents, so there are a variety of extensions (DOC,…
-
3
votes1
answer4263
viewsHow to copy and paste as image with VBA?
I need to copy a chart and paste it as an image in the same spreadsheet. I’m trying to select the range that contemplates all the graphic and paste special as file Bitmap or Enchanced. Follows code:…
-
3
votes1
answer97
viewsExcel formula with incorrect result
I have the following formula: =SE(1,5*Q2>F8<2*Q2;"RUIM";"BOM") In Q2 have 44 and in F8 have 70 and my result gives BOM. Where is the error?…
excelasked 7 years ago Gomes André 31 -
3
votes2
answers2124
viewsTake values from an excel spreadsheet and display in a pop-up
I’m developing a spreadsheet and I’m having a hard time starting to work with the macros/vba. However I could not find a tutorial that showed me how to do what I need. I have a table that says: nome…
-
3
votes1
answer114
viewsKeep information in date format with PHP?
I have the following information in a file .xls 12/12/2017 10:34:03 but when I show in the browser with PHP appears like this 43081.4403125. has some way of keeping in date format? I’m using the…
-
3
votes1
answer886
viewsHow do I import data from a spreadsheet in excel (csv) to an HTML table?
Hello, I am making a website, which contains a table, however the data from this table needs to be imported from an excel spreadsheet that I have saved here on my machine.. Can someone help me? If…
-
3
votes1
answer8865
viewsFind last filled cell in a range
It is possible to find the last filled cell in a range and paste a value into the next empty line below? I need a code to search the range ("B5:B35"). I used the following code, but after cell 35 I…
-
3
votes1
answer1679
viewsWhich excel function should I use?
I have a list of names of the masculine and feminine gender that I need to determine in the front cell what is the gender of the name. The logic that analyzes the name and says if it is masculine…
-
3
votes1
answer132
viewsCustom Line Chart - any tool
I need to create a line chart (python, R or even excel), where each line is a product category, the y axis is the sale and x is the time. If the sale is above the finish line, the line stays of one…
-
3
votes1
answer622
viewsHssfworkbook - How to copy one spreadsheet to another?
I have a spreadsheet of excel I need to copy some data into another spreadsheet. This old spreadsheet is like a "base", I need to copy only the header and caption part (with the cell style, in…
-
3
votes2
answers1370
viewsSpreadsheet to discover the ZIP List City
Good morning! I am trying to create a VBA adapted to a spreadsheet that I downloaded on the internet that separates all values of a zip code. I’d like to take the city and stick it next to the zip…
-
3
votes2
answers1314
viewsAutofill - How to select the second line
Guys, I got the following problem: I’m filling a cell with a formula and I need it to be duplicated for the others. So I’m using the code Selection.AutoFill Destination:=Range("C2:C329") Problem:…
-
3
votes1
answer98
viewsHow to Bulkcopy an excel file to an sql table
I wanted to make a bulkcopy from an excel file to an sql table. But you’re giving me this error when I try to send to sql: System.Invalidoperationexception: 'The Columnname indicated 'Transdate'…
-
3
votes1
answer928
viewsHow to save an XLSX (Excel) file instead of CSV?
Today I have the code below, which saves a file in CSV format. What I need to change to save in XLSX format (Excel)? public static void buildCSV(string filename = "resultado.xlsx") {…
-
3
votes1
answer947
viewsExport HTML table to Excel keeping styles
I would like to know how to export a table of my html code to excel keeping the formatting (colors, borders, etc). I am using the following function: <script type="text/javascript"> function…
-
3
votes2
answers3532
viewsCopy rows from a table that match one criterion and paste into another Excel sheet
Hello! I am something new in VBA and I have obtained what I want through the macros recorder. However, I think that in this case I will not get what I want through this resource. I will try to be…
-
3
votes1
answer526
viewsHow to "concatenate" multiple values entered by a user in the table in an Msg box?
I’ll try to summarize what I’m trying to do: I made a userform so that my user inserts data that will feed a table, he can put "n" information and the table will form according to the volume of data…
-
3
votes1
answer275
viewsIterate XML with VBA and pass data to cells
I’m starting to mess with VBA now and I have the following problem: I was able to make a code that makes a SOAP request for a webservice and returns me an XML with the data of a person’s electronic…
-
3
votes1
answer62
viewsExcel with Conditional Formula per month
I have this formula in the calculation column in the table: =+(K5+L5)*(1+8%) working! I changed the conditional calculation per month, example:…
-
3
votes1
answer98
viewsData validation
I am creating a database file and I have a data validation where the model matches its brand. I did a list type data validation from the table: With the following formula::…
-
3
votes1
answer95
viewsHow to delete lines from a spreadsheet after performing a filter using VBA?
I am having trouble deleting lines resulting from a text filter in a table. I recorded a macro that resulted in the following code: ActiveSheet.Range("$A$1:$K$161").AutoFilter Field:=2, Criteria1:=…
-
3
votes1
answer97
viewsHow to compare two string values with pandas?
Hello! I have two pandas dataframes and selected a column of each with ids. I want to compare the ids to see if the id of one dataframe is contained in another, but it does not have the same amount…
-
3
votes1
answer1636
viewsTextbox returning different decimals in VBA
I have a very simple project, but I have a problem that I cannot solve. I believe the problem is something related to language settings, but all the changes I’ve made so far have not returned the…
-
3
votes1
answer231
views -
3
votes1
answer52
viewsApply row-to-row formula within a table in R
I have a table where I need to apply a row-to-row formula to multiple columns, and the formula is: row value - mean(all column values) / standard deviation(all column values) is a normalization of…
-
2
votes1
answer2714
viewsHow to display registered values in a Google Drive spreadsheet in another via JS query
I have a table in Google Drive and I want to use Scripts to do what I want to stay in a more dynamic way. On Page2, I have the fields "Result" "Delay" and "Arrival" with their due results filled…
-
2
votes4
answers6360
viewsBreak row into table cell in CSV format to be read by Excel
I have the following code that inserts a value in an excel cell for export context.Response.Write("aa\r\nbb\r\nccc"); /r/n breaks the line but writes in the cell below, would like to break the line…
-
2
votes1
answer938
viewsVisual Basic Programming in Excel
Using Visual Basic Excel mode, I am creating a customer registration form. It has a button called "new". On this button it would add a value to the Code field that is in the excel spreadsheet.…
-
2
votes1
answer459
viewsConvert ASP.NET datatables to different Excel SHEETS
How can I create more than one sheets converting different datatable for excel? My code: DataTable dt = new DataTable(); dt = Tr.Get(); GridView x = new GridView(); x.DataSource = dt; x.DataBind();…
-
2
votes1
answer5772
viewsUsing the Excel Application object within Access
I am creating a VBA script that exports a table in multiple shared excel sheets in a specific directory. The problem is that Excel sends a warning to confirm the file save for each file. I would…
-
2
votes1
answer282
viewsExport Excel PHP Workbench Variable data
I’m having doubts regarding generating an excel with the query. <?php include("conectar.php"); $id = $_GET['id']; $arquivo = 'Não autorizado .xls'; First question is this: In the $file part I can…
-
2
votes2
answers746
viewsExcel printing with php and jquery
I am trying to print to excel a query presented in table with php and jquery in tag <tbody>. However it did not work. It presented in excel a wrong result with all the result HTML in a single…
-
2
votes2
answers1328
viewsExport php data to xls from a link
I’m making a link, that when the user clicks on it should generate an xls file. The link has the data-attributes and must pass these attributes to the.php page and generate the xls. I tried to do…
-
2
votes1
answer55
viewsExporting currency formatting with Excelbuilderjs
I’m using the Excelbuilderjs to produce an Excel spreadsheet on demand and offer as a download to the customer. Ideally, this needs to be done on the client, not on the server, and the library works…