CopyCellStyle Method

Copies a cell style from a template.

Syntax

[VB.NET]
Public Sub CopyCellStyle(ByVal Cell As String)

[C#]
public void CopyCellStyle(string cell);

Remarks

This method copies a cell style defined in the specified TemplateFile.

Before calling this method TemplateFile must be set to a valid Excel template file (.xltx). The Cell property should be set to the cell or range where the style will be applied. The Cell parameter to this method defines the source location in TemplateFile from where the style will be copied. For example:

excelDoc.Template = "./files/template.xltx";
excelDoc.Cell = "C4:H12"; //Destination
excelDoc.CopyCellStyle("Sheet1!b3:e5"); //Source