Solved
JavaScript API for Excel sheet
Hi,
I have 2 queries related to JavaScript API for Excel sheets/workbooks.
1. Is there an API/library which can be reused to compare 2 excel sheets/workbooks? If yes, please give me the d...
Please keep in mind... this is a TestComplete forum so questions about APIs that are not part of TestComplete... probably not the best place for it.
That said, there are a couple of script extensions you can use that do the comparison.https://support.smartbear.com/viewarticle/9046/
https://support.smartbear.com/viewarticle/42199/
As for reading Excel via COM, there's plenty of documentation out there for that as it is Microsoft functionality, not TestComplete that you're looking for.
Again, that said... to select a particular sheet, you're going to go off of the Sheets collection of the workbook and apply the sheet name as the index. Check out https://docs.microsoft.com/en-us/office/vba/api/excel.sheets
