Clever Geek Handbook

Opencsv + add new column to existing csv

Is it possible to add a new column to an existing csv file , then

existing file

userid,name
1,Jim
2,Sally
3,Bob

modified output file

userid,name,time
1,Jim,64913824823208
2,Sally,64913824900056
3,Bob,64913824966956

Thank you in advance

+3


source to share


2 answers


Do you mean something like this?

CSVReader reader = new CSVReader(new FileReader("input.csv"));
CSVWriter writer = new CSVWriter(new FileWriter("output.csv"), ',');
String[] entries = null;
while ((entries = reader.readNext()) != null) {
    ArrayList list = new ArrayList(Arrays.asList(entries));
    list.add(xxx); // Add the new element here
    writer.writeNext(list);
}
writer.close();


Haven't tried to compile it, but something like this should work. There are many use cases for OpenCsv (for example, you can bind data to beans directly), but this is a shorter solution.

+3


source 


public class A 
{
    public static void main(String[] args) throws IOException 
    {
        CSVReader reader = new CSVReader(new FileReader("new.csv"));
        CSVWriter writer = new CSVWriter(new FileWriter("D:/n.csv"), ',');
        String[] entries = null;

        while ((entries = reader.readNext()) != null) 
        { 
            ArrayList list = new ArrayList(Arrays.asList(entries));
            list.add("m");writer.writeNext(list);
        }
        writer.close();

    }
}


-1


source






More articles:


All Articles