Example #1
0
 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);
 }
Example #2
0
        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);
        }