Stata Export over EXCEL's row limit

[Million Tadesse]

Hi All,

1,048,576 is the max row limit for excel. So if you have STATA data over this limit and wanted to have it in one excel sheet, how do you export this data to excel?
I got this from STATA:

export excel using "H:\ASSTATA\file0916.xlsx", replace firstrow(variables)

error "observations must be between 1 and 1048576"


Thanks for the help.
Regards,
Tadesse

[David Radwin]

Are you asking, "How do I create an Excel sheet with more rows than Excel allows?" If so, the answer is that you cannot do this. That is a limitation of Excel.

If you want to spread the rows across multiple sheets, or you want to export fewer than 1,048,576 rows to a single Excel sheet, then there are possibilities.

[Million Tadesse]

Thanks David. I will consider exporting within excel row limit then.
Tadesse