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

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]

Does the Excel export work with Excel 2011?

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]

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

[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.

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?

this code is not worked for me

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

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?

The XML produced by the plug-in can be opened in Excel 2004 or Excel 2008. If you still have one of those hanging around on your system, then open the OO3 Excel XML export, and then save it again from Excel 2004 (or Excel 2008) as an XML export. This can then be opened by Excel 2011.

FWIW, it appears that installing Excel 2011 destroys the ability of Excel 2004 and Excel 2008 to save anything other than XML files. It might be the case that the XML produced by the plug-in isn't actually fully compatible with either Excel 2004 or 2008, but isn't rejected either. Saving a new XML from either 2004 or 2004 makes a file that is sufficiently compatible with 2011, at least for the time being.

a work around
 

[url]http://www.zamzar.com[/url]

Use the above site and it will convert it to a readable xls file.

No formatting though.

It is my biggest issue with all Omni products. They are great, and do amazing things. But they do not play well with others. Unfortunately nearly all of my clients use Office and they still use only basic functions.

Meaning I have to dumb it down whenever i send stuff.

Sigh