Esempi in C# (CSharp) per OfficeOpenXml ExcelWorksheet.ColumnCount

Esempio n. 1

        public static double ColumnsUsedWidth(this ExcelWorksheet ws)
        {
            double w = 0;

            for (var i = 1; i <= ws.ColumnCount(); i++)
            {
                w += ws.Column(i).Width;
            }
            return(w);
        }

Esempio n. 2

 public static ExcelRange UsedRange(this ExcelWorksheet ws) => ws.Cells[1, 1, ws.RowCount(), ws.ColumnCount()];