Excel Import into DataTable
I have a problem with Excel Import into Data Table.
When i'm importing a Date column from the excel into Data table of QTP, it is showing it as "Hide 179" in the Data table.If i manually format the column in QTP, it is working fine.I want to do this programmatically or import the exact values.
How to do this?
Thanks in Advance.
Re: Excel Import into DataTable
QTP does not use Excel and may cause these thing when importing a sheet. You should disable all formating in the source sheet. Also i make my script format the date in the required format rather then relying on the data table format