[转]Blue Prism Opening a password protected Excel workbook?
本文转自:https://www.rpaforum.net/threads/opening-a-password-protected-excel-workbook.470/
问:
As the title says, how would we open a password protected Excel workbook using Blue Prism?
答:
Hi Nick
The best approach (which I have used for my developments) is to duplicate the existing Open Workbook action from the MS Excel VBO and change the 'Open Workbook' code stage to include the extra Password input.
Then open up the 'Open Workbook' Code stage and amend the Code (within the Code tab) to the following:
Dim wb as Object = GetInstance(handle).Workbooks.Open(Filename:=filename, Password:=password)
name = wb.Name
wb.Activate()
You'll notice that there is a change of code within the Workbooks.Open brackets compared to the original Open Workbook Code stage. This performs the magic of opening an Excel spreadsheet and entering the password at the same time.
Try it and let me know how you get on.
答:
Was intrigued to see how this can be done without the use of code so had a go myself. Works as follows:
1) Create a new VBO for Excel and set up App Modeller to work with Excel.
2) Create a Launch page that receives two inputs - Password and Workbook.
3) In the Launch Navigate stage, used the Workbook as the Command Line Parameter and use a Wait stage to wait for the Password pop-up to appear.
4) Use Global Send Key Events to the Application to send the password and then send an Enter "{ENTER}" to the application then wait for the pop-up to disappear.
5) In the original Excel VBO, use the Attach to Workbook page to attach the VBO to Excel and output the handle.
Hope this helps a few people
Rob
最新文章
- android px转换为dip/dp
- CF219D. Choosing Capital for Treeland [树形DP]
- Lab_4_SysOps_Monitoring_Linux_v2.5
- 一个十年java程序员的心得
- NOSQL概要
- [课程设计]Scrum 2.0 多鱼点餐系统开发进度(第二阶段项目构思与任务规划)
- redhat--nagios插件--check_traffic.sh
- LInux下socket编程学习笔记
- 【贪心+一点小思路】Zoj - 3829 Known Notation
- js获取星期几
- Python安装及开发环境配置
- [CSS] Transforms
- python的工作记录A
- 【LeetCode练习题】Add Two Numbers
- 由于抽签HT For Web ComboBox下拉框组件
- Ecstore安装篇-1.运行系统环境要求
- java 后台封装json数据学习总结(一)
- 杭电ACM2017--字符串统计
- 如何快速定位到DBGrid的某一行!!!急...
- linux设置时间显示格式和系统版本