'Declaration Public Enum ExcelFileFormat Inherits System.Enum
'Usage Dim instance As ExcelFileFormat
public enum ExcelFileFormat : System.Enum
'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. |
gcSpreadSheet1.Sheets[0].ColumnHeader.Columns[0].Label = "Label"; gcSpreadSheet1.Sheets[0].Cells[0, 0, 2, 2].Text = "test"; gcSpreadSheet1.Invalidate(); private void button1_Click(object sender, RoutedEventArgs e) { //gcSpreadSheet1.SaveExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX); //gcSpreadSheet1.SaveExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "1NaMe5"); //gcSpreadSheet1.SaveExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders); gcSpreadSheet1.SaveExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders, "1NaMe5"); gcSpreadSheet1.Invalidate(); }
GcSpreadSheet1.Sheets(0).ColumnHeader.Columns(0).Label = "Label" GcSpreadSheet1.Sheets(0).Cells(0, 0, 2, 2).Text = "test" GcSpreadSheet1.Invalidate() Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click GcSpreadSheet1.SaveExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX) 'GcSpreadSheet1.SaveExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "1NaMe5") 'GcSpreadSheet1.SaveExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders) 'GcSpreadSheet1.SaveExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders, "1NaMe5") 'GcSpreadSheet1.Invalidate() End Sub
System.Object
System.ValueType
System.Enum
GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat