private void FormatCells(TimeInterval db) { if (m_dataTable.Columns.Count == 0) { return; } // Default format worksheet.UsedRange.Font.Color = SpreadsheetGear.Colors.Black; worksheet.Range["A:A"].Interior.Color = SpreadsheetGear.Colors.LightGray; worksheet.Range["A:A"].Font.Bold = true; worksheet.Range["A:A"].Font.Italic = true; worksheet.Range[0, 0, 0, m_dataTable.Columns.Count - 1].Interior.Color = SpreadsheetGear.Colors.LightGray; worksheet.Range[0, 0, 0, m_dataTable.Columns.Count - 1].Font.Bold = true; worksheet.Range[0, 0, 0, m_dataTable.Columns.Count - 1].Font.Italic = true; if (db == TimeInterval.Irregular) { for (int i = 1; i < m_dataTable.Columns.Count; i += 2) { string dataColumn = SpreadsheetGearExcel.ReferenceFromIndex(i); string flagColumn = SpreadsheetGearExcel.ReferenceFromIndex(i + 1); ConditionalFormatting(dataColumn, flagColumn); } } else if (db == TimeInterval.Monthly) { string dateRange = "A:A";// +m_dataTable.Rows.Count.ToString(); worksheet.Range[dateRange].NumberFormat = "mmm yyyy"; } }
private void FormatCells(TimeInterval db) { if (db == TimeInterval.Irregular) { for (int i = 1; i < m_dataTable.Columns.Count; i += 2) { string dataColumn = SpreadsheetGearExcel.ReferenceFromIndex(i); string flagColumn = SpreadsheetGearExcel.ReferenceFromIndex(i + 1); ConditionalFormatting(dataColumn, flagColumn); } } else if (db == TimeInterval.Monthly) { string dateRange = "A:A"; // +m_dataTable.Rows.Count.ToString(); worksheet.Range[dateRange].NumberFormat = "mmm yyyy"; } }
public void ColumnReferenceNames() { int i = SpreadsheetGearSeries.ColumnIndexFromRef("A"); Assert.AreEqual(0, i); i = SpreadsheetGearSeries.ColumnIndexFromRef("AA"); Assert.AreEqual(26, i); i = SpreadsheetGearSeries.ColumnIndexFromRef("IV"); Assert.AreEqual(255, i); string s = SpreadsheetGearExcel.ReferenceFromIndex(0); Assert.AreEqual("A", s); s = SpreadsheetGearExcel.ReferenceFromIndex(26); Assert.AreEqual("AA", s); s = SpreadsheetGearExcel.ReferenceFromIndex(255); Assert.AreEqual("IV", s); }