Workbook Activity vs Excel Activity

Help
, , ,
4

Hi @DikshaAC

Source Thread - Difference between Excel and Workbook activities - #3 by aksh1yadav

  1. To use “Excel Application Scope” , Excel should be Install on the system.
  2. To use Excel services even Excel is not installed then you can use "Workbook related separate activities.
  3. And the other things is with Excel Activities you will not be able to access the chart and diagram realted data with Excel Related activities, You will get an error.
    For more info:
    Excel file with Chart Sheet as first sheet - Exception - #4 by aksh1yadav
  4. For Workbook Related Activity the Excel workbook file should be close at the time of robot run otherwise it will give error like it is being use by other process.
  5. One more thing Faced recently with Excel Application Scope , he was not able to access the password protected excel and same case was with me, a pop was again asking to enter the credential but with Workbook Activities it was working fine.
    For More Details: Excel Passwords

Regards,
Kommi Jeevan