int main()
{
BookHandle book = xlCreateBook();
if(book)
{
SheetHandle sheet = xlBookAddSheet(book, "Sheet1", 0);
if(sheet)
{
FormatHandle dateFormat;
xlSheetWriteStr(sheet, 2, 1, "Hello, World !", 0);
xlSheetWriteNum(sheet, 3, 1, 1000, 0);
dateFormat = xlBookAddFormat(book, 0);
xlFormatSetNumFormat(dateFormat, NUMFORMAT_DATE);
xlSheetWriteNum(sheet, 4, 1, xlBookDatePack(book, 2008, 4, 29, 0, 0, 0, 0), dateFormat);
xlSheetSetCol(sheet, 1, 1, 12, 0, 0);
}
if(xlBookSave(book, "example.xls")) printf("File example.xls has been created.\n");
xlBookRelease(book);
}
return 0;
}
static PyObject *
set_col(XLPySheet *self, PyObject *args, PyObject *kwargs)
{
int colFirst, colLast;
double width;
XLPyFormat *fmt = NULL;
PyObject *hidden = NULL;
static char *kwlist [] = {
"colFirst",
"colLast",
"width",
"format",
"hidden",
NULL
};
if(!PyArg_ParseTupleAndKeywords(args, kwargs, "iid|O!O!", kwlist,
&colFirst, &colLast, &width,
&XLPyFormatType, &fmt,
&PyBool_Type, &hidden)) {
return NULL;
}
if(!hidden) hidden = Py_False;
if(xlSheetSetCol(self->handler, colFirst, colLast, width,
(NULL != fmt) ? fmt->handler : 0,
PyObject_IsTrue(hidden))) {
Py_RETURN_TRUE;
}
Py_RETURN_FALSE;
}
int main()
{
BookHandle book = xlCreateBook();
if(book)
{
FontHandle font;
FormatHandle format;
SheetHandle sheet;
font = xlBookAddFont(book, 0);
xlFontSetName(font, L"Impact");
xlFontSetSize(font, 36);
format = xlBookAddFormat(book, NULL);
xlFormatSetAlignH(format, ALIGNH_CENTER);
xlFormatSetBorder(format, BORDERSTYLE_MEDIUMDASHDOTDOT);
xlFormatSetBorderColor(format, COLOR_RED);
xlFormatSetFont(format, font);
sheet = xlBookAddSheet(book, L"Custom", 0);
if(sheet)
{
xlSheetWriteStr(sheet, 2, 1, L"Format", format);
xlSheetSetCol(sheet, 1, 1, 25, 0, 0);
}
if(xlBookSave(book, L"format.xls")) printf("\nFile format.xls has been created.\n");
}
printf("\nPress any key to exit...");
_getch();
return 0;
}
int main()
{
BookHandle book = xlCreateXMLBook();
if(book)
{
FontHandle boldFont;
FontHandle titleFont;
FormatHandle titleFormat;
FormatHandle headerFormat;
FormatHandle descriptionFormat;
FormatHandle amountFormat;
FormatHandle totalLabelFormat;
FormatHandle totalFormat;
FormatHandle signatureFormat;
SheetHandle sheet;
boldFont = xlBookAddFont(book, 0);
xlFontSetBold(boldFont, 1);
titleFont = xlBookAddFont(book, 0);
xlFontSetName(titleFont, "Arial Black");
xlFontSetSize(titleFont, 16);
titleFormat = xlBookAddFormat(book, 0);
xlFormatSetFont(titleFormat, titleFont);
headerFormat = xlBookAddFormat(book, 0);
xlFormatSetAlignH(headerFormat, ALIGNH_CENTER);
xlFormatSetBorder(headerFormat, BORDERSTYLE_THIN);
xlFormatSetFont(headerFormat, boldFont);
xlFormatSetFillPattern(headerFormat, FILLPATTERN_SOLID);
xlFormatSetPatternForegroundColor(headerFormat, COLOR_TAN);
descriptionFormat = xlBookAddFormat(book, 0);
xlFormatSetBorderLeft(descriptionFormat, BORDERSTYLE_THIN);
amountFormat = xlBookAddFormat(book, 0);
xlFormatSetNumFormat(amountFormat, NUMFORMAT_CURRENCY_NEGBRA);
xlFormatSetBorderLeft(amountFormat, BORDERSTYLE_THIN);
xlFormatSetBorderRight(amountFormat, BORDERSTYLE_THIN);
totalLabelFormat = xlBookAddFormat(book, 0);
xlFormatSetBorderTop(totalLabelFormat, BORDERSTYLE_THIN);
xlFormatSetAlignH(totalLabelFormat, ALIGNH_RIGHT);
xlFormatSetFont(totalLabelFormat, boldFont);
totalFormat = xlBookAddFormat(book, 0);
xlFormatSetNumFormat(totalFormat, NUMFORMAT_CURRENCY_NEGBRA);
xlFormatSetBorder(totalFormat, BORDERSTYLE_THIN);
xlFormatSetFont(totalFormat, boldFont);
xlFormatSetFillPattern(totalFormat, FILLPATTERN_SOLID);
xlFormatSetPatternForegroundColor(totalFormat, COLOR_YELLOW);
signatureFormat = xlBookAddFormat(book, 0);
xlFormatSetAlignH(signatureFormat, ALIGNH_CENTER);
xlFormatSetBorderTop(signatureFormat, BORDERSTYLE_THIN);
sheet = xlBookAddSheet(book, "Invoice", 0);
if(sheet)
{
xlSheetWriteStr(sheet, 2, 1, "Invoice No. 3568", titleFormat);
xlSheetWriteStr(sheet, 4, 1, "Name: John Smith", NULL);
xlSheetWriteStr(sheet, 5, 1, "Address: San Ramon, CA 94583 USA", 0);
xlSheetWriteStr(sheet, 7, 1, "Description", headerFormat);
xlSheetWriteStr(sheet, 7, 2, "Amount", headerFormat);
xlSheetWriteStr(sheet, 8, 1, "Ball-Point Pens", descriptionFormat);
xlSheetWriteNum(sheet, 8, 2, 85, amountFormat);
xlSheetWriteStr(sheet, 9, 1, "T-Shirts", descriptionFormat);
xlSheetWriteNum(sheet, 9, 2, 150, amountFormat);
xlSheetWriteStr(sheet, 10, 1, "Tea cups", descriptionFormat);
xlSheetWriteNum(sheet, 10, 2, 45, amountFormat);
xlSheetWriteStr(sheet, 11, 1, "Total:", totalLabelFormat);
xlSheetWriteFormula(sheet, 11, 2, "=SUM(C9:C11)", totalFormat);
xlSheetWriteStr(sheet, 14, 2, "Signature", signatureFormat);
xlSheetSetCol(sheet, 1, 1, 40, 0, 0);
xlSheetSetCol(sheet, 2, 2, 15, 0, 0);
}
if(xlBookSave(book, "invoice.xlsx")) printf("\nFile invoice.xlsx has been created.\n");
xlBookRelease(book);
}
printf("\nPress any key to exit...");
_getch();
return 0;
}
