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

Esempio n. 1

        public static void WriteRateCardOfferTermLineItem(int startColumnNumber, int rowNumber, Offerterm offerTermItem, 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.GetRateCardOfferTermLineItemFields(offerTermItem);
        }