Questions tagged as 'excel'

Tagged questions
0
answers

Problems generating Excel report with PHP

I am trying to generate a report from ORACLE using PHP. By clicking on the "generate excel" button, you have no problem bringing me an .xls. The problem is that the .xls file does not bring the columns separated by cells. This is the cod...
asked by 27.12.2018 / 16:09
0
answers

Send a Listbox data from one form to a Textbox from another form

I have managed to pass a selected data from Listbox1 of a Form1 to a Textbox1 of a Form2 with the following code: Private Sub btnModificar_Click() If Me.Listbox1.ListIndex < 0 Then MsgBox "No se ha elegido ningún registro", Else Dim...
asked by 27.12.2018 / 22:34
1
answer

Openpyxl boxes with formulas

When I want to get the value of a box that contains a formula    box.value   I get the formula and not the number inside the box How can I refer to the number inside the box and not the formula inside it?     
asked by 24.12.2018 / 03:55
0
answers

Numerical format in SSRS

Hello Good morning to all (my keyboard is in English so I do not have to put the tildes sorry), I wanted to ask you a question about the SSRS report builder. Notice that I have these numbers: 652298433 422185043 But they have to look lik...
asked by 21.12.2018 / 15:00
1
answer

Excel generation with Apache POI, do not write in the same line in different cells

I am currently working on the generation of an Excel, this is done by supporting me from Apache POI. I found myself with a problem when writing the information in Excel, this is because with the code that I'm doing I can not write two different...
asked by 03.01.2019 / 22:19
0
answers

change column name when exporting datagridview to excel in c #

I have a datagridview that I fill by a query, the query returns values with alias, itm and I rename it as a product when exporting it, but when filling my excel it grabs the aliases of the query instead of the names of the datagridview column. a...
asked by 20.12.2018 / 18:50
1
answer

Read the calculated data using formula in Excel and pass it to Jtable

I have already solved the export of an Excel sheet to a Jtable in Java. The problem arises in Excel cells that have been calculated using formula. In these cases, the Jtable does not interpret the format and the export is interrupted. Do you kno...
asked by 20.12.2018 / 18:52
0
answers

Execute query and assign values to excel columns

I have a problem and I do not know how to execute a query and pass the values to the respective columns, this I do to generate an excel. I use the library PHPExcel . Query: $query = 'SELECT i.description_item,i.quantity,u.name_unit,i....
asked by 18.12.2018 / 19:17
0
answers

Excel Macros - SubIndice out of range

I am developing a Macros in Excel that takes web addresses from a range of defined cells and makes a query, but when I take the address and make the query it shows me an error message    "Subscript out of range". This is the code I am wor...
asked by 26.12.2018 / 21:46
1
answer

Modify Excel format exported by GridView

I'm doing a project in which I upload data to my GridView (Inserted Data) from my Database. I export my GV in an Excel with this code: private void ExportarGridExcel() { int num = 0; Response.Clear(); Response.Buffer = true; R...
asked by 07.12.2018 / 23:13