Questions tagged as 'excel'

Tagged questions
0
answers

Error in SimpleExcel.php

Good morning, I'm trying to export an excel from the SimpleExcel.php library using the downloaded test folder from its official website but it tells me the following error when executing the file test/HTML/HTMLTest.php    Warn...
asked by 19.12.2016 / 23:38
1
answer

Conflict between SAP and Microsoft Outlook Reference 15.0 Object Library in Macro Excel VBA

I have a conflict in my macro, when I added the Microsoft Outlook 15.0 Object Library reference in VBA, all other SAP related macros do not work in the line of access code to the transaction. Does anyone know what can be due? This is the c...
asked by 24.10.2016 / 13:40
1
answer

Customize excel report generated with html and jquery

I am trying to export a common html table to Excel using Jquery. My script already prints the table, what I need is to personalize the names that appear in the headers as well as sizes of the columns, colors, etc. This is the image of my repo...
asked by 13.10.2016 / 22:26
1
answer

Export JTable to extensions .xlsx and .pdf

Good morning, I made a JFrame Form which has to export a jTable to Excel and PDF. You already export me but you export the 2 files at the time, so I want that when I select the Excel filter in the FileChooser, I export only in that extension, th...
asked by 20.09.2016 / 00:00
1
answer

How to get the address of an active cell within a for cycle? VB.NET (EXCEL / INTEROP)

Look, I have the following problem, I am doing a program in vb.net that reads a book and analyzes how many sheets it has, columns, types and detects errors in terms of type (for example, if there is a data in a cell of type text within a numeric...
asked by 16.09.2016 / 21:55
1
answer

Corrupt xlsx file when uploading via Java FTP

I'm trying to upload a file via FTP, the excel file apparently is copying it correctly, but when I open it, it says it's corrupt. Any ideas ?? public static void enviarArchivoFTP(String localFile, String hostFile) throws FileNotFoundExcepti...
asked by 26.10.2016 / 01:56
1
answer

Transform document xls / xlsx to html - without interop

I have a document xls and another xlsx already saved in bytes[] in my code and I need to pass it to html+css to be able to display it on a page. It is important to point out that I also need the css and that...
asked by 19.07.2016 / 11:00
2
answers

I can not import data from excel to mysql

I have the problem that I need to import data from excel to mysql, however I can not even with code and through the button that is in mysql, I also have the heidi application and it does not allow me to send me errors, I want to review what is i...
asked by 03.08.2016 / 03:22
1
answer

Change data format rows vs Excel columns

I will try to explain myself as best as possible ... I will even upload some images to tell you about a problem I have (maybe simpler than it seems) but I still do not know how to solve it ... It turns out that I have some data as follows:...
asked by 07.05.2016 / 06:35
1
answer

"SQL Server" Server Error "DELETE" and "INSERT" from Excel

I have created a procedure that first deletes the records from my table and then imports them from excel. DELETE tabla WHERE columna='dato' INSERT INTO tabla SELEC * FROM OPENDATASOURCE ('Microsoft.ACE.OLEDB.12.0', 'Data Sourc...
asked by 20.10.2016 / 01:32