Package ch.rabanti.picoxlsx4j

Class Column

  • public class Column
extends Object
    Class representing a column of a worksheet
    Author:
    Raphael Stoeckli

    • Constructor Detail

      • Column

        public Column()
        Default constructor

      • Column

        public Column​(String columnAddress)
        Constructor with column address
        Parameters:
        columnAddress - Column address (A to XFD)

      • Column

        public Column​(int number)
        Constructor with column number
        Parameters:
        number - Column number (zero-based, 0 to 16383)

    • Method Detail

      • setAutoFilter

        public void setAutoFilter​(boolean hasAutoFilter)
        Sets whether auto filter is enabled on the column
        Parameters:
        hasAutoFilter - If true, the column has auto filter applied, otherwise not

      • getColumnAddress

        public String getColumnAddress()
        Gets the column address
        Returns:
        Column address (A to XFD)

      • setColumnAddress

        public void setColumnAddress​(String columnAddress)
        Sets the column address
        Parameters:
        columnAddress - Column address (A to XFD)

      • getNumber

        public int getNumber()
        Gets the column number
        Returns:
        Column number (0 to 16383)

      • setNumber

        public void setNumber​(int number)
        Sets the column number
        Parameters:
        number - Column number (0 to 16383)

      • getWidth

        public float getWidth()
        Gets the width of the column
        Returns:
        Width of the column

      • setWidth

        public void setWidth​(float width)
        Sets the width of the column
        Parameters:
        width - Width of the column

      • hasAutoFilter

        public boolean hasAutoFilter()
        Gets whether auto filter is enabled on the column
        Returns:
        If true, the column has auto filter applied, otherwise not

      • isHidden

        public boolean isHidden()
        Gets whether the column is hidden or visible
        Returns:
        If true, the column is hidden, otherwise visible

      • setHidden

        public void setHidden​(boolean isHidden)
        Sets whether the column is hidden or visible
        Parameters:
        isHidden - If true, the column is hidden, otherwise visible