int main() { Book* book = xlCreateBook(); if(book) { Font* font = book->addFont(); font->setName(L"Impact"); font->setSize(36); Format* format = book->addFormat(); format->setAlignH(ALIGNH_CENTER); format->setBorder(BORDERSTYLE_MEDIUMDASHDOTDOT); format->setBorderColor(COLOR_RED); format->setFont(font); Sheet* sheet = book->addSheet(L"Custom"); if(sheet) { sheet->writeStr(2, 1, L"Format", format); sheet->setCol(1, 1, 25); } if(book->save(L"format.xls")) { ::ShellExecute(NULL, L"open", L"format.xls", NULL, NULL, SW_SHOW); } } return 0; }
int main() { Book* book = xlCreateBook(); if(book) { Sheet* sheet = book->addSheet("Sheet1"); if(sheet) { sheet->writeStr(2, 1, "Hello, World !"); sheet->writeNum(3, 1, 1000); Format* dateFormat = book->addFormat(); dateFormat->setNumFormat(NUMFORMAT_DATE); sheet->writeNum(4, 1, book->datePack(2008, 4, 29), dateFormat); sheet->setCol(1, 1, 12); } if(book->save("example.xls")) std::cout << "\nFile example.xls has been created." << std::endl; book->release(); } std::cout << "\nPress any key to exit..."; _getch(); return 0; }