Questions tagged as 'excel'

Tagged questions
0
answers

Changing the format when exporting Datagridview to Excel

I have the following code to export to Excel, from my Datagridview. Private Sub EXPORTARToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles EXPORTARToolStripMenuItem.Click Dim exApp As New Microsoft.Office.Interop.Excel.Appli...
asked by 22.03.2018 / 14:59
0
answers

Export array to csv or xls with php and oracle

I need to be able to export an array to csv, please, the code: <?php require_once ("./conexion/conexion.php"); if (!$conn){ $msg = "Cannot connect to Oracle ".oci_error(); } else { $msg = "Connected to Oracle"; } $sql = 'SELECT *...
asked by 13.03.2018 / 19:04
0
answers

Optimize code in php and mysql with excel

I am receiving several fields from another form and based on them I generate a table and I have a button to generate the excel based on the generated table, this I do in reportExcel.php and after I send the query (with a echo) to ReporteExcel5.p...
asked by 27.03.2018 / 03:24
1
answer

How to export a data matrix?

What I need to do is something complex so I will try to explain myself as best as possible ... It turns out that I have this form In this form, the user must first select a chapter, then a subchapter and finally an item, as soon as t...
asked by 05.03.2018 / 14:16
0
answers

Does not correctly insert field type Date in BD

I make a massive import module of an excel.csv file but in my date field (DATE) it does not insert the data correctly, it only inserts 0000-00-00 , the other fields in the import do it without problem it is only in the date field. Thank...
asked by 12.03.2018 / 09:32
2
answers

Export excel from postgres query in php

I need to export the result of a query that I'm printing on a table in php, I currently have two tables (queries) in my page that are shown at par but I need export to an excel file the result of a. this is my query <form type="submit" m...
asked by 02.03.2018 / 21:36
1
answer

DAX: I need CALCULATE not to be affected by database filtering

I have the following calculation in a database: SUM:=CALCULATE(SUM([Data]),FILTER(ALL(Table[Month]),[Month]=[CURRENTMONTH])) Where [Data] is numeric, [Month] it's date (it's 12 months of the year), [CURRENTMONTH] is a calculat...
asked by 23.02.2018 / 19:41
1
answer

Modify Excel file with Python without losing Data Validation

I want to open with Python an .xlsx file that has several columns with Data Validation activated, change a few cells of columns without that attribute and save the file again (or copy it to another) keeping the Data Validation functionality as i...
asked by 13.02.2018 / 20:46
0
answers

Export from PHP to excel

When I export the data from my database in the localhost if it gives and saves the file and everything but at the moment of loading it to the server, the option no longer appears and shows me the data on the screen (I no longer see the document...
asked by 15.02.2018 / 05:31
0
answers

how can I improve this excel code

Sub Buscar_Numeros() 'Por.Dante Amor Application.ScreenUpdating = False Set h1 = Sheets("numeros") Set h2 = Sheets("formato") ' uc = h1.Cells(2, Columns.Count).End(xlToLeft).Column For j = Columns("F").Column To uc S...
asked by 15.02.2018 / 14:27