Questions tagged as 'excel'

Tagged questions
1
answer

Download html table with vba excel

Hello everyone and thanks in advance. I'm trying to download a table to excel from the page mismarcadores.com. I've got a macro on the internet. The problem is that the html tag of the table has no ID, and whenever I execute the macro, the...
asked by 02.08.2018 / 20:42
1
answer

EXCEL recursivity

Good I have the following query, what I want to do is compare the absolute difference between two columns, where one column is full of data and the other lacks some, so the absolute difference of the column where it lacks the same data of the da...
asked by 27.12.2017 / 14:40
1
answer

Python dynamic tables

I receive a report with this data every day: ALL the values of the headers can change although the Dates field is always going to stay the same for each client, to which I refer: What I need is that in my file called Data.xlsx...
asked by 21.12.2017 / 13:40
1
answer

read from the first page of an excel

I'm doing a project that takes the data of an excel with several tabs (tab per year) and I implemented it in the table, but it turns out that when I send it read from the excel just read me the Last page, I do not know how to make you read all...
asked by 21.11.2017 / 18:40
1
answer

How to list my databases in EXCEL with VBA

I'm trying to dig deeper into the connection from VBA using Excel versus MS SQL. All right with the forced connection putting all the parameters in the data of the macro (name of the server, database, etc.) But I would like to do something mo...
asked by 26.12.2017 / 13:08
1
answer

My macro does not run completely

I'm doing a macro that consists of deleting duplicate data from a column in excel, (keep the first data and delete the remaining data), the problem is that I have to execute the macro many times to perform the task completely, this is my code, t...
asked by 29.09.2017 / 05:52
1
answer

Copy a sheet with PHPExcel

Good morning, I am working with the PHPExcel library to duplicate an Excel spreadsheet. I'm only interested in its content, its format is not. The first thing I do is open the Excel file: $archivo = $_FILES['fichero_usuario']['tmp_name']...
asked by 31.08.2017 / 09:51
2
answers

Formulas conditional excel

Someone knows how the conditional format works in excel, I mean internally: I have the following information: And in the conditional format it says: How do you calculate the percentage values to be able to color the indicator?...
asked by 25.08.2017 / 18:48
1
answer

Import an xls or csv without Django model

I have been researching and can not find a way to import a file either xls or csv without having a model, I am trying to import files of this type into the database but they could vary in number of columns unexpectedly there is way...
asked by 15.08.2017 / 15:12
1
answer

I need help with a project in C #

Good, I'm doing a project in windows form and what it does is upload an excel file pass the data to a dataGridView and save them in a MySQL database, the problem is that this excel shows data of a cycle of 4 months and this is the last month the...
asked by 10.05.2017 / 02:35