Version

Save and Load Files in Excel Template Format

The Infragistics Excel library enables you to define template files in three file formats. The three template formats are the Excel Template format (with extension XLTX), the Excel Macro-Enabled Template format (with extension XLTM), and the Excel 97-2003 Template format (with extension XLT). You can save and load files in these formats.

The WorkbookFormat enumeration has the values Excel2007Template, Excel2007MacroEnabledTemplate, and Excel97To2003Template that correspond to the XLTX, XLTM, and XLT formats. The CurrentFormat property can be used to get the current format of the file. When loading a file if the extension is unknown, the contents of the file will be parsed to dynamically determine the correct format.

The following code illustrates saving an Excel file in the Excel2007Template format using the Save method.

In Visual Basic:

' Create a workbook and set its format to Excel2007Template 
Dim newWorkBook As Infragistics.Documents.Excel.Workbook = New Workbook(WorkbookFormat.Excel2007Template)
' Add a worksheet to the workbook 
Dim worksheet1 As Infragistics.Documents.Excel.Worksheet = newWorkBook.Worksheets.Add("Sheet1")
' Format a cell in the worksheet 
worksheet1.Rows(1).Cells(1).CellFormat.FillPatternBackgroundColor = Color.Red 
' Save the workbook 
newWorkBook.Save("C:ExcelBookTemplate.xltx")

In C#:

// Create a workbook and set its format to Excel2007Template
Infragistics.Documents.Excel.Workbook newWorkBook = new Workbook(WorkbookFormat.Excel2007Template);
// Add a worksheet to the workbook
Infragistics.Documents.Excel.Worksheet worksheet1 = newWorkBook.Worksheets.Add("Sheet1");
// Format a cell in the worksheet
worksheet1.Rows[1].Cells[1].CellFormat.FillPatternBackgroundColor = Color.Red;
// Save the workbook
newWorkBook.Save("C:ExcelBookTemplate.xltx");

The following code shows you how to modify the format of an Existing Excel file using the SetCurrentFormat method.

In Visual Basic:

' Load an Existing Excel file 
Dim workbook As Infragistics.Documents.Excel.Workbook = Infragistics.Documents.Excel.Workbook.Load("C:Book1.xlsx")
' Change the format to Excel2007Template 
workbook.SetCurrentFormat(WorkbookFormat.Excel2007Template) 
' Save the file in the modified format 
workbook.Save("C:ModifiedBook1.xltx")

In C#:

// Load an Existing Excel file
Infragistics.Documents.Excel.Workbook workbook = Infragistics.Documents.Excel.Workbook.Load("C:Book1.xlsx");
// Change the format to Excel2007Template
workbook.SetCurrentFormat(WorkbookFormat.Excel2007Template);
// Save the file in the modified format
workbook.Save("C:ModifiedBook1.xltx");

View on GitHub