半岛外围网上直营

LibXL是一个可以读写Excel文件的库，易用而且功能强大，不需要Microsoft Excel和.NET框架。它可以用作：

• 生成全新电子表格
• 从已有电子表格中提取数据
• 编辑已有电子表格

LibXL常见问答合集

C

#include "libxl.h"
int main()
{
    BookHandle book = xlCreateBook(); // xlCreateXMLBook()
    if(book) 
    {
        SheetHandle sheet = xlBookAddSheet(book, L"Sheet1");
        if(sheet) 
        {
            xlSheetWriteStr(sheet, 2, 1, L"Hello, World !", NULL);
            xlSheetWriteNum(sheet, 3, 1, 1000, NULL);
        }
        xlBookSave(book, L"example.xls");
        xlBookRelease(book);
    }
    return 0;
}

C++

#include "libxl.h"
using namespace libxl;

int main() 
{
    Book* book = xlCreateBook(); // xlCreateXMLBook() for xlsx
    if(book)
    {
        Sheet* sheet = book->addSheet(L"Sheet1");
        if(sheet)
        {
            sheet->writeStr(2, 1, L"Hello, World !");
            sheet->writeNum(3, 1, 1000);
        }
        book->save(L"example.xls");
        book->release();
    } 
    return 0;
}

C#

class Program
{ 
    static void Main(string[] args)
    {
        try 
        {
            Book book = new BinBook(); // use XmlBook() for xlsx
            Sheet sheet = book.addSheet("Sheet1");
            sheet.writeStr(2, 1, "Hello, World !");
            sheet.writeNum(3, 1, 1000);
            book.save("example.xls");    
        }
        catch (System.Exception e)
        {
            Console.WriteLine(e.Message);
        }
    }
}

Delphi

var

  Book: TBook;
  Sheet: TSheet;

begin

  Book := TBinBook.Create; // use TXmlBook() for xlsx
  Sheet := Book.addSheet('Sheet1');

  Sheet.writeStr(2, 1, 'Hello, World !');
  Sheet.writeNum(3, 1, 1000);

  Book.save('example.xls');
  Book.Free;

end;