向excel中增加一个文本框,如何修改这个文本框的边框大小呢?
解决方案 »
- 有没有了解ole对象的!?我想知道“插入对象”(ole对象)对话框是哪个类??
- VC USB GUID问题?
- VC 里面如何区分哪些代码是新增加的?
- 不知哪位老大能提供USB狗模拟程序的框架
- CTreeCtrl中SetCheck
- 在网页内使用CSS后为什么用COM方法找不到body对象
- 用空格键或 Enter键以激活此控件????????????
- 我做了一个active按钮的控件,然后在容器中调用多个按钮,怎么来判别是哪个按钮被按下了呢~~~~~~
- 有的WINDOWS版本里没有MSXML3.DLL, 会导致我生成的XML文件读不出来,急
- VARIANT这个类型怎么转int型?
- win32API 与 DirectX是什么关系!
- PreTranslateMessage的简单问题 - 2 !
TextBoxes
TextBox
Shapes
Shape
?
72.75, 30.75).Select
Selection.Characters.Text = ""
With Selection.Font
.Name = "宋体"
.FontStyle = "常规"
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
Selection.ShapeRange.Line.Weight = 2.25
Selection.ShapeRange.Line.Visible = msoTrue
Selection.ShapeRange.Line.Style = msoLineSingle
Range("H19").Select
End Sub
Range rgMyRge;
LPDISPATCH lpDisp;
lpDisp=rgMyRge.GetBorders();
Borders bds;
bds.AttachDispatch(lpDisp);
Border bd;
lpDisp=bds.GetItem();//指定一个文本框
bd.AttachDispatch(lpDisp);
bd.SetLineStyle(COleVariant((short)1));
请问rgMyRge应初始化为哪些对象的集合?
AfxOleGetMessageFilter()->EnableBusyDialog(FALSE);//!!!!
AfxOleGetMessageFilter()->SetBusyReply(SERVERCALL_RETRYLATER);
AfxOleGetMessageFilter()->EnableNotRespondingDialog(TRUE);
AfxOleGetMessageFilter()->SetMessagePendingDelay(-1); if (!ExcelApp.CreateDispatch("Excel.Application", NULL))
{
AfxMessageBox("Excel!");
exit(1);
} ExcelApp.SetCaption("11"); if (!IsWindow(m_pExcelWnd->GetSafeHwnd()))
{
m_pExcelWnd = FindWindow("XLMAIN", "11");
} if (m_pExcelWnd == NULL)
{
AfxMessageBox("未找到Excel窗口。");
DestroyWindow();
return ;
} wbsMyBooks.AttachDispatch(ExcelApp.GetWorkbooks());
wbMyBook.AttachDispatch(wbsMyBooks.Add(_variant_t("c:\\book1.xlt")));
wssMysheets.AttachDispatch(wbMyBook.GetWorksheets());
wsMysheet.AttachDispatch(wssMysheets.GetItem(_variant_t((long)1)));
rgMyRge.AttachDispatch(wsMysheet.GetCells(),true);
rgMyRge.SetItem(_variant_t((long)1), _variant_t((long)1), _variant_t("111"));
rgMyRge.SetItem(_variant_t((long)2), _variant_t((long)1), _variant_t("222"));
rgMyRge.SetItem(_variant_t((long)3), _variant_t((long)1), _variant_t("333")); Shapes shapes;
Shape shape;
ShapeRange shaperange;
TextFrame textframe;
Characters m_Characters; shapes.AttachDispatch(wsMysheet.GetShapes(),true);
shape.AttachDispatch(shapes.AddTextbox(1, 40, 40, 60, 40), true); textframe.AttachDispatch(shape.GetTextFrame(), true);
m_Characters.AttachDispatch(textframe.Characters(COleVariant((short)1), COleVariant((short)3)), true);
m_Characters.SetText("通过"); Font font;
font = m_Characters.GetFont();
font.SetBold(covTrue);
font.SetName(COleVariant("华文中宋"));
font.SetSize(COleVariant((short)20));
font.SetColor(COleVariant("255"));
textframe.SetHorizontalAlignment(1); wbMyBook.SetSaved(true);
ExcelApp.SetVisible(true);
问题已经解决,感谢三位的关注!