Austlink Help Centre

Follow

Jiwa - Opening XML Files in Excel

In this article we will look at how exported XML files can be opened in Excel.

 

It is imported to understand that Jiwa uses UTF-16 encoding for XML files this is because UTF-16 supports other languages like Chinese and Japanese characters.

Microsoft Excel on the other only supports UTF-8 for XML files so the following error is encountered when attempting to open Jiwa XML files are in Excel.

To resolve this XML import error the encoding reference must be changed in the Jiwa XML file.  This can be done either using either a text or XML editor.

When opening the XML file the encoding will be set to UTF-16 change this to UTF-8 as per the example below.

 

Opening Jiwa XML file in Excel

Before an XML file can be opened in Excel the Developer menu needs to be enabled.

To enable the Developer menu in go to File > Options > Customise Ribbon

Tick the Developer menu option 

The file can then either by opened as an XML table or and XML Source Task Pane

In Excel from the menu ribbon select Developer > XML > Import

Then let Excel create the schema based on the XML source data.

 

Alternatively, you can select to open the file in Excel using File > Open this will then give you the following options.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

This entire document, including design, text, videos,graphics, and photographs are Copyright © 2014 Austlink Plus Pty Ltd, All Rights Reserved.
No part of this document may be reproduced in any way or by any means for commercial or any other purposes, without prior written permission of Austlink Plus Pty Ltd. Use of any data for the purpose of creating promotional materials or producing a printed or electronic catalog of any kind is expressly forbidden without prior written permission of Austlink Plus Pty Ltd.

Powered by Zendesk