| || |
Database Checkpoints - Compare with Excel
Can anybody please help me out on these queries.
1)How do I compare the values imported into a local sheet from an external excel sheet using a database checkpoint?
2)If the above option is not possible then How can I get the column header into a variable from a global sheet?
I have tried the following code setting the currentRow as both 0 and -1 but it doesn't work.
str2 = DataTable.Value(col,dtGlobalSheet)
Re: Database Checkpoints - Compare with Excel
2) This will give you the first column name from the Global data sheet.
</font><blockquote><font size="1" face="Verdana, Arial, Helvetica">code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">ParamName=DataTable.GlobalSheet.getPar ameter(1).name
msgbox ParamName </pre><hr /></blockquote><font size="2" face="Verdana, Arial, Helvetica">