Connecting Tech Pros Worldwide Forums | Help | Site Map

How to open and read cell values of MSEXCEL using java

Newbie
 
Join Date: Feb 2007
Location: Pondicherry
Posts: 7
#1: Feb 23 '07
Hi All,

I am newbie to this forum. I have tried to open excel file using java, but problem is how read contents of excel cells.

I have tried same in VB, but i don't know how to do it using java.

Here is the my VB code, someone help using same in JAVA.

Set objexcel = CreateObject("Excel.application")
objexcel.Visible = True
objexcel.Workbooks.Open (filePath+"\filename.xls")

Thanks,
Selva

Lives Here
 
Join Date: Sep 2006
Posts: 12,070
#2: Feb 24 '07

re: How to open and read cell values of MSEXCEL using java


Quote:

Originally Posted by SelvaSA

Hi All,

I am newbie to this forum. I have tried to open excel file using java, but problem is how read contents of excel cells.

I have tried same in VB, but i don't know how to do it using java.

Here is the my VB code, someone help using same in JAVA.

Set objexcel = CreateObject("Excel.application")
objexcel.Visible = True
objexcel.Workbooks.Open (filePath+"\filename.xls")

Thanks,
Selva

Find a third party package for reading .xls files and read its documentation on how to use it.
Banned
 
Join Date: Jun 2007
Posts: 3
#3: Jun 1 '07

re: How to open and read cell values of MSEXCEL using java


You can try jxcell,it is java lib provide apis to support most excel feathers(read,write,format,formula,graph,chart etcs)

http://www.jxcell.net
Reply