LittleR

Blue Prism 一招搞定所有Excel问题

【MS EXCEL VBO的局限】

BP原装的Excel VBO能实现很多Excel的操作功能,但有更多细节的个性化功能其实是实现不了的。

  • 有些用户喜欢标记字体颜色,如何设置颜色,如何读取颜色;
  • 有些单元格是带公式的,如何设置公式,读取当前公式;
  • 有些文件是带密码的,如何设置密码,如何打开带密码文件;
  • 为了好看,专业,如何设置字体,行宽间距;
  • 有些数据导入Excel需要做分列操作;

Blue Prism 一招搞定所有Excel问题

码农小妖精曾分享过,VBO 实现下表中的功能:

输入参数名称 类型 描述 备注
Handle Number Excel实例
Workbook Text 待设定的Excel工作簿名称
Worksheet Text 待设定的Excel工作表单名称
Cell Reference Text 待设定的单元格范围 例如:A1:J1
Font Size Number 字体大小
Bold Flag 字体是否加粗 True or False
Italic Flag 字体是否倾斜 True or False
Underline Number 字体下划线 无下划线:-4142

单下划线:2

粗双下划线:-4119

不支持:4

紧靠在一起的两条细下划线:5

HorizontalAlignment Number 字体水平位置 靠左对齐:-4131

中间对齐:-4108

靠右对齐:-4152

VerticalAlignment Number 字体垂直位置 向上对齐:-4160

中间对齐:-4108

向下对齐:-4107

Cell R Number 预设定的单元格颜色R值 例如:高亮显示为黄色,Cell R = 255,Cell G = 255,Cell B = 0
Cell G Number 预设定的单元格颜色G值
Cell B Number 预设定的单元格颜色B值

非常感谢她的无私分享Blue Prism 一招搞定所有Excel问题Blue Prism 一招搞定所有Excel问题Blue Prism 一招搞定所有Excel问题

【如何快速掌握呢?】

秘诀其实在Excel的宏中。

新建一个测试Excel,启用宏。

Blue Prism 一招搞定所有Excel问题

开始录制宏之后,我对A1单元格设置了黄色背景,对A2单元格设置了字体颜色红色,对A3单元格设置了公式=A1+A2,对第四列我拉宽了一点。

这些动作在宏中的代码如下:

Blue Prism 一招搞定所有Excel问题

BP Excel VBO中的很多方法都是与宏中类似的,当然不是100%相同,我们就是要参照宏里面的很多写法来实现自己想要的增强版的 Excel VBO。

实例1:打开带密码Excel

Blue Prism 一招搞定所有Excel问题

代码块中的语句:

Blue Prism 一招搞定所有Excel问题实例2:读取单元格公式

Blue Prism 一招搞定所有Excel问题

Blue Prism 一招搞定所有Excel问题

实例3: 获取单元格背景颜色

Blue Prism 一招搞定所有Excel问题

 

Blue Prism 一招搞定所有Excel问题

其实如果参考宏里面的代码,几乎可以实现任何你想要的操控Excel的功能。本文的标题是一招搞定所有Excel问题,但其实还有一个话题没搞定,那就是RPA往Excel写数据的效率问题,几千行,几万行,甚至跟列数也有关系。 关于这一点要测试的内容有点多,暂就不提了,期待跟各位大大交流经验。

你们学会了吗?

Blue Prism 一招搞定所有Excel问题

