Monarch and personal altair slc ODBC appending rows to an existing excel sheet
Too long to post to a listserve, see github
github
https://github.com/rogerjdeangelis/utl-monarch-and-personal-altair-slc-odbc-appending-rows-to-an-existing-excel-sheet
OPS PROBLEM
I guess you're appending data to a worksheet in Excel? Maybe someone changed
the name of the worksheet? Or if you're using named ranges, perhaps a user
has inadvertently changed the name or shape of these?
SOLUTION
Personal altair slc ODBC works (should be able to use passthru to sql or slc proc sql)
Simple solution using, scan_text=no, does not work.
4416 libname xel "d:/xls/class.xlsx" scan_text=no;
ERROR: Option "scan_text" is not known for the LIBNAME statement
Monarch post
https://community.altair.com/discussion/comment/187055?tab=all#Comment_187055?utm_source=community-search&utm_medium=organic-search&utm_term=monarch+excel
see for scan_text=no solution
https://github.com/rogerjdeangelis/utl-appending-records-to-an-existing-excel-sheet
