<?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 Excel Operations in V5 in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Excel-Operations-in-V5/m-p/81958#M33454</link>
    <description>Hi All-

&amp;nbsp;

I have a requirement of writing different set of collection details to different sheets of a workbook which I am doing by looping through the collection.

&amp;nbsp;

&amp;nbsp;I am creating a new sheet everytime I am looping through the collection and hence there will be dynamic number of sheets int he workbook.

&amp;nbsp;

But these sheets are not formatted and I tried to apply the conditional formatting to all the sheets in the workbook through enabling macros but seems because of my group policies I cannot enable macros by default.

&amp;nbsp;

I also could see there is nothing like renaming of existing sheets from the Actions available for Excel VBO. Please can you advise how this was implemented in your projects?</description>
    <pubDate>Wed, 28 Feb 2018 20:02:00 GMT</pubDate>
    <dc:creator>Sri_Krishna_Cha</dc:creator>
    <dc:date>2018-02-28T20:02:00Z</dc:date>
    <item>
      <title>Excel Operations in V5</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Excel-Operations-in-V5/m-p/81958#M33454</link>
      <description>Hi All-

&amp;nbsp;

I have a requirement of writing different set of collection details to different sheets of a workbook which I am doing by looping through the collection.

&amp;nbsp;

&amp;nbsp;I am creating a new sheet everytime I am looping through the collection and hence there will be dynamic number of sheets int he workbook.

&amp;nbsp;

But these sheets are not formatted and I tried to apply the conditional formatting to all the sheets in the workbook through enabling macros but seems because of my group policies I cannot enable macros by default.

&amp;nbsp;

I also could see there is nothing like renaming of existing sheets from the Actions available for Excel VBO. Please can you advise how this was implemented in your projects?</description>
      <pubDate>Wed, 28 Feb 2018 20:02:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Excel-Operations-in-V5/m-p/81958#M33454</guid>
      <dc:creator>Sri_Krishna_Cha</dc:creator>
      <dc:date>2018-02-28T20:02:00Z</dc:date>
    </item>
    <item>
      <title>Can someone help?</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Excel-Operations-in-V5/m-p/81959#M33455</link>
      <description>Can someone help?</description>
      <pubDate>Fri, 02 Mar 2018 17:35:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Excel-Operations-in-V5/m-p/81959#M33455</guid>
      <dc:creator>Sri_Krishna_Cha</dc:creator>
      <dc:date>2018-03-02T17:35:00Z</dc:date>
    </item>
  </channel>
</rss>

