#include "BasicExcelVC6.hpp"//Excel头文件
//#include "codeCover.h"//
using namespace YExcel;//命名空间
void CDoExcelDlg::OnBnClickedButton1()
{
// TODO: 在此添加控件通知处理程序代码
BasicExcel excel;
bool bLoad=excel.Load("test.xls");
if (bLoad)
{
BasicExcelWorksheet* sheet = excel.GetWorksheet("Sheet1");//获取工作簿
sheet = excel.AddWorksheet("Sheet2", 1);//添加工作薄
//整形
sheet->Cell(0,0)->SetInteger(5);
//浮点型
BasicExcelCell* cell;
cell = sheet->Cell(0,1);//1行2列
cell->SetDouble(3.14159265359);
//一般字符串
sheet->Cell(0,2)->SetWString("helloworld");
//Unicode字符串
char *strGBK = "骆竞成⊙﹏⊙b汗";
sheet->Cell(0,3)->SetWString(strGBK);
//CTime currentTime=CTime::GetCurrentTime();
//CString strTime;
//strTime.Format(_T("%04d%02d%02d_%02d%02d%02d"),
// currentTime.GetYear(),
// currentTime.GetMonth(),
// currentTime.GetDay(),
// currentTime.GetHour(),
// currentTime.GetMinute(),
// currentTime.GetSecond()
// );
//USES_CONVERSION;
//strTime.Append(_T(".xls"));
excel.SaveAs("test1.xls");//(char*)T2CA(strTime)
}
else
{
MessageBox(_T("打开失败。。"));
}
}
void CDoExcelDlg::OnBnClickedButton2()
{
// TODO: 在此添加控件通知处理程序代码
BasicExcel excel;
//bool bLoad=excel.Load("test1.xls");
excel.New();
BasicExcelWorksheet* sheet = excel.GetWorksheet("Sheet1");//获取工作簿
size_t maxRows = sheet->GetTotalRows();
size_t maxCols = sheet->GetTotalCols();
for (size_t r=0; r<maxRows; ++r)
{
for (size_t c=0; c<maxCols; ++c)
{
BasicExcelCell* cell = sheet->Cell(r,c);
CString strData;
switch (cell->Type())
{
case BasicExcelCell::UNDEFINED:
break;
case BasicExcelCell::INT:
strData.Format(_T("%d"),cell->GetInteger());
break;
case BasicExcelCell::DOUBLE:
strData.Format(_T("%f"),cell->GetDouble());
break;
case BasicExcelCell::STRING:
case BasicExcelCell::WSTRING:
strData.Format(_T("%s"),cell->GetWString());
break;
}
ListBox.AddString(strData);
}
}
}