I have an Excel file I am trying to get the plain text value from the cell. The formatted value in the cell is $ 9.6995, however the value when clicking on the cell the plain text I need to get is 9.699459. I need to get this full value out of the file. When telling Automate to use the formatted value I get back 9.6995, if I don't use formatted value I get back $ 9.6995.

Can someone help me get the full plain text value I expect?

Category Survey AutoMate 10 version: 10.7.0 Windows version: Windows Server 2012 R2

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
This line gives me 9.6995: <AMEXCEL ACTIVITY="get_cell" AM_SETVAR="Price;0" AM_ONERROR="CONTINUE" SESSION="TradeFileDocument" ACTION="cellbyposition" RESULTVARIABLE="Price" CELLROW="%TradeRow%" CELLCOLUMN="%MappingData.priceLocation%" FORMATTEDVALUE="YES" WORKSHEET="%TradeSheet%" /> This line gives me $ 9.6995: <AMEXCEL ACTIVITY="get_cell" AM_SETVAR="Price;0" AM_ONERROR="CONTINUE" SESSION="TradeFileDocument" ACTION="cellbyposition" RESULTVARIABLE="Price" CELLROW="%TradeRow%" CELLCOLUMN="%MappingData.priceLocation%" FORMATTEDVALUE="YES" WORKSHEET="%TradeSheet%" />

Hi Lauren,

I found using the OpenDocument action instead of the Excel action returned the whole price. Please give this a try.

Category Survey

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMODS ACTIVITY="get_cell" WORKBOOK="C:\Users\dcannon\Desktop\price.xlsx" ACTION="cellbyposition" RESULTVARIABLE="Price" CELLROW="1" CELLCOLUMN="1" VALUETYPE="formatted_value" />

-------------------------

Devin Cannon | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665