SpreadsheetGear 2010
SaveAs(String,FileFormat) Method
See Also  Example Send Feedback
SpreadsheetGear Namespace > IWorkbook Interface > SaveAs Method : SaveAs(String,FileFormat) Method

filename
fileFormat
Saves this workbook using the specified filename and FileFormat, and updates the FullName property.

Syntax

Visual Basic (Declaration) 
Overloads Sub SaveAs( _
   ByVal filename As String, _
   ByVal fileFormat As FileFormat _
) 
C# 
void SaveAs( 
   string filename,
   FileFormat fileFormat
)

Parameters

filename
fileFormat

Example

C#Copy Code
class Program
{
    static void Main()
    {
        // Create a new empty workbook in a new workbook set.
        SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
        // Set Sheet1!A1 to "Hello World!".
        workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Hello World!";
        // Save to C:\MyData.xls as Excel file.
        workbook.SaveAs(@"C:\MyData.xls", SpreadsheetGear.FileFormat.XLS97);
        // Open C:\MyData.xls.
        workbook = SpreadsheetGear.Factory.GetWorkbook(@"C:\MyData.xls");
        // Output Sheet1!A1.
        System.Console.WriteLine(workbook.Worksheets["Sheet1"].Cells["A1"].Value.ToString());
    }
}
Visual BasicCopy Code
Module Program
    Sub Main()
        ' Create a new empty workbook in a new workbook set.
        Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook()
        ' Set Sheet1!A1 to "Hello World!".
        workbook.Worksheets("Sheet1").Cells("A1").Value = "Hello World!"
        ' Save to C:\MyData.xls as Excel file.
        workbook.SaveAs("C:\\MyData.xls", SpreadsheetGear.FileFormat.XLS97)
        ' Open C:\MyData.xls.
        workbook = SpreadsheetGear.Factory.GetWorkbook("C:\\MyData.xls")
        ' Output Sheet1!A1.
        System.Console.WriteLine(workbook.Worksheets("Sheet1").Cells("A1").Value.ToString())
    End Sub
End Module

Remarks

Note that the various workbook settings which make a workbook read-only in an end user workbookSet have no affect at this level.

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.