How to open and read cell values of MSEXCEL using java

[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

[r035198x]

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.

[liqdok]

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