The Omni Group Forums

The Omni Group Forums (http://forums.omnigroup.com/index.php)
-   OmniOutliner 3 for Mac (http://forums.omnigroup.com/forumdisplay.php?f=9)
-   -   Export oo3 to excel format (http://forums.omnigroup.com/showthread.php?t=18069)

mjw 2010-09-22 01:19 PM

Export oo3 to excel format
 
How do I export oo3 files to excel format? I downloaded the .zip file from the website / double clicked and tried to export a file to excel - nada.

What am I missing on my MBP?

Thanks

RobTrew 2010-09-22 02:24 PM

Dbl-clicking the [URL="http://www.omnigroup.com/ftp/pub/software/MacOSX/Extras/OmniOutliner/OmniOutlinerExportsPlugin.zip"]OmniOutliner Exports Plugin[/URL] zip archive file will decompress its contents - generating a folder called [I]Exports plugin[/I] which contains instructions and a subfolder ([I]Exports Plugin.ooxsl[/I]) which you need to move to HOME/Library/Application Support/OmniOutliner 3/Plug-Ins/

As long are you are running OO3 Professional, Microsoft Excel (XML) will then be one of the file formats available under File > Export

[COLOR="White"]--[/COLOR]

kevinpcook 2010-12-28 12:17 PM

Does the Excel export work with Excel 2011?

RobTrew 2010-12-29 01:35 AM

No.

(It generates an .xml (rather than .xlsx) file with a content which looks promising enough:

[CODE]<?xml version="1.0" encoding="UTF-8"?>
<Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:o="urn:schemas-microsoft-com:office:office">[/CODE]

but the verdict given by Excel 2011 is that it is not a valid Excel spreadsheet, and manually changing the extension to .xlsx doesn't solve the problem)

You can, however, export from oo3 to .csv, and successfully import the .csv file into Excel 2011.

[COLOR="White"]--[/COLOR]

kevinpcook 2011-01-11 11:27 AM

Yeah, I tried the CSV route, but as my outline has multiple columns, I lose them in the import.

RobTrew 2011-01-11 01:21 PM

[QUOTE=kevinpcook;91531]Yeah, I tried the CSV route, but as my outline has multiple columns, I lose them in the import.[/QUOTE]

That sounds frustrating, but there should be no problem at all with multiple columns.

With three columns in oo3 - one text and two numeric, I am finding that File > Export > CSV generates a file that contains the data and a header for all three columns.

I am also finding that in Excel 2011 File > Import > CSV File is having no difficulty in reading all three columns into good Excel data, textual and numeric.

rearden215 2011-02-15 02:01 PM

Thanks for the guidance on adding the Excel Export plug-in.

I had to manually add the /Plug-ins/ directory as my oo3 Pro directory did not already have that.

But, I re-start oo3 and there is no Excel choice in the dropdown box.

Perhaps I need to re-boot the computer?

Calgary 2011-02-17 06:46 AM

this code is not worked for me

JimmyMcVideo 2011-02-28 12:31 PM

What about carring over stylings as well as columns?
 
Hi,

I need to export my 6 column OO file into an XML table, but I need to carry over some stylings too. I need BOLD, and hopefully Font COLOR and SIZE as well.

Is there anyone here who could write this plug-in? I bet it'd be useful to a lot of people!

Would it be a simple matter of modifying the Excel export plug-in?

Jmz

JimmyMcVideo 2011-02-28 12:59 PM

any other program besides Excel ?
 
Could I used the XML export plugin to export and then import into another table-generating program like Open Office?


All times are GMT -8. The time now is 06:19 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.