Import Excel 2010 file into Oxygen 13.1?

[karenkay]

Trying to import an Excel 2010 into an Oxygen 13.1 file.

I came across directions to use File > Import, but there is no Import to select in 13.1.

Suggestions?

[ionela]

Hello,

From File->Import->MS Excel File you can import old .xls formats (Excel created with Office 97/2000/XP/2003). With this import the Excel file is converted to an XML file.

For the new Excel format .xlsx (Excel files created in Office 2010) there is no need to make the conversion, because the content is already stored as XML. You can simply drag&drop the file from Explorer to <oXygen/> and you can see it's structure in Archive Browser view (here is opened by default).

More information about how you can process the content of the Excel file you can find in this video demonstration:

Regards,
Ionela

[karenkay]

I watched the video, which is basically about using Oxygen to edit Excel spreadsheets. My purpose is different--we need to pull Excel information into a pre-existing Oxygen document as a table or a graphic (depending on the arrangement of the Excel data). I'm not sure how to do that.

[adrian]

Hi,

The video demonstration that Ionela pointed to is for exporting to an Excel 2010 document.

If you want to automate an import from an Excel 2010 document, you will need to customize an XML stylesheet. Oxygen provides a sample XML stylesheet for importing from Excel 2007/2010:
samples/ooxml/extractFromExcel.xsl
It's usage is similar to the one for importing From Word 2007, as shown here:
http://www.oxygenxml.com/demo/Extract_from_Word.html

If you don't need the automation, you could simply copy the data from the file opened in Excel and paste it in Oxygen, for example in Grid mode.

Regards,
Adrian