Questions tagged as 'planilhas'

Tagged questions
1
answer

Excel: load list of names according to the selection of another list

At school I work with a file with class worksheets (the name of the worksheet is the class number, eg 100, 200, ...). I need to make a spreadsheet in this file to generate Declarations, where I need to select the Class, and do this load the n...
asked by 27.06.2018 / 14:33
0
answers

Apache poi how do I add file in excel spreadsheet

I would like to know how I do apache poi to add a file to the spreadsheet it created. The file type is a 150 KB .WAV. I have read the documentation but would like to see a simple example to understand better. Thank you.     
asked by 13.03.2018 / 13:40
1
answer

How to make a count of repeated arguments in R

I have a spreadsheet, I have to do some operations on the data, so I exported to the R and manages to select the important arguments, now I need to know how many repeated elements there are in a column: for example PRTR4: 4 VALE5: 20 . . ....
asked by 09.03.2018 / 21:03
1
answer

Auto complete when typing any part of the word

How can I autocomplete text by typing any part of an information within the ListBox using VBA? Example: When you type in "Santos" all options containing this word will be listed / displayed in the listbox.     
asked by 10.05.2017 / 14:55
1
answer

Join data from two worksheets in Excel

I have two spreadsheets in Excel. At first I have the following data, for example: ID | NOME -----|---------- 100 | Luiz 101 | Pedro 102 | Aline In the second worksheet, I have: ID | CATEGORIA -----|------------ 100 | Livros 10...
asked by 14.02.2017 / 13:50
1
answer

Sleep function or Wait locking worksheet in Excel

I'm 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 vba that takes the system time and makes a calcu...
asked by 17.10.2018 / 22:04
1
answer

Use VBA to delete rows with criteria determined by a cell

I need a Vba to do the following action: As soon as it is activated, read a specific cell and erase lines from another flap taking into account the specific cell as a criterion. Example: In Sheet1 I have two products: Blue Shirt A Blue Shirt...
asked by 19.10.2018 / 21:36
1
answer

VBA - Delete only last row of the table that contains a text

I have a somewhat specific question. I hope you can help me I have a worksheet that contains a table called "Activities". I have some form controls to fill in the same but I came up with the need to insert and delete rows from this table with...
asked by 05.09.2018 / 00:10
0
answers

Add earnings from the same employee

I'm trying to add up all the earnings of an official (cumulative sum), but I can not. The code is below: function teto() { var ss = SpreadsheetApp; //seta a planilha var planilhaAtiva = ss.getActiveSpreadsheet(); //torna-a ativa var...
asked by 15.07.2018 / 22:37
2
answers

script le field of emails in googledocs

Hello, I have a spreadsheet in GoogleDocs, which has a field with one or more emails, in this case, separated by commas. Script le field and send an email to the registered recipient in the field email. However, the email is only received by the...
asked by 18.05.2018 / 06:40