Methods: Excel File Manipulation

In nearly all the file manipulation methods there will be an original (sPathOriginal) and target (sPathTarget) file specified as a parameter. Therefore, it should be understood that the original file does not have to be modified, but can be if you desire it to be. To modify the original file, specify it as both the original and target. To create a new file based on the original file, while leaving the original file unchanged, specify a target file that is different from the original file.

More:

AddSheet

ChangeNumberFormat

ChangePassword

CopySheet

CopySheetData

CopySheetDataEx

DeleteSheet

DeleteRowsOrColumns

FilesJustCreated

GetSheetNames

IsFileUnicode

MoveSheet

OpenXLSSaveAs

RenameSheet

SearchAndReplaceCellContent

SheetsJustProcessed

ShowSheetSelectionDialog

TransposeSheetData