Hi guys,
I want to use some values (like a name and a date) from the database and ‘ask’ SC to make connection with Excel to lookup in a worksheet a the value of a cell based on a name (in rows) and date (in columns). Is this possible?
A couple of options depending on your use case. If you wish to maintain data in an Excel spreadsheet, then this PHP library (PHPExcel) might help: https://github.com/PHPOffice/PHPExcel
Or, if you are able to import the data from Excel and store it in a SQL database (e.g. MySQL), then SC has an import utility under Database | Import Excel.
Full disclosure, I have not used either so I can not tell you how well they work