Questions tagged as 'excel'

Tagged questions
1
answer

Update the values of a book that I am going to copy info

I have this macro which copies the information from one book to another through the vlookup function, the macro works only when I paste the values from one book to another I open a window to select the destination book for update the values of t...
asked by 15.03.2017 / 06:40
2
answers

problem when downloading excel generated from java

I have a web application created in java I use the Apache library poi to generate an excel of a query, when I run the application from the netbens the excel file is perfectly generated, but when I deploy the war in the tomcat apache to execute i...
asked by 08.03.2017 / 06:46
1
answer

create excel in java by consulting in MySQL

I'm trying to create an excel file using a mysql query, what happens is the following I do the sql query with the data I need to make a sums and divides then I add all those results to an arraylist what is not how to do to get each of these data...
asked by 08.02.2017 / 17:09
2
answers

Macro to find and replace words in Word from an Excel list

I have made this macro to search and replace words from a specific file, which in this case is a Word document. My query is: How do I make the content of an excel list instead of a word document? This is the code: Sub ListaDeBalanceEs...
asked by 18.01.2017 / 16:14
1
answer

Error NoClassDefFoundError When converting .xls to .xlsx

I have an Error wanting to Convert this file with a method of the following class: public class ProcesaArchivo { UtilArchivo util = new UtilArchivo(); Path currentRelativePath = Paths.get(""); String s = currentRelativePath.toAbsolutePath().to...
asked by 14.12.2016 / 18:40
3
answers

Error when wanting to pass a gridview to an excel file

I have my gridview defined as well <asp:GridView ID="GridView1" runat="server" AllowPaging="True" DataSourceID="SqlDataSource1" Width="976px"> </asp:GridView> and I'm trying to pass the data to an excel in the following...
asked by 23.11.2016 / 06:29
2
answers

Function = TEXT (cell; "hh: mm") Excel Visual basic

Dear, I need to make a macro emulating the function = TEXT () of EXCEL in vb. The idea is that by having cells with hours (7:55) the function vb transforms me to 07:55. Usually for this I use = TEXT (cell, "hh: mm"), this transforms it. I nee...
asked by 06.07.2016 / 23:51
2
answers

PHPExcel with many records does not work, what can it be?

When wanting to export a table with PHPExcel, everything works fine when there are few records, but when there are more than 3000 records, it does not download the excel file, it remains blank, does the same thing happen to it?     
asked by 21.07.2016 / 23:09
0
answers

When I want to update an issue of the jira with visual basic my excel crashea

introducir el código aquí sFechainicio = 2018 - 6 - 5             sFechafin = 2018 - 6 - 5             sLabel="a"             sName="randomname"             sProject="updatetest"             sComponent="SPR"             sSummary="qqq"         ...
asked by 02.01.2019 / 09:32
1
answer

Pass item from a Listbox to a Label

I have a program that has a Listbox1 on Form1, and I want that when I press the Modify button, the form is closed and the Id item goes to a Label1 on Form2. I tried using the Userform_Load but I do not know how to assign the selected row of L...
asked by 27.12.2018 / 18:55