Excel automation in background

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.

Have you tried to uncheck [Visible] property of [ExcelApplicationScope] activity?

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