public static void WriteUsageLineItemEa(int startColumnNumber, int rowNumber, Datum lineItem, int numberOfColumns, Microsoft.Office.Interop.Excel.Worksheet activeWorksheet) { Microsoft.Office.Interop.Excel.Range c1 = (Microsoft.Office.Interop.Excel.Range)activeWorksheet.Cells[rowNumber, startColumnNumber]; Microsoft.Office.Interop.Excel.Range c2 = (Microsoft.Office.Interop.Excel.Range)activeWorksheet.Cells[rowNumber, startColumnNumber + numberOfColumns - 1]; Microsoft.Office.Interop.Excel.Range currentRow = activeWorksheet.get_Range(c1, c2); currentRow.Value2 = BillingUtils.GetLineItemFieldsEa(lineItem); }
public static void WriteCspRateCardMeterLineItem(int startColumnNumber, int rowNumber, CspMeter meterItem, int numberOfColumns, Microsoft.Office.Interop.Excel.Worksheet activeWorksheet) { Microsoft.Office.Interop.Excel.Range c1 = (Microsoft.Office.Interop.Excel.Range)activeWorksheet.Cells[rowNumber, startColumnNumber]; Microsoft.Office.Interop.Excel.Range c2 = (Microsoft.Office.Interop.Excel.Range)activeWorksheet.Cells[rowNumber, startColumnNumber + numberOfColumns - 1]; Microsoft.Office.Interop.Excel.Range currentRow = activeWorksheet.get_Range(c1, c2); currentRow.Value2 = BillingUtils.GetCspRateCardMeterLineItemFields(meterItem); }