/// <summary> /// Setting value for a spreadsheet cell /// <remarks>Author:Johann Granados Company: Staff DotNet Creation Date: 8/30/2008</remarks> /// </summary> public override void SetCellStyle(string worksheetName, int fromRow, int toRow, short fromColumn, short toColumn, string cellStyle) { WorksheetAccessor.SetCellStyle(Worksheets.Get(worksheetName), fromColumn, toColumn, fromRow, toRow, cellStyle); }
/// <summary> /// Setting width for a range of columns /// <remarks>Author:Johann Granados Company: Staff DotNet Creation Date: 8/30/2008</remarks> /// </summary> public override void SetColumnWidth(string worksheetName, short fromColumn, short toColumn, int width) { WorksheetAccessor.SetColumnWidth(Worksheets.Get(worksheetName), fromColumn, toColumn, width); }
/// <summary> /// Set Table Style for cell range /// </summary> /// <param name="worksheetName">Worksheet name to add the table to</param> /// <param name="tableStyle">Style to be assigned to the table</param> /// <param name="useHeaders">Set a header row</param> /// <param name="fromColumn">Table initial column</param> /// <param name="toColumn">Table final column</param> /// <param name="fromRow">Table initial row</param> /// <param name="toRow">Table final row</param> public override void AddTable(string worksheetName, string tableStyle, bool useHeaders, short fromColumn, short toColumn, int fromRow, int toRow) { Tables.Add(Worksheets.Get(worksheetName), tableStyle, useHeaders, fromColumn, toColumn, fromRow, toRow); }