Export excel data with 0 observation

[Leydiarina Smith]

Hi
Im doing so many report to export excel and my problem is when i have 0 observation dont update.
export excel using "D:\DATA\REPORTS.xlsx" if tpob==0, sheet("SHEET1",modify) nolabel

observations must be between 1 and 1048576
how can i do ?

[Clyde Schechter]

count if tpob == 0
if r(N) > 0 {
    export excel using "D:\DATA\REPORTS.xlsx" if tpob==0, sheet("SHEET1",modify) nolabel
}