<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Access excel worksheet via color code in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Access-excel-worksheet-via-color-code/m-p/52563#M7418</link>
    <description>Hi,

There was a business requirement where I had to access the Excel Worksheet using color codes instead of Sheet Names..like do some X task for Red Color Sheets &amp;amp; Y task for Yellow Color Sheets. Had sheet names too, but didn't had to pick the sheets with that. Since it had to be done &amp;amp; BP didn't have support for this..i have achieved it via Excel Macros.

Anyone having such a requirement in future can easily use it.

Attached doc file is the Scenario, User guide &amp;amp; Solution for the same.

&amp;nbsp;

P.S. Would love to be see this being added as a Product Enhancement.</description>
    <pubDate>Thu, 11 Apr 2019 11:47:00 GMT</pubDate>
    <dc:creator>GunjanDhawan</dc:creator>
    <dc:date>2019-04-11T11:47:00Z</dc:date>
    <item>
      <title>Access excel worksheet via color code</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Access-excel-worksheet-via-color-code/m-p/52563#M7418</link>
      <description>Hi,

There was a business requirement where I had to access the Excel Worksheet using color codes instead of Sheet Names..like do some X task for Red Color Sheets &amp;amp; Y task for Yellow Color Sheets. Had sheet names too, but didn't had to pick the sheets with that. Since it had to be done &amp;amp; BP didn't have support for this..i have achieved it via Excel Macros.

Anyone having such a requirement in future can easily use it.

Attached doc file is the Scenario, User guide &amp;amp; Solution for the same.

&amp;nbsp;

P.S. Would love to be see this being added as a Product Enhancement.</description>
      <pubDate>Thu, 11 Apr 2019 11:47:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Access-excel-worksheet-via-color-code/m-p/52563#M7418</guid>
      <dc:creator>GunjanDhawan</dc:creator>
      <dc:date>2019-04-11T11:47:00Z</dc:date>
    </item>
    <item>
      <title>Or just create a customised…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Access-excel-worksheet-via-color-code/m-p/52564#M7419</link>
      <description>Or just create a customised VBO Get Worksheet Names action to either output color codes along with sheet names or only return sheets with specific color.
I can create a quick proof of concept later if you are interested.</description>
      <pubDate>Thu, 11 Apr 2019 13:01:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Access-excel-worksheet-via-color-code/m-p/52564#M7419</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2019-04-11T13:01:00Z</dc:date>
    </item>
    <item>
      <title>Thanks @aikudino
Will surely…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Access-excel-worksheet-via-color-code/m-p/52565#M7420</link>
      <description>Thanks @aikudino
Will surely consider this approach too next time !</description>
      <pubDate>Thu, 11 Apr 2019 13:25:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Access-excel-worksheet-via-color-code/m-p/52565#M7420</guid>
      <dc:creator>GunjanDhawan</dc:creator>
      <dc:date>2019-04-11T13:25:00Z</dc:date>
    </item>
  </channel>
</rss>

