ExcelEraseSheet

A function added by the SUP NVSE Plugin.

Description

Erases specified sheet from specified Excel file.

Syntax

[help]

(iSuccess:int) ExcelEraseSheet filepath:string WorksheetID:int 

Or:

(iSuccess:int) XLSEraseSheet filepath:string WorksheetID:int

Example

ExcelEraseSheet "aaExcelFile" 0 

Will erase all cells in Sheet with index 0 from "aaExcelFile.xls"

Notes

• if file doesn't exists or can't be loaded (i.e. - it's open in Excel at the moment) - function returns -1.

See Also

• ExcelWriteFloat
• ExcelWriteString
• ExcelReadFloat
• ExcelReadString
• ExcelGetWorkSheetCount
• ExcelGetRowCount
• ExcelGetColCount
• ExcelSetSheetName
• ExcelGetCellValueType
• ExcelEraseCell