Questions tagged as 'excel'

Tagged questions
1
answer

Create flanges dynamically in excel

I am doing a project in MVC and would like to know if there is any way to create dynamic tabs in Excel according to filters and export it later. Example: If the filter only comes with "School" selected, it creates only one tab called School and...
asked by 29.09.2015 / 16:09
1
answer

Hide results in Excel

Good afternoon, guys. I have the following problem: I have several lines and each of them is protected with a different password for the edit, each one corresponding to a company unit. I need the values to be hidden for those who do not know...
asked by 24.06.2015 / 19:49
1
answer

EXCEL Paint a certain amount of cells

I have a worksheet that works as a gantt chart, which runs from day 01 to day 31, and my question is simple, based on the calculation of the day of an order, 12 days for example, how can I make the excel 'paint only 12 lines, from 01 to 12 for e...
asked by 01.06.2015 / 01:04
1
answer

Read rows and columns by Python, by excel

My question is if you have any resources so that I can read excel rows and columns. For example: I have experimental data in excel containing header in the first row having some 12 columns of data, then [1:12] it would only be the header, and so...
asked by 10.11.2015 / 18:10
1
answer

Create xls file and save to a folder

I have my file gerar_xls.php and you are creating a file .xls and I want to save it in a folder. What you are doing now is the file download. I have the following: header("Content-type: application/vnd.ms-excel"); header("Content...
asked by 24.09.2014 / 17:20
2
answers

Read more than one .xls file in python

I asked a very similar question a few days ago, but this time, I'm trying to do something much more generic. I want to get the information from line 0 and 1. The code below is complete, and is outputting the input.xls file correctly. import xl...
asked by 25.09.2014 / 13:47
1
answer

Dynamic data source of chart

I have a table in Excel, Tab_Visitas , which has visits per day of the month. WhatIwantedtodowasalinechart,butonlywiththedateselectedandthedatebeforetheselecteddate,typethis: Obtaining the dates I already have: DataSelecionada:= DA...
asked by 31.03.2014 / 04:44
1
answer

Excel can not read cell in VB code

x.Range("A1:z1").Select x.Goto Reference:="R2C4" verificaCel = x.ActiveCell.FormulaR1C1 if verificacel then I am not able to read the specific cell in the excel sheet, in which I will send the data to a database.     
asked by 04.10.2017 / 14:24
2
answers

How to create a macro that comes into the site and get the data from the last day?

Good afternoon, I need to access a website and grab the data from the last day and copy them to a folder in excel, the site is highlighted in the macro below but I do not know how to proceed to select the data and copy them in my worksheet ....
asked by 20.02.2017 / 20:57
1
answer

Custom Line Graph - any tool

I need to create a line chart (python, R or even excel), where each row is a category of products, the y-axis is the sale, and x is the time. If the sale is above the goal, the line is one color, if it is below, another color. It would be a way...
asked by 08.06.2018 / 16:37