Questions tagged as 'excel'

Tagged questions
1
answer

Excel in php report

aqui es el que genera el reporte php <?php require "../conexion.php"; $mos =""; if(($_GET['fechaini']=="") && ($_GET['fechafin']=="")) { $consulta=""; }else { $consulta="AND s.fecha...
asked by 15.11.2018 / 21:30
0
answers

call object with variable name excel vba

I want to make a block to call several buttons according to a variable. My idea (which is not correct) would be this: Private Sub Eliminar() num = Range("z1").Value ActiveSheet.Shapes("figura" & num).Select Selection.Delete...
asked by 13.11.2018 / 00:38
1
answer

Problems in Excel sums

It turns out that I have a file in which I fill a form and I fill in the tables of an Excel document by day (The day is indicated in a field of the Excel form). These tables generate data graphs. Now, I want to group what I generate in my tables...
asked by 12.11.2018 / 10:54
0
answers

Date conversion problem using Excel VBA

Hi, I'm doing a macro that changes a whole column that is dated dd.mm.yyyy to dd-mm-yyy, and I used the following command: Range("E:E).Select Selection.Replace What:=".", Replacement:="-", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase...
asked by 14.11.2018 / 20:16
1
answer

I can not delete a column in Excel 2016. Memory Error

When trying to delete an Excel column, I get an error that says "There is not enough memory to complete this action". What's happening?     
asked by 16.11.2018 / 17:52
1
answer

How do I execute an action when I download a direct file in c #?

What I'm doing is a download of an Excel file when I find any record that already exists in the bd, this is mainly responsible for detecting it, not saving it and downloading an Excel indicating the repeating records, the problem begins when apa...
asked by 16.11.2018 / 18:36
1
answer

Excel filter - Ruby on Rails

I have a product form, created with scaffold , I export my records normally to my excel with the current configuration of csv and excel in Ruby on Rails; I want to know if there is a way to export only the products that I want or determined b...
asked by 16.11.2018 / 17:36
0
answers

configure JProgressBar when assigning the .xls to WorkbookFactory poi java

I am using the Apache POI library in a JAVA project to work with Excel files and I need to show the load percentage in a JProgressBar when this line is executed: libro = WorkbookFactory.create(new FileInputStream(ruta)); Note: I already kno...
asked by 31.10.2018 / 23:13
0
answers

How can I compare a txt with an excel and that this txt be traced line by line?

With a macro that I made I can perfectly pass a txt to excel from a route of choice. The problem arises that within the EOF function to get to the end of the txt I know only two instructions Line input and Input. Both read me line by line txt an...
asked by 25.10.2018 / 22:56
1
answer

Get cell value on the left Excel with VLOOKUP

I have a sheet with several sheets, where when writing a text in cell B20 of sheet 1, in cell A20 of that same sheet the value 1 must appear. These texts must be written in the range of cells from B20 to B25 and their values (quantities) in the...
asked by 22.10.2018 / 21:21