Save(String,ExcelFileType,String) Method

Save the workbook to file, it will use the specified file type as the file format, the file will be encrypt if the password is not null.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub Save( _
   ByVal file As System.String, _
   ByVal fileFormat As ExcelFileType, _
   Optional ByVal password As System.String _
)

'Usage
 
Dim instance As ExcelWorkbook
Dim file As System.String
Dim fileFormat As ExcelFileType
Dim password As System.String
 
instance.Save(file, fileFormat, password)

public void Save( 
   System.string file,
   ExcelFileType fileFormat,
   System.string password
)

Parameters

file: The file name the workbook will be saved in.
fileFormat: the ExcelFileType specifics the file type. there are two major file type in Excel, if you want to save an Excel 97-2003 compatible file, use GrapeCity.Excel.ExcelFileType.Biff, otherwise, use ExcelFileType.OpenXML to save a Excel 2007 or later file.
password: The password which will be used to encrypt the file.

Exceptions

Exception	Description
System.InvalidOperationException	Throw when the file has invalid extension.

Remarks

It will check whether the file extension is matched with the ExcelFileType parameter. That is to say, if the value of the fileFormat is ExcelFileType.BIFF, the extension of file should be .xls, and so on.

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

ExcelWorkbook Class
ExcelWorkbook Members
Overload List