Question:
I’ve got an Excel workbook composed by a series of pages (worksheets). One of them is called ‘Wholesales’. I’ve tried to retrieve values even with basic syntax:
select * from Wholesales
but with no result. What is going on?
Answer:
Excel does not answer SQL queries like this. If you need access to the Wholesales sheet of your workbook, you need to create an object reference to the Excel application and retrieve your values from the object reference. Something like this:
loxx = CreateObject('ExcelApplication')
or
loxx = new('excel')
Then interrogate the reference with words to the effect of “loxx.row.value”.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
