16,472
社区成员
发帖
与我相关
我的任务
分享
for(int setnum=0;setnum<listctrl.GetItemCount()+1;setnum++)
{
for(int num=0;num<4;num++)
{
if(!setnum)
{
range.SetItem(_variant_t((long)(setnum+1)),_variant_t((long)(num+1)),
_variant_t(sText[num]));
}
else
{
range.SetItem(_variant_t((long)(setnum+1)),_variant_t((long)(num+1)),
_variant_t(listctrl.GetItemText(setnum-1,num)));
}
}
}
pRange = pWorksheet->Range["C5"];
//文本模式 水平居中 垂直居中
pRange->NumberFormatLocal = "@";
pRange->HorizontalAlignment = xlCenter; //xlCenter = -4108,
pRange->VerticalAlignment = xlCenter;
pRange->WrapText = false;
pRange->Orientation = 0;
pRange->AddIndent = false;
pRange->IndentLevel = 0;
pRange->ShrinkToFit = false;
pRange->ReadingOrder = xlContext; //xlContext = -5002,
pRange->MergeCells = false;
pRange->ColumnWidth = 15.5;//列宽
pRange->Value = "001000100"; //数据