HKosova
10 years agoSmartBear Alumni (Retired)
Excel has an automation API that lets you do exactly that. You can access the Excel scripting object as Sys.OleObject("Excel.Application"), and from there you can access the workbooks, sheets, the data and so on.
Here're some examples:
Excel COM API info
Working With Excel Files via COM
Search for Text in MS Excel
Is this is not what you are looking for, could you clarify please?
Related Content
- 7 years ago
- 4 years ago
- 6 years ago