Most voted "spreadsheets" questions
34 questions
Sort by count of
-
3
votes2
answers1470
viewsNew Google Sites - Embed HTML, Javascript and Google Sheets
I’m trying to use the object "Embed" from the new Google Sites I select "Enter Code" option and put the code below and when executed the following error message appears: "Referenceerror:…
-
1
votes0
answers22
viewsApache how do I add file to excel spreadsheet
I would like to know how to use apache poi to add a file to the spreadsheet created by it. The file type is a . 150 KB WAV. I have read the documentation but would like to see a simple example to…
-
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
votes1
answer1233
viewsExcel: load list of names according to the selection of another list
in the school I work has a file with the class spreadsheets (the name of the spreadsheet is the class number. Ex: 100, 200, ...). I need to make a spreadsheet in this same file to generate…
-
1
votes1
answer2238
viewsVBA - Delete only last row of table containing text
I’m having a very specific question. I hope you can help me I have a spreadsheet that contains a table called "Activities". I have some form controls to fill the same but I emerged the need to…
-
1
votes1
answer2453
viewsPython - how to create spreadsheet in excel (with 100 columns)
Good afternoon! I already know how to create a spreadsheet in Excel by Python, when I know exactly which columns I need to create. But how can I make the creation of columns dynamic? for example: to…
-
1
votes0
answers18
viewsGenerate PDF from a Template with sheet data including graphics
I have a script that takes information from a spreadsheet, replaces the text in a "template" document and generates a PDF for later sending by email. See an excerpt of my code below: // Cria o novo…
-
0
votes1
answer1395
viewsJoin data from two worksheets in Excel
I have two spreadsheets in Excel. In the first I have the following data, for example: ID | NOME -----|---------- 100 | Luiz 101 | Pedro 102 | Aline On the second spreadsheet, I have: ID | CATEGORIA…
-
0
votes1
answer211
viewsWhen I refer more than one column using Formular1c1
good morning! I’m having problems when referencing more than one column in excel using VBA, for example: I make a selection of columns Stock! A:G and create the macro, and generate for me Stock!…
-
0
votes1
answer1105
viewsAuto complete when typing any part of the word
How can I self-cmplete the text when typing any part of an information inside the Listbox using VBA? Example: When typing the "Santos" all options containing that word will be listed / presented in…
-
0
votes1
answer1378
viewsGoogle Sheets - Sending Email
I have the following code that sends emails through a Google spreadsheet. function sendEmails() { var sheet = SpreadsheetApp.getActive(); var startRow = 2; var planMensagens =…
-
0
votes1
answer956
viewsWeb data query in Excel
work in a company and need to monitor the lifetime of printer toners daily... For this I created a monitoring spreadsheet, only I wanted a practical system, like this: When I insert the web address…
-
0
votes2
answers1013
viewsSubtraction with date - Google Apps Script
Expensive, I need to calculate how many days remain to reach the expected date. I’m getting the following values var dataPrev = row[4]; //26/01/2018 var dataNaoFormat = new Date(); //22/01/2018 I’m…
-
0
votes1
answer658
viewsHow to count repeated arguments in R
I have a spreadsheet, I have to do some operations in the data, so I exported to R and can select the important arguments, now I need to know how many repeated elements there are in a column: for…
-
0
votes2
answers68
viewsscript le email field in googledocs
Hello, I have a spreadsheet in Googledocs, which has a field with one or more emails, in this case, seperados by comma. The script reads the field and sends an email to the registered destination in…
-
0
votes0
answers38
viewsSum earnings of the same employee
I’m trying to sum up all the earnings of an employee (cumulative sum), but I’m not getting it. The code is following: function teto() { var ss = SpreadsheetApp; //seta a planilha var planilhaAtiva =…
-
0
votes1
answer1384
viewsSleep or Wait function catching spreadsheet in Excel
I am programming a macro in vba, which makes the connection to a sql server database and makes a select in a table and returns me the time of the last change in the database. I created a program in…
-
0
votes1
answer404
viewsVLOOKUP function does not work in Excel
I’m making formulas in Spreadsheets Google, but when making a conditional formatting is stating that the formula is incorrect. =VLOOKUP(C3; Concursos!C3:H5; 1; FALSE) All cells contain whole…
-
0
votes1
answer99
viewsHow to compare two columns and return the sum?
Personal talk, I have the following table below, what I want is that it adds the Price (Column D) of all books with the Situation (Column AND) "Sold". I know I can do with the PROCV function. But I…
-
0
votes2
answers4373
viewsUse VBA to delete lines with a cell-determined criterion
I need a Vba that does the following action: The moment it is activated, read a specific cell and delete lines from another tab taking into account the specific cell as a criterion. Example: In…
-
0
votes1
answer32
viewsDuplicate spreadsheet
Hello, I have a spreadsheet that contains some important data, I wonder if there is any to duplicate this spreadsheet automatically, so that I manipulate the data in a spreadsheet and when click to…
-
0
votes1
answer38
viewsHow do I copy information from a column in googlePlanillas without repeating data if they have repeated data?
i have a spreadsheet in which a column contains names, I need to copy this data to another column, but without copying the repetitions of the names, example: Coluna A Coluna C Américo Américo…
-
0
votes1
answer63
viewsSort Worksheet by something by clicking on "explore"
Good Afternoon everyone, I am trying to filter a specific spreadsheet. The idea is to filter a spreadsheet by a subject. By clicking Explore. Example "Worksheet to be automatically filtered" I put…
-
0
votes1
answer3450
viewsHow to read an excel table in pandas by skipping the first lines without losing information?
Hello, I have a problem to solve a little complicated, I have several xls tables in which I have to remove some data, these tables are with their content organized strangely... TEXTE TEXTO TEXTO…
-
0
votes1
answer49
viewsUpdate worksheet by another worksheet
I have two dataframes with identical columns, one being the database and another monthly updates. I need to update the database with these monthly updates. I thought of the following code:…
-
0
votes1
answer261
viewsI’m getting this error message >>> Typeerror: Cannot read Property 'pop' of null (line 5, "Code" file)
I’m trying in Google Sheets to sum the values of cells that have the same color background. The problem is that the code is returning me the following message: " Typeerror: Cannot read Property…
-
0
votes0
answers37
viewsdynamic table in Rstudio
I am using Rstudio and would like to transform a table that is in this format municipality affiliated to entities Antoinina yes Antonina nay Antonina Not Antonina yes Antoinina NI Paranaguá nay…
-
0
votes1
answer80
viewsInsert signature already made in macro VBA
I would just like to insert a signature made in Outlook itself with image and text in this VBA, but I do not know how. Follow the code: Sub Aplicacao_Fundo() Dim OutlookApp As Object, OutlookMail As…
-
0
votes1
answer18
viewsI cannot change cell format with . setNumberFormat in google app script
I made the following registration page. I need to pick up exactly the amount of zeroes I add to the registration field However, when this data is added to the spreadsheet, only a zero appears. I am…
-
0
votes0
answers9
viewsHow to Save File Inside Folder(Variable Name) Excel VBA?
am having trouble saving workbook in created directory Code to create folder Sub CRIARPASTA() Dim VAR As Object, NOVAPASTA Dim Nome As String Dim OS As String Nome = Worksheets(3).Range("f5").Value…
-
-1
votes1
answer369
viewsThe value of Function INDIRECT parameter 1 is "Income! D3:Q3". It is not a valid cell/range reference
I’m using the spreadsheet templates provided by google. However I’m getting this message: The value of Function INDIRECT parameter 1 is "Income! D3:Q3". It is not a valid cell/range reference.…
-
-1
votes1
answer1188
viewsFormula to return the date only with working days
Is there any formula I can use for the cell to return the date corresponding to the term? If I enter the date 03/01/2020 in the cell, I want another cell next to return the date with the calculation…
-
-2
votes2
answers82
viewsStandardize spreadsheets in open office
I have an open office spreadsheet file with 27 spreadsheets inside. All sheets are equal, 3 columns, title, nothing else. I need a way to format all worksheets at once. - line width - header color -…
-
-2
votes1
answer116
viewsConvert Cell to String type in Apache POI
How can I convert a guy Cell for String ? String datateste = row.getCell(5);