-1

I need to to read the data in the openoffice .sxc spreadsheet. I have seen the openoffice java SDK to operation the openoffice. Indeed, it is difficult for me to understand. I need to loop the sxc spradsheet and read the cells. Please help me! Thank you!

Baocheng Li
  • 11
  • 5
  • 2
    Quick googling spit out this: http://java67.blogspot.de/2014/09/how-to-read-write-xlsx-file-in-java-apache-poi-example.html . Haven't tried it myself but looks like a good starting point. – nuala Feb 06 '15 at 08:21

1 Answers1

1

you need to use the OpenOffice UNO API for Java. You can get it from http://api.openoffice.org/

Looks like the best places to start reading are the Developer's Guide , and the samples in Java

But there is another solution ;

How to get values from Open office spreadsheet?

Community
  • 1
  • 1
newuserua_ext
  • 577
  • 6
  • 18
  • can you give one example? Thank you! – Baocheng Li Feb 09 '15 at 01:50
  • I saw the example in the openoffice Java SDK, On the page 30 in the document you provide, the example is how to create an empty spreadsheet and insert data. my requirement is to read an openoffice sxc file and get the data. I think there is not many differences between the inserting and reading. However, could you please give some methods. – Baocheng Li Feb 09 '15 at 06:45