C++ (Cpp) auto_filter Examples

Example #1

File: test_write.hpp Project: omegaluo/xlnt

    void test_write_auto_filter()
    {
        xlnt::workbook wb;
        auto ws = wb.get_sheet_by_index(0);
        ws.get_cell("F42").set_value("hello");
        ws.auto_filter("A1:F1");
        auto content = xlnt::writer::write_worksheet(ws, {"hello"}, {});
        TS_ASSERT(Helper::EqualsFileContent(PathHelper::GetDataDirectory() + "/writer/expected/sheet1_auto_filter.xml", content));

        content = xlnt::writer::write_workbook(wb);
        TS_ASSERT(Helper::EqualsFileContent(PathHelper::GetDataDirectory() + "/writer/expected/workbook_auto_filter.xml", content));
    }

Example #2

File: test_write_workbook.hpp Project: fhaoquan/xlnt

    void test_write_auto_filter()
    {
        xlnt::workbook wb;
        auto ws = wb.create_sheet();
        ws.get_cell("F42").set_value("hello");
        ws.auto_filter("A1:F1");
    
        xlnt::workbook_serializer serializer(wb);
        auto observed = serializer.write_workbook();

        auto diff = Helper::compare_xml(PathHelper::read_file("workbook_auto_filter.xml"), observed);
        TS_ASSERT(!diff);
    }

Example #3

File: worksheet.cpp Project: lyntel/xlnt

void worksheet::auto_filter(const xlnt::range &range)
{
    auto_filter(range.get_reference());
}

Example #4

File: worksheet.cpp Project: lyntel/xlnt

void worksheet::auto_filter(const std::string &reference_string)
{
    auto_filter(range_reference(reference_string));
}