How to Compare 2 Excel Sheets?
We have this web application which needs comparison of values displayed inside an applet. We had managed to export the applet values into excel sheets but no idea how to validate the values inside an excel sheet. Or will any one suggest an idea for capturing the values from a "K grid".When ever we do try to capture the values inside the applet, we gets only the object level(kgrid).
NB:We have the Java addin installed.
Thanks in advance,
Re: How to Compare 2 Excel Sheets?
I think someone else has asked this exact question and the answer is ther but i'll post it here for you anyway:
You can import the .xls files to the run-time datatable with
and then parse through them and compare the data in the cells.
To do this add 2 sheets to the datatabel e.g.
DatatTable.addSheet "MySheet1" etc
and then import your data to the new sheets.
Once you've done that you can use the files as if they were any other datatable sheet.
If you need more detailed code let me know