Is "xls2dta" compatible with the option "cellrange" and "firstrow"?

[Francois Durant]

Hi,

I am using xls2dta (from SSC) to convert all Excel files available in a folder to Stata datasets. I would like to import the first row as variables and I would like to start importing starting from cell A7 in Excel. With "import excel", I would usually use cellrange(A7) and "firstrow" option. I have tried to input these options in xld2dta but I could not find the right syntax. I currently have something of the kind (without options). Any suggestion?

xls2dta , save(c:/my_dta_files) : import excel c:/my_xls_files

[daniel klein]

You can add the respective options after import excel in the same way you would without xls2dta.

xls2dta , save(c:/my_dta_files) : import excel c:/my_xls_files , cellrange(A7) firstrow

[Francois Durant]

Thanks a lot, it helps!