// outputExcel.cpp : 定义控制台应用程序的入口点。
//
#include "stdafx.h"
#include "WriteExcel.h"
int main(int argc, _TCHAR* argv[])
{
FILE *f = fopen ("c://正在.xls", "wb");
miniexcel::CMiniExcel miniexcel;
for(int i=0; i<65535; i++)
{
miniexcel(i,1) = "姓名";
miniexcel(i,1).setBorder(BORDER_LEFT | BORDER_TOP | BORDER_BOTTOM);
miniexcel(i,1).setAlignament(ALIGN_CENTER);
miniexcel.SetColumnWidth(1,20);
miniexcel(i,2) = "性别";
miniexcel(i,2).setBorder(BORDER_LEFT | BORDER_TOP | BORDER_BOTTOM);
miniexcel(i,2).setAlignament(ALIGN_CENTER);
miniexcel.SetColumnWidth(2,10);
miniexcel(i,3) = "出生日期";
miniexcel(i,3).setBorder(BORDER_LEFT | BORDER_TOP | BORDER_BOTTOM | BORDER_RIGHT);
miniexcel(i,3).setAlignament(ALIGN_CENTER);
miniexcel.SetColumnWidth(3,30);
miniexcel(i,1) = 188;
miniexcel(i,1).setBorder(BORDER_LEFT | BORDER_BOTTOM);
miniexcel(i,1).setAlignament(ALIGN_CENTER);
miniexcel(i,2) = "男";
miniexcel(i,2).setBorder(BORDER_LEFT | BORDER_BOTTOM);
miniexcel(i,2).setAlignament(ALIGN_CENTER);
miniexcel(i,3) = "1986-11-11";
miniexcel(i,3).setBorder(BORDER_LEFT | BORDER_BOTTOM | BORDER_RIGHT);
miniexcel(i,3).setAlignament(ALIGN_CENTER);
}
miniexcel.Write(f);
return 0;
}
//
#include "stdafx.h"
#include "WriteExcel.h"
int main(int argc, _TCHAR* argv[])
{
FILE *f = fopen ("c://正在.xls", "wb");
miniexcel::CMiniExcel miniexcel;
for(int i=0; i<65535; i++)
{
miniexcel(i,1) = "姓名";
miniexcel(i,1).setBorder(BORDER_LEFT | BORDER_TOP | BORDER_BOTTOM);
miniexcel(i,1).setAlignament(ALIGN_CENTER);
miniexcel.SetColumnWidth(1,20);
miniexcel(i,2) = "性别";
miniexcel(i,2).setBorder(BORDER_LEFT | BORDER_TOP | BORDER_BOTTOM);
miniexcel(i,2).setAlignament(ALIGN_CENTER);
miniexcel.SetColumnWidth(2,10);
miniexcel(i,3) = "出生日期";
miniexcel(i,3).setBorder(BORDER_LEFT | BORDER_TOP | BORDER_BOTTOM | BORDER_RIGHT);
miniexcel(i,3).setAlignament(ALIGN_CENTER);
miniexcel.SetColumnWidth(3,30);
miniexcel(i,1) = 188;
miniexcel(i,1).setBorder(BORDER_LEFT | BORDER_BOTTOM);
miniexcel(i,1).setAlignament(ALIGN_CENTER);
miniexcel(i,2) = "男";
miniexcel(i,2).setBorder(BORDER_LEFT | BORDER_BOTTOM);
miniexcel(i,2).setAlignament(ALIGN_CENTER);
miniexcel(i,3) = "1986-11-11";
miniexcel(i,3).setBorder(BORDER_LEFT | BORDER_BOTTOM | BORDER_RIGHT);
miniexcel(i,3).setAlignament(ALIGN_CENTER);
}
miniexcel.Write(f);
return 0;
}