Data Formats | SASXML

SASXML

Links to important information about the canSAS 1D Data Format:

The 1D Working Group WiKi site

The root directory for the TRAC site (go here to download the stylesheet cansasxml-html.xsl; right-click on it & Save as...)

The specification of the format

The Java binding

SASXML and Microsoft Office Excel

Microsoft Excel is compatible with SASXML files from Excel 2000 onwards, although there are some known issues:

If using Excel 2000 or Excel 2003 please first download and install the XML Tools Add-In available from Microsoft: OfficeExcel2003XMLToolsAddin.exe

If using Excel 2007 you may encounter two issues: i) A message that 'The [SASXML] file you are trying to open is in a different format than specified by the [.XML] file extension', or ii) That there is no option to open the SASXML file in Excel from the right mouse button context menu.  These are Microsoft issues and are in fact linked to one another. Fortunately both may be fixed by two simple updates to the Windows registry.

Copy and past the following text (including the Windows Registry Editor line) into two seperate Notepad files. Save both, then right-click on each and select 'Merge'.

i)

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
"VBAWarnings"=dword:00000001
"DataConnectionWarnings"=dword:00000000
"ExtensionHardening"=dword:00000000

ii)

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\*\shell\Open With Excel]

[HKEY_CLASSES_ROOT\*\shell\Open With Excel\Command]
@="excel.exe %1"