C# (CSharp) Microsoft.Office.Interop.Excel.Range.get_End Beispiele

Beispiel #1

        public void InputData(Microsoft.Office.Interop.Excel._Worksheet s, string cardname, string cmc, string[] type)
        {
            oRng = (Microsoft.Office.Interop.Excel.Range)s.Cells[s.Rows.Count, 1];
            long lastRow = oRng.get_End(Microsoft.Office.Interop.Excel.XlDirection.xlUp).Row;
            long newRow  = lastRow + 1;

            s.Cells[newRow, 1] = cardname;
            if (cmc == null)
            {
                s.Cells[newRow, 2] = 0;
            }
            else
            {
                s.Cells[newRow, 2] = cmc;
            }
            s.Cells[newRow, 3] = type;
        }