Transcription of import excel — Import and export Excel files
{{id}} {{{paragraph}}}
Excel Import and export Excel filesDescriptionQuick startMenuSyntaxOptions for Import excelOptions for export excelRemarks and examplesStored resultsReferencesAlso seeDescriptionimport excelloads an Excel file, also known as a workbook, into excelfilename,describelists available sheets and ranges of an Excel excelsaves data in memoryto an Excel file. Excel 1997/2003 (.xls) files and Excel 2007/2010 (.xlsx) files can be imported,exported, and described usingimport Excel , export Excel , andimport Excel , excelandexport excelare supported on Windows, Mac, and excelandexport excellook at the file extension.
Now we can import from the auto.xls file we just created, telling Stata to clear the current data from memory and to treat the first row of the worksheet in the Excel file as variable names:. import excel auto.xls, firstrow clear (12 vars, 74 obs). describe Contains data Observations: 74 Variables: 12 Variable Storage Display Value
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}