<?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 Set Column Names of Excel dynamically in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Set-Column-Names-of-Excel-dynamically/m-p/70821#M23426</link>
    <description>Hi,

I would like to change column names in excel dynamically. Iteration through row seams to be easy but columns in Excel start with alphabet letters. I changed reference style for R1C1 in Excel and in set cell value action (MS Excel VBO) in cell reference I input expression: "R1C"&amp;amp;[CounterDate]&amp;amp;""

I am getting following error from this stage: Exception from HRESULT: 0x800A03EC

Could you help?

Monika</description>
    <pubDate>Mon, 18 Sep 2017 13:44:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2017-09-18T13:44:00Z</dc:date>
    <item>
      <title>Set Column Names of Excel dynamically</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Set-Column-Names-of-Excel-dynamically/m-p/70821#M23426</link>
      <description>Hi,

I would like to change column names in excel dynamically. Iteration through row seams to be easy but columns in Excel start with alphabet letters. I changed reference style for R1C1 in Excel and in set cell value action (MS Excel VBO) in cell reference I input expression: "R1C"&amp;amp;[CounterDate]&amp;amp;""

I am getting following error from this stage: Exception from HRESULT: 0x800A03EC

Could you help?

Monika</description>
      <pubDate>Mon, 18 Sep 2017 13:44:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Set-Column-Names-of-Excel-dynamically/m-p/70821#M23426</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-09-18T13:44:00Z</dc:date>
    </item>
    <item>
      <title>With A1 reference style, you</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Set-Column-Names-of-Excel-dynamically/m-p/70822#M23427</link>
      <description>With A1 reference style, you could try using ""Go To Next Cell"", it moves a specified number of Rows and Columns from the currently active cell and returns the new cell reference.</description>
      <pubDate>Mon, 18 Sep 2017 17:33:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Set-Column-Names-of-Excel-dynamically/m-p/70822#M23427</guid>
      <dc:creator>Deep.Shah</dc:creator>
      <dc:date>2017-09-18T17:33:00Z</dc:date>
    </item>
  </channel>
</rss>

