Exemplo n.º 1
0
        public void Clear()
        {
            sheet.RemoveRange(RangeHelper.GetEntireCol(sheet, 1));
            sheet.RemoveRange(RangeHelper.GetEntireCol(sheet, 1));
            //.Delete(XlDeleteShiftDirection.xlShiftToLeft);

            for (int i = 1; i < startRowIndex; i++)
            {
                sheet.RemoveRange(RangeHelper.GetEntireRow(sheet, 1));
                // .Delete(XlDeleteShiftDirection.xlShiftUp);
            }
        }