Questions tagged as 'excel'

Tagged questions
0
answers

PHPExcel - 'Invalid cell coordinate o1'

I'm generating a code that can read both ".xls" (Excel5) and ".xlsx" files (Excel2007) and it's funny, because the process I've generated gets the data from the ".xls" file correctly, but without However, if I try to read the data of the same do...
asked by 01.09.2017 / 08:53
2
answers

Export to excel from mysql with php and keep zeros to the left

I have the result of a query mysql that contains numbers with leading zeros, which I must keep on exporting to Excel. example: in BD the number 000018 appears when exporting to excel in the cell appears 18 This is the fun...
asked by 31.08.2017 / 11:59
0
answers

Problem vba excel 2010 works fine in step-by-step mode and not when executing f5

Dear, I have the following procedure to make labels with tbarcode when I execute it step by step or if I delete and re-add the object tbarcode10 works ok, when I execute it from button no. It has a loop to modify the data that crea...
asked by 25.08.2017 / 15:52
0
answers

Pass data from JTable to Jtable with saved auto

Good friends, I present a problem in my code, the question would be: How do I make it so that when passing data from one table to another, those that were already there are not deleted? I am passing a selected row from a JTablePendientes to a...
asked by 14.09.2017 / 18:39
1
answer

administrator of django custom actions

I'm trying to do an action for the Django-admin (trying because I'm new to this), but I can not get it to appear in the dropdown that says "Delete Selected Data / s" My goal is to import the data of a file previously uploaded with FileFiel...
asked by 18.08.2017 / 12:35
1
answer

export reports.jasper (ireport) in excel format

I have not been able to find the solution to be able to export a report to excel. I managed to export it in pdf format in a dynamic web project in eclipse. File reportfile = new File (application.getRealPath("empleado.jasper")); Map&l...
asked by 22.08.2017 / 23:47
0
answers

SSIS does not generate Excel working with a large number of records

I'm having a problem with an SSIS, which basically retrieves the data from a table and exports it to an Excel. The problem is that when I work with a limited number of records (1000 records) Excel generates me without problems, but when I remove...
asked by 09.08.2017 / 13:01
1
answer

ReportViewer problem with time format when exporting to Excel

I schedule with Asp. Net and C #. I have several reports in which columns of a Tablix with information about times appear. My problem is that when exporting to Excel this report does not let me operate with these times. If I have a Tablix...
asked by 18.07.2017 / 07:11
0
answers

Add rows with macros in EXCEL without having to set a base row to generate the others

I made the following code in VBA (visual basic for application) in EXCEl so that through an associated MACRO, it can generate rows from "copy" a "base" row. The code that I have elaborated is the following: Sub Afilacalcderegulacion() Active...
asked by 17.07.2017 / 17:33
0
answers

Pacman in visual basic for applications

I have a drawback I'm doing pacman in visual basic of excel , what I have is that when I press the keys the pacman moves me the image. I have problems with the walls issue, I have the code so far Select Case KeyCode Case 37 '...
asked by 02.07.2017 / 04:45