[mjw]

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 OmniOutliner Exports Plugin zip archive file will decompress its contents - generating a folder called Exports plugin which contains instructions and a subfolder (Exports Plugin.ooxsl) 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

--

[kevinpcook]

Does the Excel export work with Excel 2011?

No.

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

<?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">

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.

--

[kevinpcook]

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

Originally Posted by kevinpcook

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

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]

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]

this code is not worked for me

[JimmyMcVideo]

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]

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