Is it Possible To Format the Workbook Cells A Test Script Reads In?
I am currently attempting to read in values from an excel file and compare them with values that appear on my test site.
However, since they are monetary values, the default value in the workbook will not match the value on the test site EX: Workbook cell value = 25, Test Site Value = 25.00.
I have tried changing the format in the Excel document to change the values to the correct format I want, but when my script reads the values in, they are unformatted.
Is there a function for workbooks to set the format of data I read in? I have tried searching but I have not been able to find the functions for workbooks/excel sheets that are supported through TestComplete.
joseph_michaud ... handy to know. I wasn't aware of the ".text" property.
(Everything on my spreadsheets - and I use a LOT of them - comes with a letter prefix to indicate what the data should be used for. So everything is treated as strings. Keeps it simple!)