Excel Automation

I having a Excel file with some data.The sheet1 and sheet2 are there.The sheet2 have data and sheet1 have the formula to filter the data.I have done the formula upto 502 numbers the data which i have is 10 number after 10 all the values are zero i need to get only the value which is not having the value zero in it.How to make a new excel file to copy only the data which is not having the value Zero in it.
This can be done in Powershell or Python ?