评论 (49)

  • buy cc for carding| 2020-08-20

    … [Trackback]

    […] Find More on that Topic: rpaplus.com/2019/1651/ […]

  • cheap steroids| 2020-08-21

    … [Trackback]

    […] Find More Info here to that Topic: rpaplus.com/2019/1651/ […]

  • go to this site| 2020-08-21

    … [Trackback]

    […] Read More here to that Topic: rpaplus.com/2019/1651/ […]

  • Mossberg 500 ATI Scorpion Tactical 12ga| 2020-08-23

    … [Trackback]

    […] There you can find 75681 more Information on that Topic: rpaplus.com/2019/1651/ […]

  • GLOCK 48 9MM BLACK| 2020-08-24

    … [Trackback]

    […] Info to that Topic: rpaplus.com/2019/1651/ […]

  • CBD capsules for sale| 2020-08-24

    … [Trackback]

    […] There you can find 31938 more Information on that Topic: rpaplus.com/2019/1651/ […]

  • here| 2020-08-27

    … [Trackback]

    […] Read More here to that Topic: rpaplus.com/2019/1651/ […]

  • World news| 2020-08-28

    … [Trackback]

    […] Read More here to that Topic: rpaplus.com/2019/1651/ […]

  • lo de online| 2020-08-30

    … [Trackback]

    […] Read More to that Topic: rpaplus.com/2019/1651/ […]

  • ritalin medicine for sale overnight delivery| 2020-09-02

    … [Trackback]

    […] Read More here to that Topic: rpaplus.com/2019/1651/ […]

  • order clonazepam online in usa canada uk australia without prescription nextday shipping| 2020-09-02

    … [Trackback]

    […] Information on that Topic: rpaplus.com/2019/1651/ […]

  • firedamagedispatchers.com/| 2020-09-03

    … [Trackback]

    […] Here you can find 1547 more Information to that Topic: rpaplus.com/2019/1651/ […]

  • buy dankwoods| 2020-09-04

    … [Trackback]

    […] Find More on that Topic: rpaplus.com/2019/1651/ […]

  • Regina| 2020-09-04

    … [Trackback]

    […] Here you can find 88392 more Information to that Topic: rpaplus.com/2019/1651/ […]

  • countertop contractors| 2020-09-07

    … [Trackback]

    […] Here you will find 61356 additional Information on that Topic: rpaplus.com/2019/1651/ […]

  • https://www.terrasmart.at/wp/wp-content/uploads/cialis.html| 2020-09-07

    … [Trackback]

    […] Read More on to that Topic: rpaplus.com/2019/1651/ […]

  • http://144.91.94.10/| 2020-09-07

    … [Trackback]

    […] Read More to that Topic: rpaplus.com/2019/1651/ […]

  • 먹튀사이트| 2020-09-08

    … [Trackback]

    […] Read More here to that Topic: rpaplus.com/2019/1651/ […]

  • link| 2020-09-09

    … [Trackback]

    […] Here you can find 98005 more Info on that Topic: rpaplus.com/2019/1651/ […]

  • this site| 2020-09-09

    … [Trackback]

    […] Info to that Topic: rpaplus.com/2019/1651/ […]

  • easy1up| 2020-09-10

    … [Trackback]

    […] Read More on that Topic: rpaplus.com/2019/1651/ […]

  • purekana cbd oil| 2020-09-11

    … [Trackback]

    […] Find More Information here on that Topic: rpaplus.com/2019/1651/ […]

  • certifiedpestcontrolonline.com/| 2020-09-12

    … [Trackback]

    […] Find More on to that Topic: rpaplus.com/2019/1651/ […]

  • Egypt Tours| 2020-09-12

    … [Trackback]

    […] Here you will find 97110 more Information to that Topic: rpaplus.com/2019/1651/ […]

  • Buy fentanyl patch online overnight without prescription| 2020-09-16

    … [Trackback]

    […] Find More on on that Topic: rpaplus.com/2019/1651/ […]

  • purchase xanax xr for sale without prescription with next day shipping| 2020-09-16

    … [Trackback]

    […] Find More to that Topic: rpaplus.com/2019/1651/ […]

  • mơ có người chết đánh con gì| 2020-09-16

    … [Trackback]

    […] Find More on that Topic: rpaplus.com/2019/1651/ […]

  • buy norco online no script use for pain anxiety overnight delivery| 2020-09-16

    … [Trackback]

    […] Find More here to that Topic: rpaplus.com/2019/1651/ […]

  • buy Penis Envy psychedelic magic mushrooms spores online for sale near me in USA Canada UK Australia overnight delivery cheap| 2020-09-17

    … [Trackback]

    […] Here you can find 16002 more Info to that Topic: rpaplus.com/2019/1651/ […]

  • special info| 2020-09-18

    … [Trackback]

    […] Read More on to that Topic: rpaplus.com/2019/1651/ […]

  • mơ về rắn đánh con gì| 2020-09-18

    … [Trackback]

    […] There you can find 55799 additional Info to that Topic: rpaplus.com/2019/1651/ […]

  • Hotels nearest to Disneyland entrance| 2020-09-19

    … [Trackback]

    […] Here you can find 80137 additional Information to that Topic: rpaplus.com/2019/1651/ […]

  • Pablo88bet| 2020-09-24

    … [Trackback]

    […] Find More Information here to that Topic: rpaplus.com/2019/1651/ […]

  • thenaturalpenguin| 2020-09-24

    … [Trackback]

    […] Read More here to that Topic: rpaplus.com/2019/1651/ […]

  • English and French bulldog puppies for sale near me in MN MD CT NJ AZ AK LA WV ND IW NC NB WA NV MI| 2020-09-25

    … [Trackback]

    […] Read More on to that Topic: rpaplus.com/2019/1651/ […]

  • cheap revlon wigs| 2020-09-25

    … [Trackback]

    […] Find More Information here on that Topic: rpaplus.com/2019/1651/ […]

  • 65cm love dolls| 2020-09-25

    … [Trackback]

    […] Find More Information here on that Topic: rpaplus.com/2019/1651/ […]

  • Immediate Edge| 2020-09-27

    … [Trackback]

    […] There you can find 97133 more Information to that Topic: rpaplus.com/2019/1651/ […]

  • is go365 legit| 2020-09-30

    … [Trackback]

    […] Info to that Topic: rpaplus.com/2019/1651/ […]

  • https://bitcoineraonline.com| 2020-10-03

    … [Trackback]

    […] Find More on to that Topic: rpaplus.com/2019/1651/ […]

  • mơ thấy anh em gặp nhau| 2020-10-06

    … [Trackback]

    […] Read More Info here on that Topic: rpaplus.com/2019/1651/ […]

  • w88club| 2020-10-06

    … [Trackback]

    […] Find More on that Topic: rpaplus.com/2019/1651/ […]

  • mơ thấy tiền đánh con gì| 2020-10-06

    … [Trackback]

    […] Read More here to that Topic: rpaplus.com/2019/1651/ […]

  • mơ thấy gạo đánh con gì| 2020-10-07

    … [Trackback]

    […] Read More here on that Topic: rpaplus.com/2019/1651/ […]

  • Pomsky breeders| 2020-10-10

    … [Trackback]

    […] Read More Info here on that Topic: rpaplus.com/2019/1651/ […]

  • Bichon Puppies for Sale| 2020-10-10

    … [Trackback]

    […] Find More here to that Topic: rpaplus.com/2019/1651/ […]

  • mơ thấy người cha đã mất| 2020-10-14

    … [Trackback]

    […] Read More on on that Topic: rpaplus.com/2019/1651/ […]

  • 要发表评论,您必须先登录