Can I disable SilkTest"s auto date/time conversion when reading Excel data?"
This can not be disabled, however there are a number of alternatives which can be implemented to retain the original formatting of the date/time data.
For example if a user has formatted their Excel data in the following way:
dd/mm/yyyy hh:mm == 20/07/1983 12:30
When read into SilkTest this would be re-formatted to: 1983-07-20 12:30
This can be over come by either of the following methods:
- Use of the FormatDateTime() function.
Utilising this function we can re-format the date into the users desired type, for example:
FormatDateTime (laData, "dd/mm/yyyy hh:mm")
- Use of the clipboard class.
This can be utilised to fully preserve the data formatting:
Copy the data from Excel to the clipboard and then to SilkTest thus preserving the original formatting:
[ ] MicrosoftExcelExcelbook1.SetActive ()