#include<iostream>
#include<stdio.h>
#include <windows.h>
#include "libxl.h"
using namespace std;
using namespace libxl;
#pragma comment(lib,"libxl.lib")
int main()
{
Book* book = xlCreateBook();
if (book)
{
Sheet* sheet = book->addSheet("Sheet1");
if (sheet)
{
sheet->writeStr(2, 1, "Hello, World !");
sheet->writeNum(4, 1, 1000);
sheet->writeNum(5, 1, 2000);
Font* font = book->addFont();
font->setColor(COLOR_RED);
font->setBold(true);
Format* boldFormat = book->addFormat();
boldFormat->setFont(font);
sheet->writeFormula(6, 1, "SUM(B5:B6)", boldFormat);
Format* dateFormat = book->addFormat();
dateFormat->setNumFormat(NUMFORMAT_DATE);
sheet->writeNum(8, 1, book->datePack(2008, 4, 29), dateFormat);
sheet->setCol(1, 1, 12);
}
if (book->save("example.xls"))
{
//::ShellExe
C++ libxl库读写Excel
本文详细介绍了C++中如何利用libxl库进行Excel文件的读取和写入操作,包括创建工作簿、设置单元格值、格式化样式等方面,帮助开发者高效处理Excel数据。
摘要由CSDN通过智能技术生成