Saves this workbook using the current
FullName.
Syntax
Visual Basic (Declaration) | |
---|
Sub Save() |
Example
C# | Copy Code |
---|
class Program
{
static void Main()
{
// Create a new empty workbook set.
SpreadsheetGear.IWorkbookSet workbookSet = SpreadsheetGear.Factory.GetWorkbookSet();
// Create a new empty workbook in the workbook set.
SpreadsheetGear.IWorkbook workbook = workbookSet.Workbooks.Add();
// Save to C:\MyData.xls.
workbook.SaveAs("C:\\MyData.xls",
SpreadsheetGear.FileFormat.XLS97);
// Set Sheet1!A1 to "Hello World!".
workbook.Worksheets["Sheet1"].Cells["A1"].Value = "Hello World!";
// Save to C:\MyData.xls again.
workbook.Save();
// Close the workbook, removing it from the workbook set.
workbookSet.Workbooks.Close();
// Open the saved workbook from memory.
workbook = workbookSet.Workbooks.Open("C:\\MyData.xls");
// Output Sheet1!A1.
System.Console.WriteLine(workbook.Worksheets["Sheet1"].Cells["A1"].Value.ToString());
}
}
|
Visual Basic | Copy Code |
---|
Class Program
Shared Sub Main()
Dim workbookSet As SpreadsheetGear.IWorkbookSet = SpreadsheetGear.Factory.GetWorkbookSet()
Dim workbook As SpreadsheetGear.IWorkbook = workbookSet.Workbooks.Add()
workbook.SaveAs("C:\\MyData.xls", SpreadsheetGear.FileFormat.XLS97)
workbook.Worksheets("Sheet1").Cells("A1").Value = "Hello World!"
workbook.Save()
workbookSet.Workbooks.Close()
workbook = workbookSet.Workbooks.Open("C:\\MyData.xls")
System.Console.WriteLine(workbook.Worksheets("Sheet1").Cells("A1").Value.ToString())
End Sub
End Class
|
Remarks
Requirements
Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.
See Also