public void SetPrintTitleToRows(int firstRow, int lastRow)
{
XMLDefinedName xMLDefinedName = _sheetModel.NameManager.CreateDefinedName("_xlnm.Print_Titles");
xMLDefinedName.Content = string.Format(CultureInfo.InvariantCulture, "'{0}'!${1}:${2}", _sheetModel.Name.Replace("'", "''"), firstRow + 1, lastRow + 1);
xMLDefinedName.SheetIndex = _sheetModel.Position;
}
public XMLDefinedName CreateDefinedName(string name)
{
if (_workbook.DefinedNames == null)
{
_workbook.DefinedNames = new CT_DefinedNames();
}
CT_DefinedName cT_DefinedName = new CT_DefinedName();
XMLDefinedName result = new XMLDefinedName(cT_DefinedName)
{
Name = name
};
_workbook.DefinedNames.DefinedName.Add(cT_DefinedName);
return(result);
}
