Terry wrote:
> Chuck wrote:
>> I have an xml file that I'd like to load into a calc spreadsheet. If I
>> open calc, then try to open the file, it opens it in writer instead. How
>> to I load it into calc? TIA
> You could try the ruse used to open text files other than .csv. See
> http://documentation.openoffice.org/faqs/spreadsheet/001.html
>
> That involves using File >Open. First, select the file, THEN select the
> filetype, Text CSV (*.csv,*.txt). It's a fair way down the list. If
> that does not work on its own, try changing the file extension from .xml
> to .csv.
>
> Otherwise, there is a macro (designed for Windows) here:
> http://www.oooforum.org/forum/viewtopic.phtml?p=71125#71125
>
That only works for delmited files like csv or tab delimited. This file
is in XML format. Here's a small sample of what it looks like. It should
show 3 columns named OWNER, NUM_SEGMENTS, and MEGABYTES.
<?xml version="1.0" ?>
<!DOCTYPE main [
<!ELEMENT main (DATA_RECORD*)>
<!ELEMENT DATA_RECORD (OWNER?,NUM_SEGMENTS?,MEGABYTES?)+>
<!ELEMENT OWNER (#PCDATA)>
<!ELEMENT NUM_SEGMENTS (#PCDATA)>
<!ELEMENT MEGABYTES (#PCDATA)>
]>
<main>
<DATA_RECORD>
<OWNER>SYSADM</OWNER>
<NUM_SEGMENTS>35780</NUM_SEGMENTS>
<MEGABYTES>16051</MEGABYTES>
</DATA_RECORD>
<DATA_RECORD>
<OWNER>SYS</OWNER>
<NUM_SEGMENTS>657</NUM_SEGMENTS>
<MEGABYTES>11457</MEGABYTES>
</DATA_RECORD>
<DATA_RECORD>
<OWNER>PERFSTAT</OWNER>
<NUM_SEGMENTS>83</NUM_SEGMENTS>
<MEGABYTES>2296</MEGABYTES>
</DATA_RECORD>
</main>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
