<?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 Instead of calling each cell… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79145#M31088</link>
    <description>Instead of calling each cell individually.&amp;nbsp; Create a collection containing the cell references (would recommend naming the cells and addressing that name rather than the cell number e.g. cell A5 contains a staff name or something, call that cell 'StaffName' or something).
So the collection will have a field called A4, A6, B9 etc.&amp;nbsp; Or the fields would be called StaffName , Salary, JobTitle etc.&amp;nbsp; Whatever you're tryign to capture.
Then have a loop or a conditional statement, whatever you prefer to cycle through and address each cell reference and store it in your collection.
&amp;nbsp;This way if you ever want to add/remove an item you just add/remove additional item fro mthe collections lsit of fields.
Additionally if you were extracting data from multiple excels all in the same format, you can add a new row for each one and build a lsit of work items that way.
Hope that helps</description>
    <pubDate>Thu, 04 Apr 2019 19:23:00 GMT</pubDate>
    <dc:creator>BenKirimlidis</dc:creator>
    <dc:date>2019-04-04T19:23:00Z</dc:date>
    <item>
      <title>Get Cell Value VBO Excel</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79144#M31087</link>
      <description>&amp;nbsp;

Hello Everyone

Is it possible to get multiple Cell values from different cells in excel, i have to read 15 different cells (like A2 , H3, BK25)from excel to check this excel. Does someone made this easier than add 15 actions into the proces.

Cemile</description>
      <pubDate>Thu, 04 Apr 2019 19:12:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79144#M31087</guid>
      <dc:creator>Cemile.Demirci</dc:creator>
      <dc:date>2019-04-04T19:12:00Z</dc:date>
    </item>
    <item>
      <title>Instead of calling each cell…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79145#M31088</link>
      <description>Instead of calling each cell individually.&amp;nbsp; Create a collection containing the cell references (would recommend naming the cells and addressing that name rather than the cell number e.g. cell A5 contains a staff name or something, call that cell 'StaffName' or something).
So the collection will have a field called A4, A6, B9 etc.&amp;nbsp; Or the fields would be called StaffName , Salary, JobTitle etc.&amp;nbsp; Whatever you're tryign to capture.
Then have a loop or a conditional statement, whatever you prefer to cycle through and address each cell reference and store it in your collection.
&amp;nbsp;This way if you ever want to add/remove an item you just add/remove additional item fro mthe collections lsit of fields.
Additionally if you were extracting data from multiple excels all in the same format, you can add a new row for each one and build a lsit of work items that way.
Hope that helps</description>
      <pubDate>Thu, 04 Apr 2019 19:23:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79145#M31088</guid>
      <dc:creator>BenKirimlidis</dc:creator>
      <dc:date>2019-04-04T19:23:00Z</dc:date>
    </item>
    <item>
      <title>Hi Ben,
Thank you for the…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79146#M31089</link>
      <description>Hi Ben,
Thank you for the answer. The layout of the excel is a form so its complex to get this in an collection, im&amp;nbsp;searching for an code what does ""&amp;nbsp;get cell value"" but you can give multiple cells as input for it.
&amp;nbsp;
CD58
&amp;nbsp;
&amp;nbsp;
&amp;nbsp;</description>
      <pubDate>Fri, 05 Apr 2019 12:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79146#M31089</guid>
      <dc:creator>Cemile.Demirci</dc:creator>
      <dc:date>2019-04-05T12:46:00Z</dc:date>
    </item>
    <item>
      <title>You can add that kind of…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79147#M31090</link>
      <description>You can add&amp;nbsp;that kind of action in VBO&amp;nbsp;(with&amp;nbsp;code stage or just blueprism loop).&amp;nbsp;
Doing it in code stage has no real benefits, unless you are getting a big range with one interop call instead of many many single one.
You process can be a single ""do the right thing"" action calling VBO if you want to.
&amp;nbsp;</description>
      <pubDate>Fri, 05 Apr 2019 20:54:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Cell-Value-VBO-Excel/m-p/79147#M31090</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2019-04-05T20:54:00Z</dc:date>
    </item>
  </channel>
</rss>

