 |
 |
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace > IWorkbook Interface : SaveAs Method |
|
|
SpreadsheetGear | The Performance Spreadsheet Component Company |
| SpreadsheetGear Namespace > IWorkbook Interface : SaveAs Method |
Saves this workbook using the specified filename and FileFormat, and updates the FullName property.
[Visual Basic]
Overridable Sub SaveAs( _
ByVal filename As String , _
ByVal fileFormat As FileFormat _
) [C#]
virtual void SaveAs(
string filename,
FileFormat fileFormat
);[C++]
virtual void SaveAs(
string * filename,
FileFormat fileFormat
) [C++/CLI]
virtual void SaveAs(
String ^ filename,
FileFormat fileFormat
) Note that the various workbook settings which make a workbook read-only in an end user workbookSet have no affect at this level.
[C#]
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 Basic]
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
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
IWorkbook Interface | IWorkbook Members
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.