GrapeCity.Windows.SpreadSheet.Data Namespace : ExcelFileFormat Enumeration |
'Declaration Public Enum ExcelFileFormat Inherits System.Enum
'Usage Dim instance As ExcelFileFormat
public enum ExcelFileFormat : System.Enum
Member | Description |
---|---|
XLS | Uses BIFF (Binary Interchange File Format, which is well known as the default file format for Microsoft Office Excel 97-2003), the default file extension is .XLS. |
XLSM | Uses OpenXML and enable macro. |
XLSX | Uses OpenXML (Office Open XML, which is well known as the default file format for Microsoft Office Excel 2007), the default file extension is .XLSX. |
string f; f = "c:\\zipfile\\test1.xlsx"; // Open an existing file named test1.xlsx System.IO.FileStream s = new System.IO.FileStream(f, System.IO.FileMode.Open, System.IO.FileAccess.ReadWrite); gcSpreadSheet1.SaveExcel(s, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX); //gcSpreadSheet1.SaveExcel(s, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "12Test9"); //gcSpreadSheet1.SaveExcel(s, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly); //gcSpreadSheet1.SaveExcel(s, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly, "12Test9"); s.Close(); gcSpreadSheet1.Invalidate();
Dim f As String f = "c:\zipfile\test1.xlsx" ' Open an existing file named test1.xlsx Dim s As New System.IO.FileStream(f, System.IO.FileMode.Open, System.IO.FileAccess.ReadWrite) GcSpreadSheet1.SaveExcel(s, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX) 'GcSpreadSheet1.SaveExcel(s, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "12Test9") 'GcSpreadSheet1.SaveExcel(s, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly) 'GcSpreadSheet1.SaveExcel(s, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly, "12Test9") s.Close() GcSpreadSheet1.Invalidate()
System.Object
System.ValueType
System.Enum
GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat
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