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 ExportAnyData(CString filename, vector<string> &orders) { Book* book = xlCreateBook(); if(!book) return 0; for(vector<string>::iterator it = orders.begin(); it != orders.end(); it++) { CString Filename = it->c_str(); Filename += ".xml"; TiXmlElement *Root = getXMLRoot(Filename); Sheet* sheet = book->addSheet(it->c_str()); if(!sheet) return 0; addOneSheet(sheet, Root); delete Root->GetDocument(); } if(book->save(_T(filename.GetBuffer(0)) )) { return 1; } else { return 0; } book->release(); }
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; }