I have a bot which downloads some data from web site as an excel dump. I want to create pivot tables and add few filters to the pivot table. I’m able to do it with Excel in foreground. I want to do it with Excel app in back ground, because I want to schedule this job to make it run everyday. Is it possible? If yes, How?
Any leads would be appreciated.