【无标题】

libxl的setAlignH和setAlignV的不同参数组合效果

libxl的setAlignH和setAlignV的不同参数组合效果

开发工具VC6，libxl V3.9.3

头文件

#include “libxl.h”
#include
#pragma comment(lib,“libxl.lib”)
using namespace libxl;

VC6代码

Book* book = xlCreateXMLBook();

Sheet* sheet = book->addSheet("my");

sheet->setDisplayGridlines(false);

CString nameAlignH[] = {"ALIGNH_GENERAL", "ALIGNH_LEFT", "ALIGNH_CENTER", "ALIGNH_RIGHT", "ALIGNH_FILL", "ALIGNH_JUSTIFY", "ALIGNH_MERGE", "ALIGNH_DISTRIBUTED"};
AlignH alignH[] = {ALIGNH_GENERAL, ALIGNH_LEFT, ALIGNH_CENTER, ALIGNH_RIGHT, ALIGNH_FILL, ALIGNH_JUSTIFY, ALIGNH_MERGE, ALIGNH_DISTRIBUTED};

CString nameAlignV[] = {"ALIGNV_TOP", "ALIGNV_CENTER", "ALIGNV_BOTTOM", "ALIGNV_JUSTIFY", "ALIGNV_DISTRIBUTED"};
AlignV alignV[] = {ALIGNV_TOP, ALIGNV_CENTER, ALIGNV_BOTTOM, ALIGNV_JUSTIFY, ALIGNV_DISTRIBUTED};

for(int i = 0; i < sizeof(nameAlignH) / sizeof(CString); ++i)
{
	sheet->setRow(i+1,  60);
  
	Format* format = book->addFormat();
    format->setAlignH(alignH[i]);
	for(int j=0;j<sizeof(nameAlignV) / sizeof(CString);++j)
	{
		 sheet->setCol(j, j, 20);
		format->setAlignV(alignV[j]);
		format->setBorder();
		sheet->writeStr(i+1, 0, nameAlignH[i], format);
		sheet->writeStr(i+1, 1, nameAlignV[j], format);
		sheet->writeStr(i+1, 2, nameAlignH[i]+"\n非官方个过分过分过分", format);
	}
}    


book->save("acb.xlsx");

book->release();
MessageBox("ok");

效果

|

参考文献
https://www.libxl.com/aligning-colors-borders.html