<?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 Hi Priyanka, in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Reading-Excel-as-truncated-rounded-values/m-p/89804#M40138</link>
    <description>Hi Priyanka,
I am not sure if this might help, But before your u use Get Worksheet, i suggest you format the cells using Format cell action. So you would not need to manually go in and change the format. Then use the Get Worksheet to import.
Thanks,
Hari</description>
    <pubDate>Thu, 13 Jul 2017 20:11:00 GMT</pubDate>
    <dc:creator>hari.murali</dc:creator>
    <dc:date>2017-07-13T20:11:00Z</dc:date>
    <item>
      <title>Reading Excel as truncated / rounded values</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Reading-Excel-as-truncated-rounded-values/m-p/89803#M40137</link>
      <description>Hi,

I'm using Get Worksheet as Collection in the Excel VBO. When the data comes through it's not the true value, it takes the value to only 2 decimals (as is seen in the raw excel format).

Other than formatting the existing .xlsx file, is there a way to draw in the raw data as a full value rather than truncated / rounded?

Thanks,

Pri</description>
      <pubDate>Wed, 12 Jul 2017 09:08:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Reading-Excel-as-truncated-rounded-values/m-p/89803#M40137</guid>
      <dc:creator>PriyankaTailor</dc:creator>
      <dc:date>2017-07-12T09:08:00Z</dc:date>
    </item>
    <item>
      <title>Hi Priyanka,</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Reading-Excel-as-truncated-rounded-values/m-p/89804#M40138</link>
      <description>Hi Priyanka,
I am not sure if this might help, But before your u use Get Worksheet, i suggest you format the cells using Format cell action. So you would not need to manually go in and change the format. Then use the Get Worksheet to import.
Thanks,
Hari</description>
      <pubDate>Thu, 13 Jul 2017 20:11:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Reading-Excel-as-truncated-rounded-values/m-p/89804#M40138</guid>
      <dc:creator>hari.murali</dc:creator>
      <dc:date>2017-07-13T20:11:00Z</dc:date>
    </item>
    <item>
      <title>Thank you for the response -</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Reading-Excel-as-truncated-rounded-values/m-p/89805#M40139</link>
      <description>Thank you for the response - has anyone out the successfully modified the code / created something that draws out the value?</description>
      <pubDate>Fri, 14 Jul 2017 04:10:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Reading-Excel-as-truncated-rounded-values/m-p/89805#M40139</guid>
      <dc:creator>PriyankaTailor</dc:creator>
      <dc:date>2017-07-14T04:10:00Z</dc:date>
    </item>
  </channel>
</rss>

