search for: newsheet2

Displaying 1 result from an estimated 1 matches for "newsheet2".

2009 Apr 27
1
RODBC - XLSX files - dropping/clearing sheets
...9;t clear or drop sheets from the XLSX files, as per the following example: > library(RODBC) > xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx; ReadOnly=False") > sqlClear(xlsx,"newsheet2",errors=TRUE) [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "HY000?Þêÿÿ\003 -5410 [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM." > sqlClear(xlsx,"newsheet2",errors=TRUE) [1] "[RODBC] ERROR: Could not SQLE...