Questions tagged as 'csv'

Tagged questions
0
answers

Table of distances google maps api and python

Hello, I'm using the Maps API to check the distance between two points, so I have two local.csv files and .csv coordinates. The final goal is to know the distance of the locations for each of the coordinates. If there are 3 locations an...
asked by 28.04.2017 / 17:55
0
answers

How to export a table from postgres with column names to csv format with jdbc?

This is my code, which unfortunately does not export the column names: package net.viralpatel.java; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.sql.Connec...
asked by 10.01.2017 / 19:47
1
answer

CSV In Ruby - Doubt

Good afternoon guys, I'm having a hard time understanding how Ruby works with csv, I need to read a file and import the data from that file into a variable I have a file named die.txt so Id | Nome | Endereco 1 | Renato | Alameda das magnol...
asked by 09.02.2017 / 16:41
1
answer

Pass CSV content to an SQLite table

I have a CSV file with student records. I would like to upload these records to a aluno table in SQLite. How can I perform this operation?     
asked by 16.11.2016 / 21:37
1
answer

How to merge multiple Excel tables into one?

I have 3000 tables as in this example: IneedtomergethemintooneandI'musingthecommand:=ÍNDICE(TXT!$B$1:$B$200,CORRESP(MAIOR(SE(TXT!$A$1:$A$200="Last Name:",TXT!$B$1:$B$200,""),1),TXT!$B$1:$B$200,0)) The problem is that it just shows me the f...
asked by 12.08.2016 / 13:05
0
answers

how to validate a quantity of columns from a csv file in php?

I'm doing upload with a load data infile in php. In this upload you would need to do a validation of the number of columns that have the .csv file. If the amount is different from the amount that comes from the bank it blocks t...
asked by 13.07.2016 / 16:31
0
answers

Selecting and deleting random csv lines in python [closed]

I need to make a small python script that meets the following requirements: Open a csv file; Exclude from reading the first line and the first column, because it contains information that will not be necessary in this computation itself;...
asked by 24.07.2016 / 04:55
1
answer

Error displaying data on Highstock chart

I have a Highstock graph where I create a CSV from my database to then show this data in the chart, but it turns out that the graph only recognizes CSV if after CSV is created and when I open CSV . Also, it also...
asked by 29.04.2016 / 11:13
0
answers

Crystal Reports CSV Export Filtering by Date (C # MySQL)

I have a Crystal Report object that is bringing the records of a View from a MySQL database. I need these records to be exported to a CSV file and I got this with the following code: private void btnExportarCSV_Click(object sender, EventArgs e...
asked by 28.03.2016 / 00:17
0
answers

Use xls as data source

I have several spreadsheets with data. They have the first column as the table name. 1) Can you format a CSV with the first column as the table name instead of normally using the first row as the column name? 2) Can you read each of the sp...
asked by 18.09.2015 / 15:31