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 * date_pack(XLPyBook *self, PyObject *args) { int year, month, day, hour, min, sec, msec; if(!PyArg_ParseTuple(args, "iiiiiii", &year, &month, &day, &hour, &min, &sec, &msec)) { return NULL; } double pack = xlBookDatePack(self->handler, year, month, day, hour, min, sec, msec); return Py_BuildValue("d", pack); }