Questions tagged as 'excel'

Tagged questions
1
answer

How to use Excel subtraction in a set of numbers?

I want to subtract all the values from this small table, but if I have 100 different values, I would have some formula to summarize all the values in the same way as the formula sum, EX: = SUM (B3: B8), without specifying cell by cell? For examp...
asked by 18.11.2018 / 00:37
1
answer

Lines in export excel

I'm exporting a listing to excel, but when I open excel it comes without the tabs. <?php require_once '../../classes/xajax.inc.php'; $db = new SqlSrv(); //$sql = "SELECT * FROM cad_pessoas WHERE matricula = '$matricula'"; $sql = "SELECT...
asked by 13.11.2018 / 18:55
1
answer

How to display separate characters from different sequences by skipping spaces in Excel

I want to display only the red numbers of the sequence, but this formula only displayed the first number specified and the other after it or before it, I wanted to display jumping in any number whatever its position, in order to use the auto-fil...
asked by 23.10.2018 / 00:10
1
answer

How to "clean" a csv file with Python?

Hello! I am extremely new to programming, so I apologize if I can not explain what I am trying to do or if my code is very wrong. I have a recurring task in my job which is to open a list of restaurants in Ifood, collect the prices of each of th...
asked by 18.10.2018 / 15:32
1
answer

Open Excel worksheet and copy data into VBS

Hello, I have a simple spreadsheet (3 cols and 2 rows) and I'm trying to create a script to open it, copy its data and insert it into another one. Path = "C:\Users\user_name\Documents\excell\planilha1.xlsx" Set objexl = CreateObject("Excel.app...
asked by 29.11.2018 / 18:17
1
answer

Read multiple sheets xlsx file with PHP - PhpSpreadsheet

I have a file in xlsx format with two spreadsheets and I need to read the data in PHP to create an import script in the database. I am using the PhpSpreadsheet library to read the files. I can do it when I only have one worksheet in the docum...
asked by 03.09.2018 / 04:30
1
answer

Write in the spreadsheet from the last line without writing

I'm trying to write in an excel spreadsheet from the last line written without deleting the content that already existed, I've been able to pick up the last line and write from it, but when I type it deletes what was previously. I used an IDE to...
asked by 03.09.2018 / 16:57
1
answer

How do I make a list of clients appear in a search from the name in Excel? [closed]

I have a list of clients; I want to do a search where you enter part of the client's name and then all clients that have that name appear. Example: Customers' Rationale: João da Silva ME; Mariazinha Me; João Vitor ME; ... Search: John T...
asked by 05.10.2018 / 21:25
1
answer

Date orders of a reference in the middle of other dates and references

The situation is simpler to understand with a hypothetical scenario. Imagine that I bought 3 pieces: Order A Order B Order C. The supplier, as it did not have everything ready, divided the delivery of the pieces into 3 Tax Notes:...
asked by 16.08.2018 / 15:29
1
answer

PROCV between two worksheets

The result that I show in the authors column of the production worksheet is the name of all authors who have written that discipline. I'm using the following function =PROCV(C8;'Remanejamento'!C3:D55;2) but it does not return all the...
asked by 16.08.2018 / 20:28