XLAutoFilter.hpp

Go to the documentation of this file.

#pragma once
 
#include "XLXmlParser.hpp"
#include <string>
 
namespace OpenXLSX
{
 
    enum class XLFilterLogic { And, Or };
 
    class XLFilterColumn
    {
    public:
        explicit XLFilterColumn(XMLNode node);
 
        void addFilter(const std::string& value);
 
        void clearFilters();
 
        void setCustomFilter(const std::string& op, const std::string& val);
 
        void setCustomFilter(const std::string& op1,
                             const std::string& val1,
                             XLFilterLogic      logic,
                             const std::string& op2,
                             const std::string& val2);
 
        void setTop10(double value, bool percent = false, bool top = true);
 
        void setDynamicFilter(const std::string& type);
 
        uint16_t colId() const;
 
    private:
        XMLNode m_node;
    };
 
    class XLCellRange;
 
    class XLAutoFilter
    {
    public:
        explicit XLAutoFilter(XMLNode node);
 
        operator bool() const;
 
        std::string ref() const;
 
        XLAutoFilter& setRef(const std::string& ref);
 
        XLAutoFilter& setRef(const XLCellRange& range);
 
        XLFilterColumn filterColumn(uint16_t colId);
 
    private:
        XMLNode m_node;
    };
 
}    // namespace OpenXLSX