I've got a PHP-based site where we allow users to upload a comma-separated text file of data to be imported by some server side scripts. However, sometimes we need to adjust the column order of the data that is uploaded, and it would be immensely helpful if we could identify the columns in the CSV file before the upload takes place. The...
Hello I have a VB application which extracts data and creates 3 CSV files (a.csv, b.csv, c.csv). Then I use another Excel spreadsheet (import.xls) to import all the data from the above CSV files into this sheet. import.xls file has a macro which opens the CSV files one by one and copies the data. The problem I am facing is the dates in...
I'm trying to write an import rakefile for Redmine. It uses ruby on rails. I'm not a rails developer but we do like using redmine for project and issues management. require 'rubygmes' require 'fastercsv' # csv issues import for redmine # Will convert a csv into a issues bulkloader into redmine # Column names # row[0]=Nb Number,row[1]=P...
I know this question has been asked before, but I ran into a problem. Oddly enough, when I execute this function, it includes the html of the page that the link you select to execute the function. function exportCSV($table) { $result = mysql_query("SHOW COLUMNS FROM ".$table.""); $i = 0; if (mysql_num_rows($result) > 0) { ...
I am using an ASP page where I have to read a CSV file and insert it into DB table "Employee". I am creating an object of TestReader. How can I write a loop to execute up to the number of rows/records of the CSV file which is being read? ...
Hi, I have data in MySQL. I am sending the user a URL to get their data out as a CSV. I have the e-mailing of the link, mysql query, etc covered. How can I, When they click the link, have a pop-up to download a CVS with the record from MYSQL? I have all the info to get the record already I just dont see how to have PHP create the CSV ...
I am using Java Struts, sending it to user using the following codes response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-Disposition", "attachment;filename=" + fileFullName); Firstly I hope that this is the correct place for my question... :) I hope that you can help me. The error message I get when I tr...
I am looking for a solution or recommendation to a problem I am having. I have a bunch of ASPX pages that will be localized and have a bunch of text that needs to be supported in 6 languages. The people doing the translation will not have access to Visual Studio and the likely easiest tool is Excel. If we use Excel or even export to C...
I am new to MySQL and PHP(as you can probably tell) and I was wondering if anybody knew an easy way to import a CSV file into a MySQL table. "There are any number of ways to input csv into mysql depending in what kind of access you have, if you can use the mysql client directly there is a command to load delimited data, som...
I'm using the CsvReader library in my Windows Forms application, which is coded in horribly messy VB (I've recently taken over the project.) I'm currently capable of reading semi-colon separated files without quoting, but I'm having a problem: most of the input has quoted fields, but includes unescaped quote characters within the field...
how to import the data/files in csv format to excel vba in a much faster way? so far,i could get the files n display in excel but it is one by one. this will take a lot of time. how do we make it in faster way? ...
hi all i opened a csv file and copy the contents. i activated an excel file and have the copied contents from csv file pasted into excel file. now,how do i close the csv file programmatically? ...
Related to this question, how to save many different csv files into one excel workbook with one sheet per csv ? I would like to know how to do this programmatically in Java. ...
Hi, When a user clicks on a button on the winforms application, I will generate a CSV file. I then want to ask the user to either save the file to disk OR open the file. How can I do that? Note: I am just generating the file in memory, not writing it to disk until the user selects the path to save it to. ...
Hi, Creating a CSV file in a winforms application, it is to be improted into Excel. The file output looks like: "header1", "header2", "header3", 1,2,3, 4,5,6 What should I use to signify a newline character when generating the CSV file? ...
I have a CSV file that has a column that contains strings that look like integers. That is they should be dealt with as strings, but since they are numbers they appear to be imported as integers (dropping off the leading zeroes). Example Data: 0000000000079 0000999000012 0001002000005 0004100000007 The problem I'm seeing is that t...
I have a text file which contains some data. I am trying to search for EA in ID column only and prints the whole row. But the code recognize all EA and prints all rows. What code I should add to satisfy the condition? Thanks Again:-)! DATA: Name Age ID --------------------- KRISTE,22,EA2008 J**EA**N,21,ES4567 JAK,45,EA2008 The code...
I have been searching for a way to allow one element of my FileHelpers mappling class to be an array of specific length. For instance, I have a class like this: [DelimitedRecord(",")] public class Example { public string code; public int month; public int day; public double h1; public double h2; public double h3...
I've come across the problem where Excel will not play nice with UTF-8 encoded CSV files. See this related question on Stack Overflow. I've followed the solution of exporting as UTF-16, however it seems that with UTF-16, the comma character doesn't work as a delimiter, only the tab character. However I can't find anywhere what the corr...
Hello, I am trying to import an access database to mysql. I have created a mysql database, but do not want to use all of the colums in the access database. Is there a way to export only certain colums from the access database to csv? ...