Spread WPF Documentation
ExcelFileFormat Enumeration
Example Example 


GrapeCity.Windows.SpreadSheet.Data Namespace : ExcelFileFormat Enumeration
The type of Excel workbook.
Syntax
'Declaration
 
Public Enum ExcelFileFormat 
   Inherits System.Enum
'Usage
 
Dim instance As ExcelFileFormat
public enum ExcelFileFormat : System.Enum 
Members
MemberDescription
XLSUses 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.
XLSMUses OpenXML and enable macro.
XLSXUses OpenXML (Office Open XML, which is well known as the default file format for Microsoft Office Excel 2007), the default file extension is .XLSX.
Example
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
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace