ExcelEraseCell

A function added by the SUP NVSE Plugin.

Description

Erases specified cell from specified Excel file.

Syntax

[help]

(iSuccess:int) ExcelEraseCell filepath:string WorksheetID:int Row:int Column:int 

Or:

(iSuccess:int) XLSEraseCell filepath:string WorksheetID:int Row:int Column:int

Example

ExcelEraseCell "aaExcelFile" 0 4 1  

Will erase Cell[4;1] 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
• ExcelEraseSheet