OpenSource——BasicExcel
前言：一年前在学数据库的时候，有个想法，就是怎么用代码来读取excel的数据；为此，我曾请教Boss Liu，Boss Liu指点说OpenSource里有我要的东西。由于一些小事情，耽搁了，结果这个想法就over了；没想到，现在我需要用上；既然如此，那我得好好学学。在此我要感谢Boss Liu的指导，否则对于这问题，我估计现在也不知道怎么解决；
正题：
BasicExcel
1.设计者：新加坡人Yap Chun Wei；
2.基本的功能（对excel里的sheet进行的操作）：
1）Read and write number (integers, real numbers) and strings (ANSI, UTF16)
2）Add worksheets
3）Rename worksheets
4）Delete worksheets
5）Get the name of a worksheet
3.优点：
1）采用com方式实现，访问速度快，api接口也比较简单
2）可以跨平台使用
4.一些操作（读取操作）的具体实现
1)prepare:
下载BasicExcel；说明：该包里面有四个文件，由于演示程序不是没用MFC，所以只需要将BasicExcel.hpp与BasicExcel.cpp放在你建的工程下面，或者可以将四个文件都放在你自己的类库中，然后导入；
使用的excel的名字：classification.data.xls
sheet的名字：analysis.data
2)show：
#include "BasicExcel.hpp"// Load a workbook with one sheet, display its contentsint main(int argc, char* argv[]){BasicExcel e;// load excele.Load("classification.data.xls");BasicExcelWorksheet* sheet = e.GetWorksheet("analysis.data");if (sheet){size_t maxRows = sheet->GetTotalRows();size_t maxCols = sheet->GetTotalCols();cout << "Dimension of " << sheet->GetAnsiSheetName() <<" (" << maxRows << ", " << maxCols << ")" << endl;for (size_t r = 0; r < maxRows; ++r){ printf("%10d", r+1); for (size_t c = 0; c < maxCols; ++c){BasicExcelCell* cell = sheet->Cell(r,c);switch (cell->Type()){case BasicExcelCell::UNDEFINED:printf(" ");break;case BasicExcelCell::INT:printf("%10d", cell->GetInteger());break;case BasicExcelCell::DOUBLE:printf("%10.6lf", cell->GetDouble());break;case BasicExcelCell::STRING:printf("%10s", cell->GetString());break;case BasicExcelCell::WSTRING:wprintf(L"%10s", cell->GetWString());break;} }cout << endl;}}else{printf("cannot read this sheet!\n");}cout << endl; return 0;}#include "BasicExcel.hpp"// Create a new workbook and write some contents.int main(int argc, char* argv[]){BasicExcel e;// create a workbooke.New();// create a sheetBasicExcelWorksheet* sheet = e.AddWorksheet("analysis.data");// cellBasicExcelCell* cell;if (sheet){size_t c;// SetStringfor (c = 0; c < 4; ++c){ cell = sheet->Cell(0, c); cell->SetString("property"); // sheet->Cell(0,c)->SetInteger("property");} // SetIntegerfor (c = 0; c < 4; ++c){ cell = sheet->Cell(1, c); cell->SetInteger(c); // sheet->Cell(1,c)->SetInteger(c);}// SetDoublefor (c = 0; c < 4; ++c){ cell = sheet->Cell(2, c); double data = c / 2.0; cell->SetDouble(data); // sheet->Cell(2,c)->SetDouble(data);}}// save to a excele.SaveAs("classification.data.xls");return 0;}
页:
[1]