[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
-xmlsave- create a file that is readable by Excel?? As I
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
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
would consider the "expected" format, i.e. variable names on the
followed by the data...
many thanks in advance!
On my Mac, I have some issues too.
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
while the allstring option will import all as strings
file not Stata format
* For searches and help try: