Questions tagged as 'excel'

Tagged questions
1
answer

Generate Excel in SQL SERVER [closed]

Good afternoon. I need to generate an excel file by SQL SERVER. And I need to specify the data type of the cells in that file. For example, in value cells, set the data type to "R $" for example. In cell with percentage, already set cell d...
asked by 17.10.2016 / 22:20
2
answers

#REF! When you exclude cells in another worksheet

Good morning, I have an Excel file with two spreadsheets, in 'Plan1' all data is deleted, and a MACRO I made, imports a TXT file and populates 'Plan1', inserting data and calculations. In 'Plan2' the data is fixed and takes as reference the d...
asked by 20.05.2016 / 15:34
1
answer

Obtaining data from excel and transforming into list, by Python

import xlrd def ler_arquivo(teste_termal1): tt1= xlrd.open_workbook('teste_termal1.xls', formatting_info=True) eajp60= workbook_r.sheet_by_index(3) Coluna_4=[3] Coluna_13=[12] return { "Ct":Coluna_4, "Sa":Coluna_13,...
asked by 11.11.2015 / 17:49
2
answers

How to create objects dynamically based on vector? (VBA / Excel)

I created two Labels dynamically based on a vector according to the code below, however, in the form only the last Label created (NewLabel1) remains, both the first (NewLabel0) and the Label that I used the base for the creation of the other two...
asked by 17.03.2016 / 02:57
1
answer

Add data from 2 worksheets and point differences

I have 2 excel spreadsheets, one has project management data from one fictitious company and the other the same data from a fictitious factory: PLANILHA 1: Empresa ------------------------------ Projeto História Data Esforço PROJ-1 PJ1-...
asked by 14.10.2015 / 19:13
1
answer

Add quarterly data into columns

I have the following question: I have 5 columns ... each with quarterly information; Consolidado 31/12/2006 31/03/2007 30/06/2007 30/09/2007 31/12/2007 .... Reserva de Lucros 12300 12300 646 646 3...
asked by 25.03.2015 / 20:44
1
answer

Excel Conditional Formatting

I have a question and I would like to know if it is possible since I am not able to. I have a cell that shows me a result (Cell D4) And I want the result to underline two lines. Example: If cell D4 is equal to "G4" Underline line X If c...
asked by 14.07.2014 / 16:00
2
answers

How to improve the performance of an xls file generator in my Delphi 4+ SQL Server 2000 application?

I have implemented the following procedure in an application made in Delphi 4, but the time to generate an xls file with Dataset data is 55 seconds and the dataset has approximately 50 lines. Any tips on how to improve performance? procedure T...
asked by 05.11.2018 / 16:27
1
answer

Close Excel after running vba Macro in Qlikview

Macro set obj = ActiveDocument.GetSheetObject("CH1") obj.Export "caminho_para_salvar_arquivo" And now I need to close Excel, I used the following command. obj.Close caminho_para_salvar_arquivo' And I get the error Wrong number of arg...
asked by 15.10.2018 / 22:34
2
answers

VBA - Read a .TXT file and manipulate its lines

I'm trying to make a Query generator using Excel (VBA), but I'm not able to manipulate some data inside a .sql file. Eg: Select * From Tabela t Where t.id = 1 <PROP> Whenever he finds a line that is written PROP he should swap for...
asked by 01.10.2018 / 17:55