Esempi in C# (CSharp) per ExcelAddIn1 BillingUtils.GetCspRateCardMeterLineItemFields

Esempio n. 1

        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);
        }