CODEWITHSUNDEEP
javaexcel
Prachur
Prachur

Reputation: 1110

How to open an excel sheet using Java?

I am trying to make a program through which i want to manipulate data in the excel sheet, But data is being manipulated only when the excel sheet is open. whats the process to open and close it using java coding.

Upvotes: 2

Views: 10668

Answers (2)

Andy
Andy

Reputation: 5218

Hey look, there's a tutorial on how to do this link from the JExecel website!

http://www.andykhan.com/jexcelapi/tutorial.html

Side note: It looks like JExcel is file based only. This means you can't interact with an open spreadsheet. If you need to interact with an open spreadsheet you will have to use JNI or a library such as J-Integra COM, which uses JNI.

Upvotes: 0

fluminis
fluminis

Reputation: 4059

You can use POI to read and write Excel sheets.

This article is interesting to understand how to use it :

http://onjava.com/pub/a/onjava/2003/04/16/poi_excel.html

Upvotes: 7

Related Questions