Questions tagged as 'excel'

Tagged questions
0
answers

ASP.NET MVC Reports in PDF and EXCEL

Good afternoon, I would like to get references about better reporting tools in an MVC application that allow me to export the result to PDF and EXCEL. Currently, I'm creating a VIEW, filling a MODEL with the data, and making it possible to ex...
asked by 05.10.2016 / 16:27
0
answers

Calculation in Excel and PHP / SQL with different result

I made the calculation of a column in my worksheet and the value is X. However, when I perform the column calculation with SQL using SUM, or even in a loop with PHP, the value is different. The funny thing is that the values between SQL / PHP...
asked by 20.09.2016 / 22:32
1
answer

How do I paste text into the same Excel column?

I copy data from a PDF and I would like each line to be pasted all into the same "A" column, because then I have a macro that does all the splitting work into columns that works fine. On my computer, Excel sticks to a single column as soon as...
asked by 26.09.2016 / 21:03
1
answer

CONT.SES BETWEEN DIFFERENT LIBREOFFICE / EXCEL FILES

I'm using CONT.SES between different files , but I'm getting:    ERROR: 504. The formula looks like this: =CONT.SES('file:///C:/Users/jaciel.barros/Desktop/RELATÓRIOS/JANEIRO2016.ods'#$JANEIRO.$O$3:$O$75;"SIM";'file:///C:/Users/...
asked by 18.08.2016 / 17:57
1
answer

Error exporting DataGridview to DataTable

I'm trying to generate an Excel spreadsheet based on a DataTable, all data is in the given format, however the Data format is in the American standard ("MM / dd / YYYY"). Here is the code for the function: //Metodo que exporta um grid...
asked by 17.08.2016 / 20:48
1
answer

vba PasteSpecial does not work

I'm cropping the values from one worksheet to another. The clipping is done without problems, the data is going to the clipboard, but I am not able to paste. Code Private Sub CommandButton1_Click() Dim raizen As String Dim contador As Int...
asked by 16.08.2016 / 13:20
1
answer

Failed to generate TXT file by routine for printing in VBA / Excel

The form below is the code in VBA (Excel) below. ThiscodereferstoprintinganExcelspreadsheetofname" Printing " as shown in the figure below. By the parameters passed in each button, all the data that appears in this worksheet will be printe...
asked by 26.06.2016 / 03:24
1
answer

PHPExcel, select sheet when importing data to mysql

I want to import data from a worksheet but from sheet 2 and I'm not able to. I indicated sheet 2 (index 1) as active in this way, but always goes to sheet 1 (index 0): $ objWorksheet = $ objPHPExcel-> setActiveSheetIndex (1); What will b...
asked by 24.05.2016 / 15:04
0
answers

Transmit data from a list from one worksheet 1 to another list from worksheet 2 being sorted by the largest to the smallest of a numeric column

In worksheet 1 I have an occurrence list that has several columns from C to AI , I'm wanting to pass data from this list of column C6:C25 and AI6:AI25 to worksheet 2, to columns D6:D25 and E6:E25 , respect...
asked by 19.11.2015 / 14:18
0
answers

Export Table in EXCEL with PHP

I'm exporting my data to excel, but when I export the accents do not return correctly, this is my script: <?php include_once "bancodedados.php"; $table="smt_cadastro_sociedades"; $select = "SELECT * FROM ".$table; $export =...
asked by 20.10.2015 / 14:00