mirror of
https://github.com/jmcnamara/libxlsxwriter.git
synced 2026-05-16 14:15:58 -06:00
27 lines
872 B
C
27 lines
872 B
C
/*****************************************************************************
|
|
* Test cases for libxlsxwriter.
|
|
*
|
|
* Test to compare output against Excel files.
|
|
*
|
|
* Copyright 2014-2019, John McNamara, jmcnamara@cpan.org
|
|
*
|
|
*/
|
|
|
|
#include "xlsxwriter.h"
|
|
|
|
int main() {
|
|
|
|
lxw_workbook *workbook = workbook_new("test_array_formula01.xlsx");
|
|
lxw_worksheet *worksheet = workbook_add_worksheet(workbook, NULL);
|
|
|
|
worksheet_write_number(worksheet, 0, 1, 0, NULL);
|
|
worksheet_write_number(worksheet, 1, 1, 0, NULL);
|
|
worksheet_write_number(worksheet, 2, 1, 0, NULL);
|
|
worksheet_write_number(worksheet, 0, 2, 0, NULL);
|
|
worksheet_write_number(worksheet, 1, 2, 0, NULL);
|
|
worksheet_write_number(worksheet, 2, 2, 0, NULL);
|
|
|
|
worksheet_write_array_formula(worksheet, RANGE("A1:A3"), "{=SUM(B1:C1*B2:C2)}", NULL);
|
|
|
|
return workbook_close(workbook);
|
|
}
|