讀寫 execel

網路找到一個class 可以讀寫  execel file

可以開worksheet, 寫入/讀取 int, floating

簡單的example 如下

int main(int argc, char* argv[])
{

    const char title[][20]={{"mean"},{"median"},{"deviation"},{"row dev"},{"column dev"}};

    BasicExcel  exl;
    BasicExcelWorksheet* sheet1;
    char* pchar;
    char* sname1="testsheet1";
    char* sname2="testsheet2";
    BasicExcelCell* cell;
    int i;

    exl.New(2);
    pchar=exl.GetAnsiSheetName(0);
    exl.RenameWorksheet((size_t)0,(const char*)sname1);
    exl.RenameWorksheet((size_t)1,(const char*)sname2);

    sheet1=exl.GetWorksheet((size_t)1);

    for( i=0;i<5;i++){
        cell=sheet1->Cell(0,i);
        cell->Set(title[i]);
    }

    for(i=0;i<5;i++){
        cell=sheet1->Cell(1,i);
        cell->Set(i);
    }


    exl.SaveAs("AndrewEx.xls");
    return 0;    
    

}