How to create and open Excel Template files by using XlsIO?

23 Nov 20219 minutes to read

Creating Excel Template Files

Excel template files (XLT or XLTX) can be created in XlsIO by saving a file as Template using ExcelSaveType enumeration. The following code snippet illustrates this.

using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Excel2013;

    IWorkbook workbook = application.Workbooks.Create(1);

    IWorksheet worksheet = workbook.Worksheets[0];

    //Save as XLT
    workbook.Version = ExcelVersion.Excel97to2003;
    workbook.SaveAs("XLTFile.xlt", ExcelSaveType.SaveAsTemplate);

    //Save as XLTX
    workbook.Version = ExcelVersion.Excel2007;
    workbook.SaveAs("XLTXFile.xltx", ExcelSaveType.SaveAsTemplate);
}
Using excelEngine As ExcelEngine = New ExcelEngine()
    Dim application As IApplication = excelEngine.Excel
    application.DefaultVersion = ExcelVersion.Excel2013

    Dim workbook As IWorkbook = application.Workbooks.Create(1)

    Dim worksheet As IWorksheet = workbook.Worksheets(0)

    'Save as XLT
    workbook.Version = ExcelVersion.Excel97to2003
    workbook.SaveAs("XLTFile.xlt", ExcelSaveType.SaveAsTemplate)

    'Save as XLTX
    workbook.Version = ExcelVersion.Excel2007
    workbook.SaveAs("XLTXFile.xltx", ExcelSaveType.SaveAsTemplate)
End Using
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Excel2013;
    IWorkbook workbook = application.Workbooks.Create(1);

    IWorksheet worksheet = workbook.Worksheets[0];
	
	//Save as XLT
	workbook.Version = ExcelVersion.Excel97to2003;
    FileSavePicker savePicker = new FileSavePicker();
    savePicker.SuggestedStartLocation = PickerLocationId.Desktop;
    savePicker.SuggestedFileName = "XLTFile";
    savePicker.FileTypeChoices.Add("Excel Files", new List<string>() { ".xlt" });
    StorageFile storageFile = await savePicker.PickSaveFileAsync();
    await workbook.SaveAsAsync(storageFile, ExcelSaveType.SaveAsTemplate);
	
	//Save as XLTX
	workbook.Version = ExcelVersion.Excel2007;
	FileSavePicker savePicker1 = new FileSavePicker();
    savePicker1.SuggestedStartLocation = PickerLocationId.Desktop;
    savePicker1.SuggestedFileName = "XLTXFile";
    savePicker1.FileTypeChoices.Add("Excel Files", new List<string>() { ".xltx" });
    StorageFile storageFile1 = await savePicker1.PickSaveFileAsync();
    await workbook.SaveAsAsync(storageFile1, ExcelSaveType.SaveAsTemplate);
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Excel2013;
    IWorkbook workbook = application.Workbooks.Create(1);

    IWorksheet worksheet = workbook.Worksheets[0];

	//Save as XLT
	workbook.Version = ExcelVersion.Excel97to2003;
	FileStream stream = new FileStream("XLTFile.xlt", FileMode.OpenOrCreate, FileAccess.ReadWrite);
    workbook.SaveAs(stream, ExcelSaveType.SaveAsTemplate);
	
	//Save as XLTX
	workbook.Version = ExcelVersion.Excel2007;
	FileStream stream1 = new FileStream("XLTXFile.xltx", FileMode.OpenOrCreate, FileAccess.ReadWrite);
    workbook.SaveAs(stream1, ExcelSaveType.SaveAsTemplate);

    workbook.Close();
    excelEngine.Dispose();
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Excel2013;
    IWorkbook workbook = application.Workbooks.Create(1);

    IWorksheet worksheet = workbook.Worksheets[0];

	//Save as XLT
	workbook.Version = ExcelVersion.Excel97to2003;
	MemoryStream stream = new MemoryStream();
    workbook.SaveAs(stream, ExcelSaveType.SaveAsTemplate);
    stream.Position = 0;
    Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("XLTFile.xlt", "application/vnd.ms-excel", stream);
	
	//Save as XLTX
	workbook.Version = ExcelVersion.Excel2007;
	MemoryStream stream1 = new MemoryStream();
    workbook.SaveAs(stream1, ExcelSaveType.SaveAsTemplate);
    stream1.Position = 0;
    Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("XLTXFile.xltx", "application/vnd.openxmlformats-officedocument.spreadsheetml.template", stream1);
}

Opening Excel Template Files

In XlsIO, an Excel template file is opened in the same way, as excel workbook (.xls and .xlsx) is opened. The following code snippet illustrates this.

ExcelEngine excelEngine = new ExcelEngine();

IApplication application = excelEngine.Excel;

application.DefaultVersion = ExcelVersion.Excel2013;

//Open Excel Template.

IWorkbook workbook = application.Workbooks.Open("Sample.xltx", ExcelOpenType.Automatic);

workbook.SaveAs("Output.xlsx");

workbook.Close();

excelEngine.Dispose();
Dim excelEngine As New ExcelEngine()

Dim application As IApplication = excelEngine.Excel

application.DefaultVersion = ExcelVersion.Excel2013

'Open Excel Template.

Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xltx", ExcelOpenType.Automatic)

workbook.SaveAs("Output.xlsx")

workbook.Close()

excelEngine.Dispose()
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    Stream inputStream = new FileStream("Sample.xltx", FileMode.Open, FileAccess.Read);
    IWorkbook workbook = await application.Workbooks.OpenAsync(inputStream, ExcelOpenType.Automatic);

    //Initializes FileSavePicker
    FileSavePicker savePicker = new FileSavePicker();
    savePicker.SuggestedStartLocation = PickerLocationId.Desktop;
    savePicker.SuggestedFileName = "Output";
    savePicker.FileTypeChoices.Add("Excel Files", new List<string>() { ".xlsx" });

    //Creates a storage file from FileSavePicker
    StorageFile storageFile = await savePicker.PickSaveFileAsync();

    //Saves changes to the specified storage file
    await workbook.SaveAsAsync(storageFile);
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    FileStream inputStream = new FileStream("Sample.xltx", FileMode.Open, FileAccess.Read);
    IWorkbook workbook = application.Workbooks.Open(inputStream, ExcelOpenType.Automatic);

    FileStream stream = new FileStream("Output.xlsx", FileMode.OpenOrCreate, FileAccess.ReadWrite);
    workbook.SaveAs(stream);

    workbook.Close();
    excelEngine.Dispose();
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    Assembly assembly = typeof(App).GetTypeInfo().Assembly;
    Stream fileStream = assembly.GetManifestResourceStream("App.Sample.xltx");
    IWorkbook workbook = application.Workbooks.Open(fileStream, ExcelOpenType.Automatic);

    MemoryStream stream = new MemoryStream();
    workbook.SaveAs(stream);

    stream.Position = 0;

    //Save the stream as a file in the device and invoke it for viewing
    Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("Output.xlsx", "application/msexcel", stream);
}

See Also