How to Download CSV to file using Java [duplicate]

Question

My program is to take in a URL that has a CSV file. I'm trying to pass the this into a file for further querying, but it returns with a NoSuchElementException.

public static void main(String[] args) throws ParseException, IOException, URISyntaxException {
    // TODO Auto-generated method stub

    String web = "https://example.com/data.csv";
    URL content = new URL(web);

    File file = new File(content.getPath());

    try {
        Scanner inputStream = new Scanner(file);    //Input file
        String[] values = data.split(",");
        while (inputStream.hasNext()){

            data = inputStream.next();

            values = data.split(",");
            System.out.println(values[];
        }
        inputStream.close();
   } catch (FileNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

}

The file is using wrong path.

Roman C
– Roman C

2017-10-12 22:32:20 +00:00
Commented Oct 12, 2017 at 22:32 — Roman C
– Roman C, Commented Oct 12, 2017 at 22:32

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

from https://docs.oracle.com/javase/7/docs/api/java/net/URL.html

getPath() Gets the path part of this URL. This is not what you want.

openStream() Opens a connection to this URL and returns an InputStream for reading from that connection. This is what you want.

    URL content = new URL(web);
    InputStream stream = content.openStream();

    Scanner inputStream = new Scanner(stream);
    while (inputStream.hasNext()) {
        String data = inputStream.next();
        String[] values = data.split(",");
        System.out.println(values);
    }
    inputStream.close();

Also your url links to gzipped file, which cannot be read directly you need to either download it first, ungzip and treat like normal local file, or provide a link to plain CSV file.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Oct 12, 2017 at 22:49

Milo Bem

1,0339 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Download CSV to file using Java [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related