Questions tagged as 'excel'

Tagged questions
1
answer

Excel Conditional Format Icons, without Conditional Format

I want to occupy the icons of the conditional format, such as the green and red flag; but without occupying the conditional format. The idea is: If numero <= 0 Then 'rt.Interior.Color = RGB(0, 255, 0) 'Aquí va una Bandera Verde Else...
asked by 20.12.2016 / 22:31
1
answer

Filter data from a CSV table

I have an ASCII file and this I do the conversion from excel and I separate it by spaces or also with commas. But I want to filter only some data with all its row that have a common pattern (9999) and based on this create a new table that con...
asked by 25.09.2016 / 04:23
2
answers

Excel Horizontal

How can I do it so that, from the moment the Excel is downloaded and I open it, the orientation of the page is horizontal? I tried to put this from the beginning of the code, but it does not work. $objPHPExcel->getActiveSheet()->getPa...
asked by 27.12.2018 / 17:52
1
answer

HYPERLINK ERROR "The directives of your organization prevent us from completing this action for you"

Today I'm getting an error in Excel when I want to go to a Hyperlink that I created to open a folder. I have read that I have to put As default browser Internet Explorer, I already have it but I keep giving this error. I have not changed anythin...
asked by 20.05.2018 / 20:22
1
answer

Next and Previous buttons to navigate between cells with a yellow background

I would like to ask your help to make two navigation buttons, in the "next" button and the "previous" button, the thing is this: I have this search engine And each time the user clicks the "Next" button the program should go to the next...
asked by 23.04.2018 / 16:43
1
answer

How to compress an XML file in ZIP in VBA Excel?

I'm trying to compress an XML file into a ZIP file and I'm using the code below, but I'm running into the following error Indicate the error on this line Shell.Namespace(zipFile).CopyHere (xmlFile) Code: Sub CreateZipFil...
asked by 07.03.2018 / 19:19
3
answers

Multiple excel operations with Python

I have an excel file where I keep information, more than 10,000 data. I need to be able to realize 1 massive account that is a division between two cells. The problem I have is that I do it but not for all the data. To this I mean that I have al...
asked by 15.01.2018 / 13:27
1
answer

Problem subtracting dates in excel

I have a problem wanting to make a difference between two dates to know the days between them. These on the one hand 3/15/17 17:58 3/15/17 17:57 3/15/17 17:55 and on the other 2017-03-29 00:05:49 UTC 2017-06-15 00:40:49 UTC 2017-03-15 01:...
asked by 10.01.2018 / 05:55
1
answer

Delete rungs from a Python csv

With the following code I convert an XLSX into CSV. I need to delete the first 10 lines of the resulting csv. How could I do it? # encoding=utf8 import sys import xlrd import csv reload(sys) sys.setdefaultencoding('utf8') def csv_from_excel...
asked by 20.12.2017 / 18:17
1
answer

Configure ViewResolver with Spring4

Good morning everyone. I am developing an application with Spring4 and Maven in Java. And I want to add an option to export the data of a table to an excel sheet, using Apache POI. The problem is that I do not recognize well the mapping...
asked by 15.11.2017 / 12:45