Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Can I disable SilkTest"s auto date/time conversion when reading Excel data?"

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 ()
[ ] WorkSheet.SetActive ()
[ ] WorkSheet.Click (1, 60, 31)
[ ] WorkSheet.TypeKeys ("")
[ ]
[ ] lsClipboardContents = Clipboard.GetText()
[ ] then parsing code follows...........


Old KB# 23574

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:36
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.