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.
Yes, I have tried it. As I am creating pivot table, and adding pivot filters the screen has to be on front otherwise the workflow crashes with exception. Can I add pivot filters without the excel being on screen?
Hey All, Thanks for all the response. I was able to do it using macros. Thanks.
can you provide me sample .xaml file for creating pivot table plz… if possible
