Questions tagged as 'csv'

Tagged questions
1
answer

How to join two csv files in R?

My problem is this: I have two csv data files with the same number of columns and the same column names (see below). I ask you to read the files as follows: > dados_1 <- read.csv("Teste_01.csv") > dados_2 <- read.csv("Teste_02.csv"...
asked by 09.10.2016 / 20:07
1
answer

Javascript - Export to csv

How do I export an html table to a CSV file? In my code below I'm saving the csv file, but when opening in excel it does not display the column divisions. I would like to export directly to CSV. But I can not find any way to do that for ch...
asked by 18.02.2015 / 20:35
2
answers

Create CSV file from PHP

I want to create an XSV file from PHP. What I want is to be able to create columns and give background color to an element for example. I have the following: <?php header("Content-type: text/csv"); header("Content-Disposition: attachment;...
asked by 06.08.2014 / 17:04
1
answer

Export CSV data via JS

I have a data set in the database in my back end , and I need to create a button on which the user will click to export this data in CSV format. But I've never done this kind of event in JS. Can anyone help me?     
asked by 14.12.2017 / 21:44
1
answer

How to import a csv file into MySQL?

I'm starting my studies in MySQL. I decided to install MariaDB 10.1.14 on CentOS. I want to create a database from a .csv file with approximately 166 million rows. I searched for tutorials on the internet, but it seems they all assume that the u...
asked by 20.07.2016 / 20:46
1
answer

How to import CSV into Symfony2

I am trying to create a generic form to import the CSV the $ data represents a complete line of csv data. I'm trying to generate a response to register the data using form public function save(\Symfony\Component\Form\Form $form, $data ){...
asked by 20.03.2015 / 11:56
2
answers

Generate csv file in php [closed]

Hello everyone, I'm trying to create a query in php in the mysql database to generate a csv file according to the code below. The problem is that the one that would download the file is presenting an error, I have reviewed it a few times and I d...
asked by 04.06.2016 / 22:12
2
answers

Remove the last comma from an array of a While

I'm trying to remove the last comma from an Array but I can not. I have a CSV file in which I read and retrieve an array with a code to be used in a Where of a sql Query. I am using substr ($ number_Aut, 0, -1) but it is not working. Fol...
asked by 19.06.2017 / 19:37
1
answer

Format csv via php

I have the following code, where it generates a csv spreadsheet. <?php require_once ('dbacess.php'); // output headers so that the file is downloaded rather than displayed header('Content-Type: text/csv; charset=utf-8'); hea...
asked by 11.05.2018 / 17:16
3
answers

Multiple lines in a ShowMessage in Delphi

I need to trigger an error message if the user tries to insert invalid codes into a temporary table in the grid . The codes come from a .txt . The codes triggered on the monitor are ok but the message is repeated n times as there are n in...
asked by 16.12.2016 / 22:10