java open csv file using excel

Question

I am making a project for college and have made a program which creates csv files. I would like there to be a button which you can click which then opens the csv file with excel. Thanks

Did you mean when you click a button made in java program, you should end up opening that .csv file ? — Saurabh Gokhale
– Saurabh Gokhale, Commented Mar 3, 2011 at 15:14
If you're interested in using a library, Open CSV has come a long way: baeldung.com/opencsv — Adam Gerard
– Adam Gerard, Commented Jan 15, 2019 at 4:33

Coryffaeus · Accepted Answer · 2011-03-03 15:41:21Z

3

Knowing that MsOffice is installed on the system, you should be able to open a document with it from command line using the command

excel myDoc.csv

to execute such a command from java, you could use this snapshot:

File myCSVFile; //reference to your file here 
String execString = "excel " + myCSVFile.getAbsolutePath();
Runtime run = Runtime.getRuntime();
try {
    Process pp = run.exec(execString);
} catch(Exception e) {
    e.printStackTrace();
}

This is somewhat rough and needs styling, of course, but generally it should work. Besides, to be more graceful you could also check Windows registry, using the java.util.prefs.Preferences class, to know if MsOffice is installed and, if yes, where. But, please, be aware, if you are reckoning for MsExcel (as I understood from your post), this will automatically cancel Java's multiplatform approach. Hopefully, this helps :)

edited Mar 3, 2011 at 15:41

answered Mar 3, 2011 at 15:19

Coryffaeus

3905 silver badges8 bronze badges

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

Comments

Ocaso Protal · Accepted Answer · 2011-03-03 15:10:50Z

3

If you are using Java 6 you can use the Desktop class. Read also Opening, Editing, and Printing a File

answered Mar 3, 2011 at 15:10

Ocaso Protal

20.4k8 gold badges80 silver badges92 bronze badges

2 Comments

Coryffaeus Over a year ago

A good point! But note, that Desktop.open(File file) method opens the file with a system default program, not with a specific one (like Excel in this case). It may well be that CSV would be set to be opened with another program, like Notepad++ or whatever.

Ocaso Protal Over a year ago

@Coryffaeus you are right. But IMHO it should be the user's choice what program opens csv-files. And the Desktop solution also handles the case when no Excel is installed.

Raman · Accepted Answer · 2011-03-03 15:19:29Z

0

You can use JExcel API. It will be very easy for you.

answered Mar 3, 2011 at 15:19

Raman

1,5154 gold badges16 silver badges25 bronze badges

Comments

Kirill Yunussov · Accepted Answer · 2020-04-25 17:42:15Z

0

For whatever reason, execString's provided did not work for me, but the one below worked:

String execString = "cmd /c start excel \"" + filePathString + "\"";

With the other exeString's I kept getting an exception saying that the runtime cannot find the file - start or excel.

answered Apr 25, 2020 at 17:42

Kirill Yunussov

2,3631 gold badge23 silver badges26 bronze badges

Collectives™ on Stack Overflow

java open csv file using excel

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related