mirror of
https://github.com/jmcnamara/libxlsxwriter
synced 2025-03-28 21:13:14 +00:00
64 lines
2.1 KiB
C
64 lines
2.1 KiB
C
/*
|
|
* Tests for the libxlsxwriter library.
|
|
*
|
|
* SPDX-License-Identifier: BSD-2-Clause
|
|
* Copyright 2014-2025, John McNamara, jmcnamara@cpan.org.
|
|
*
|
|
*/
|
|
|
|
#include "../ctest.h"
|
|
#include "../helper.h"
|
|
|
|
#include "../../../include/xlsxwriter/worksheet.h"
|
|
#include "../../../include/xlsxwriter/table.h"
|
|
|
|
// Test assembling a complete Table file.
|
|
CTEST(worksheet, worksheet_table08) {
|
|
|
|
char* got;
|
|
char exp[] =
|
|
"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n"
|
|
"<table xmlns=\"http://schemas.openxmlformats.org/spreadsheetml/2006/main\" id=\"1\" name=\"Table1\" displayName=\"Table1\" ref=\"C3:F14\" totalsRowCount=\"1\">"
|
|
"<autoFilter ref=\"C3:F13\"/>"
|
|
"<tableColumns count=\"4\">"
|
|
"<tableColumn id=\"1\" name=\"Column1\" totalsRowLabel=\"Total\"/>"
|
|
"<tableColumn id=\"2\" name=\"Column2\"/>"
|
|
"<tableColumn id=\"3\" name=\"Column3\"/>"
|
|
"<tableColumn id=\"4\" name=\"Column4\" totalsRowFunction=\"count\"/>"
|
|
"</tableColumns>"
|
|
"<tableStyleInfo name=\"TableStyleMedium9\" showFirstColumn=\"0\" showLastColumn=\"0\" showRowStripes=\"1\" showColumnStripes=\"0\"/>"
|
|
"</table>";
|
|
|
|
FILE* testfile = lxw_tmpfile(NULL);
|
|
FILE* testfile2 = lxw_tmpfile(NULL);
|
|
|
|
lxw_worksheet *worksheet = lxw_worksheet_new(NULL);
|
|
worksheet->file = testfile2;
|
|
worksheet->sst = lxw_sst_new();
|
|
|
|
lxw_table *table = lxw_table_new();
|
|
table->file = testfile;
|
|
|
|
lxw_table_column col1 = {.total_string = "Total"};
|
|
lxw_table_column col2 = {0};
|
|
lxw_table_column col3 = {0};
|
|
lxw_table_column col4 = {.total_function = LXW_TABLE_FUNCTION_COUNT};
|
|
lxw_table_column *columns[] = {&col1, &col2, &col3, &col4, NULL};
|
|
|
|
lxw_table_options options = {.total_row = LXW_TRUE, .columns = columns};
|
|
|
|
worksheet_add_table(worksheet, RANGE("C3:F14"), &options);
|
|
|
|
table->table_obj = STAILQ_FIRST(worksheet->table_objs);
|
|
table->table_obj->id = 1;
|
|
|
|
lxw_table_assemble_xml_file(table);
|
|
|
|
RUN_XLSX_STREQ_SHORT(exp, got);
|
|
|
|
lxw_worksheet_free(worksheet);
|
|
lxw_table_free(table);
|
|
}
|
|
|
|
|