Questions tagged as 'excel'

Tagged questions
1
answer

excel is not recognizing the range numbers

This is the spreadsheet for calculating the tax due due to billing: Total Gross Revenue in the last 12 months A B C D 1 Alíquota Faturamento 2 - 18...
asked by 21.05.2017 / 01:27
4
answers

Excel transpose row to column and preserve columns and replicate them online

Good morning! Next, I have a csv as follows A; B; C; D; 1; 2; 3; 4; 5 E; F; G; H; 6; 7; 8; 9; 10 The columns of letters have a regular structure, and those of a number not but it could explode them and put them in columns but it will...
asked by 10.05.2017 / 16:59
1
answer

Error message when opening exported excel file in PHP

I use the following code: $this->excel->getActiveSheet()->setTitle('Matemática'); //set cell A1 content with some text $this->excel->getActiveSheet()->setCellValue('A1', $opcao); $this->excel->getActive...
asked by 18.04.2017 / 16:11
1
answer

File Download - Excel - Firefox

I have the download link for an xls file. Every day I need to DOWNLOAD this file (I can only access through firefox), SAVE in a folder to feed my spreadsheet (the spreadsheet is "linked" in this file.) I need a macro to do: download this file (t...
asked by 07.05.2017 / 15:39
1
answer

How to assign the value of an Excel column in an SQL statement

I was able to connect to my MySQL Database via ODBC, and display the information I need via SQL command, but I would like the contents of a particular cell in my worksheet to be in that SQL query, I get this: Showonlythenameoftheclientaccord...
asked by 10.04.2017 / 17:03
1
answer

When I refer to more than one column using FormulaR1C1

Good morning! I'm having trouble referencing more than one column in excel using VBA, for example: Stock! A: G and I create the macro, and it generates for me Stock! C [-6]: C , I did not understand how it when I migrate for FormulaR1C1...
asked by 30.03.2017 / 16:01
1
answer

Copy cells to another worksheet if it does not exist

In the "BASE" worksheet, enter various customer data (NIF, name, address, telephone, email). I have a "DATA" worksheet where you have a list of multiple clients. I need to create a button in the "BASE" worksheet that copies the client data to...
asked by 30.03.2017 / 13:18
2
answers

SQL Query VBA Excel

Good afternoon! I have a problem with an Access query via form. The form is from the Excel vba, which connects to the database. The full code is below. This is the button code. Clicking it validates which of the two buttons is marked...
asked by 28.03.2017 / 16:58
0
answers

Possible block in file creation

Hello everyone, I'm testing a system in java that generates forms in excel but on the server it works it quietly generates the report but when I share the folder and try to access from another place through this folder, it does not generate the f...
asked by 23.03.2017 / 12:45
2
answers

Conditions SE nested

I would like to create an SE formula that uses the following conditions: 1-Se A for maior ou igual a 1 e menor ou igual a 3 devolve B, caso não 0 2-Se A for maior ou igual a 4 e menor ou igual a 6 devolve B, caso não 0 3-se A for maior ou igua...
asked by 22.03.2017 / 11:39