Questions tagged as 'excel'

Tagged questions
1
answer

Oledb + excel + HDR = NO. How to make selects?

The thing is that I want to make Selects in Excel, in any possible way, I do not value interop since the sheet is dynamic, one day it can have 340 records, another day 20. What I'm trying to do is something kind: Select count(*) From [Sheet...
asked by 12.12.2017 / 16:49
1
answer

Create excel from a list that has a dictionary inside

I would like to know how to create an Excel file with the data inside a list that has dictionaries nested in Python. The structure of the data is as follows: xs=[{'x': 2, 'y': 1, 'z': 4}, {'x': 3, 'y': 15, 'z': 41}, {'x': 22, 'y': 10, 'z':...
asked by 25.08.2017 / 02:29
1
answer

How to filter a range of cells in VBA excel 2013

Hello everyone I am new to this and I am having problems in VBA Excel 2013. I need to filter a database on a sheet, according to values I have on another sheet of the same book, these values are in a range of cells. These values are constantly c...
asked by 11.07.2017 / 06:09
1
answer

Remove spaces when pasting into Excel from DataGridView

I want to paste the contents of a DataGridView in Excel. However, the content of a column, because each row has extra blanks at the end of the string, makes this column much longer than the content. Whereas I have this code to select what I w...
asked by 14.06.2017 / 16:20
1
answer

Read Excel file from Java Tomcat

I'm running a web application with Java and using Tomcat 8.5 to run it locally. My application has to read an Excel file and save the data in variables. I use the POI library, and when I execute the code without going through the server...
asked by 17.05.2017 / 10:15
1
answer

Run Replace command in VisualBasics to replace a formula

I'm trying to create a macro and I have problems trying to use the Replace command when it affects a formula in VisualBasics. My situation is this: In column L I have calculations of slope of different ranges: =PENDIENTE(G33:G6...
asked by 26.04.2017 / 10:19
1
answer

Create new excel document with asp.net from a template

I have to fill out a report in excel in which they ask for my name and ask some questions in which I must qualify from 1 to 5 my experience as a user, but I can not modify the original file so I have to create a new document excel from the docum...
asked by 12.04.2017 / 12:18
1
answer

Reminders if a cell matches a date in Excel VBA [closed]

I am trying to develop an alert that reminds people to send a weekly report when certain dates (which are selected in column BA) are matched with the current day. The problem is that my message box is not showing, and even though the code see...
asked by 14.03.2017 / 16:05
1
answer

Button that counts and adds data Excel VBA

I have to make a form that when I press a button I add a product to a table for a purchase ticket For that use the following code Private Sub AMERICANO_Click() Worksheets("Ticket_print").Activate Dim L As Variant Dim MyCount As Long L = Hoja2...
asked by 09.06.2017 / 08:47
1
answer

Copy a worksheet from one excel file to another

Hello, good morning, I have the following code. from openpyxl import load_workbook from openpyxl import Workbook wP =load_workbook(r'C:\Users\Arrontec\Desktop\Automatizacion\Request1_2.xlsx') wB =load_workbook(r'C:\Users\Arrontec\Desktop\Auto...
asked by 27.02.2017 / 16:42