public static void ReportDataOfElectricityMeterConsumption_tariffz(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null) { if (dataRow != null) { int mean_index = 10; if (dataRow.Length > mean_index && (string)dataRow[mean_index] == "Сумма") { x.Offset(mean_index).Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromName(ColorName.Orange), SpreadsheetColor.FromName(ColorName.Orange)); } } }
public static void EmptyWeaponStyle(GemboxTableHandler.Table.Range x, object[] dataRow = null, object GlobalConditionsObject = null) { if (dataRow != null) { //Link to description COLUMN INDEX ["Description" is 8th]; TODO: fast way to link by column name int mean_index = 8; if (dataRow.Length > mean_index && dataRow[mean_index] == null) { x.Offset(mean_index).Resize(4).Style.FillPattern.SetPattern(FillPatternStyle.Solid, SpreadsheetColor.FromArgb(255, 188, 192), SpreadsheetColor.FromArgb(255, 188, 192)); } //paint next 4 columns } }