| View previous topic :: View next topic |
| Author |
Message |
ravimenon31 Newbie

Joined: 31 Jul 2006 Posts: 2
|
Posted: Mon Jul 31, 2006 4:41 am Post subject: get value of selected cell using UNO |
|
|
Hi
can anybody tell me how can i get the value of the selected cell using uno api.
I am displaying the excel document embedded in java application using officebean.
ravi |
|
| Back to top |
|
 |
SergeM Super User

Joined: 09 Sep 2003 Posts: 3211 Location: Troyes France
|
|
| Back to top |
|
 |
JohnV Administrator

Joined: 07 Mar 2003 Posts: 8979 Location: Lexinton, Kentucky, USA
|
Posted: Mon Jul 31, 2006 8:15 am Post subject: |
|
|
Here some Basic code. | Code: | Sub Main
oCell = ThisComponent.CurrentSelection
print oCell.Value
print oCell.Formula
print oCell.String
End Sub |
|
|
| Back to top |
|
 |
ravimenon31 Newbie

Joined: 31 Jul 2006 Posts: 2
|
Posted: Mon Jul 31, 2006 10:13 pm Post subject: get value of selected cell using UNO |
|
|
Hi
thanks for the reply but ,
actually i want the value in java. hence writing a macro is of no help, because there is no way to capture the retrun value of a macro. (i am calling the macro using dispatch())
i am looking at something which can be done using the xDocument object in uno.
is it possible using uno java api
thanks |
|
| Back to top |
|
 |
|