如何用C語言讀入和輸出excel裏的數據？

具體實現

壹、 包含Excel文件操作類頭文件

#include "CSpreadSheet.h"

二、 新建Excel文件，並寫入默認數據

// 新建Excel文件名及路徑，TestSheet為內部表名

CSpreadSheet SS("c:\\Test.xls", "TestSheet");

CStringArray sampleArray, testRow;

SS.BeginTransaction();

// 加入標題

sampleArray.RemoveAll();

sampleArray.Add("姓名");

sampleArray.Add("年齡");

SS.AddHeaders(sampleArray);

// 加入數據

CString strName[] = {"徐景周","徐誌慧","郭徽","牛英俊","朱小鵬"};

CString strAge[] = {"27","23","28","27","26"};

for(int i = 0; i < sizeof(strName)/sizeof(CString); i++)

{

sampleArray.RemoveAll();

sampleArray.Add(strName[i]);

sampleArray.Add(strAge[i]);

SS.AddRow(sampleArray);

}

SS.Commit();

三、 讀取Excel文件數據

CSpreadSheet SS("c:\\Test.xls", "TestSheet");

CStringArray Rows, Column;

//清空列表框

m_AccessList.ResetContent();

for (int i = 1; i <= SS.GetTotalRows(); i++)

{

// 讀取壹行

SS.ReadRow(Rows, i);

CString strContents = "";

for (int j = 1; j <= Rows.GetSize(); j++)

{

if(j == 1)

strContents = Rows.GetAt(j-1);

else

strContents = strContents + " --> " + Rows.GetAt(j-1);

}

m_AccessList.AddString(strContents);

}