|
|  |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
re:st: -xmlsave- to Excel (for Mac?)
I am using S/E 9.1 for Macintosh.
Perhaps I am missing something woefully obvious, but shouldn't the
use of
-xmlsave- create a file that is readable by Excel?? As I
understand the
help file, the following syntax ought to create a file (generic
spreadsheet) that Excel can read:
xmlsave gofigure, doc(excel)
After gofigure.xml is created, the file can be opened w/ a text
editor,
albeit not w/ MS Excel. Could this be because I'm using a Mac?? Note
that the text file for gofigure.xml does not present the file in
what i
would consider the "expected" format, i.e. variable names on the
top line
followed by the data...
many thanks in advance!
--Clint
On my Mac, I have some issues too.
sysuse auto
xmlsave auto, doc(excel)
/* trying to import using the latest MS Excel fails with the
following error messages:
Strict Parse Error
This file is not a valid Excel XML spreadsheet
But even more strange is that Stata cannot open it's own xml file: */
. xmluse auto.xml, doc(excel) clear
data type of Excel column not consistent
specifying the missing option will import inconsistent values as
missing data
while the allstring option will import all as strings
file not Stata format
r(610);
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
