Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Convert OpenOffice Spreadsheet into Microsoft Excel

Posted on 2005-04-20
24
Medium Priority
?
264 Views
Last Modified: 2010-03-31
Hi,

Anybody know how to convert OpenOffice Spreadsheet (CALC) into Microsoft Excel programatically?

Please advise, Thanks.
0
Comment
Question by:rospcc
  • 10
  • 10
  • 4
24 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 13822340
A kludgy way could be csv -> csv if there's no embedded stuff there
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 13822351
A 'proper' way would be to read it with the OOo api and write it with POI
0
 

Author Comment

by:rospcc
ID: 13822397
Don't think can use csv, mine require charts and other formatting.
I thought POI is to write MS Excel?
Can we use POI to convert OpenOffice Spreadsheet to MS Excel?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 86

Expert Comment

by:CEHJ
ID: 13822436
>> Don't think can use csv, mine require charts and other formatting.

Then you're right - CSV is out

>>I thought POI is to write MS Excel?

Yes? This would seem appropriate...

>>... into Microsoft Excel programatically?

Can't Calc save as xls?
0
 
LVL 92

Expert Comment

by:objects
ID: 13822453
The open office api may well already include that functionaility, would check their first.
0
 
LVL 92

Expert Comment

by:objects
ID: 13822466
>>I thought POI is to write MS Excel?

Yes? This would seem appropriate...

POI won't help you.

If OpenOffice doesn't have an export option then havce a look at these alternatives.
0
 
LVL 92

Expert Comment

by:objects
ID: 13822467
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 13822539
>>Can't Calc save as xls?

It would seem so:

(From http://linuxlab.dk/learnlinux/exercises/fall2002/ooo/)

>>With "OpenOffice.org Calc", you can make spreadsheets in and save as "Excel" format

Therefore it's pretty likely you can get the OOo api to do this
0
 
LVL 92

Expert Comment

by:objects
ID: 13822599
> Therefore it's pretty likely you can get the OOo api to do this

Already mentioned that ;)
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 13822609
Only *after* i did (by implication) ;-)
0
 
LVL 92

Expert Comment

by:objects
ID: 13822627
> Only *after* i did (by implication)

If you have something to add then post it, 'implying' it doesn't really help anyone.

0
 

Author Comment

by:rospcc
ID: 13822630
CEHJ, OpenOffice.org Calc "can" save as xls, However I can't use this because it requires manual work.
Is there a way to convert it using the OOo api?

I've tried to use POI, but the chart support for excel is not good enough.
Jintegra (http://j-integra.intrinsyc.com/) is very good, but the licence is amazingly expensive.

Basically, What I need to do is to use Java to generate OpenOffice.org Calc report, which I need to convert and display as xls for Windows user.


0
 
LVL 86

Expert Comment

by:CEHJ
ID: 13822656
>>Is there a way to convert it using the OOo api?

I don't use the api myself, but it's pretty likely you can do it if you can do it with the app
0
 
LVL 92

Accepted Solution

by:
objects earned 1000 total points
ID: 13822664
0
 

Author Comment

by:rospcc
ID: 13822667
> Only *after* i did (by implication)
What do you mean by the implication?
0
 
LVL 92

Expert Comment

by:objects
ID: 13822684
> What do you mean by the implication?

Means he didn't actually suggest it :-D
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 13822688
>>What do you mean by the implication?

This:

>>Can't Calc save as xls?

If the application can do it - it's pretty likely that the api can
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 13822721
>>Means he didn't actually suggest it :-D

It means that it's too obvious to take the trouble to state it other than to say:

>>Can't Calc save as xls?
0
 
LVL 92

Expert Comment

by:objects
ID: 13822753
Whether Calc can save to Excel does not necessarily imply that the API can, and it seems it was not in anyway obvious otherwise we wouldn't be wasting our time discussing this now :)
And in the same comment you actually suggested using a different API that did not support what was required to make it even more confusing what you were on about.
If you explicitly state what you mean its a lot clearer for all involved.
0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 1000 total points
ID: 13822767
>> Whether Calc can save to Excel does not necessarily imply that the API can

It means

a. there's a pretty good chance it can.
b. the possibitily should therefore be investigated by looking at the api docs
0
 
LVL 92

Expert Comment

by:objects
ID: 13822775
Which is what I said already :-D
0
 

Author Comment

by:rospcc
ID: 13840092
I think the link posted by objects is the answer, thanks to CEHJ too for guiding to the API exporting possibility.
Will explore into more details.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 13841114
:-)
0
 
LVL 92

Expert Comment

by:objects
ID: 13862782
(:
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
Suggested Courses
Course of the Month20 days, 23 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question