如题如果大家有写好的代码操作EXCEL的pas希望能共享下
解决方案 »
- 自创一个比较隐晦的笑话
- 大家好,有什么办法可以从一个图片上获取文字,
- 调查:北京有多少单位不给上三险?
- SOS!! 请各位大侠解决filter问题,答对立即给分,在线!!
- (详细+说明+源码)热血传奇中周围有怪时如何使寻路终止?(目前需要鼠标点击一下))
- 谁能给个Delphi+access的管理系统,谢谢了!!!
- 请问如何在程序中运行帮助文件(*.chm or *.hlp)?
- 2请问BPL文件怎么安呢?
- 焦点自动跳到下一个控件的函数是Perform 高分伺候
- 请帮个忙,为什么第二次运行会出错(ADO),代码贴出来了
- listview为什么不显示列头(列标题)?
- 下列语句在运行时无论IMAGE中有无图片都提示'有图片'呀
Excelid.worksheets[1].Range['A2:A2'].Font.Superscript := True; //上标
Excelid.worksheets[1].Range['A2:A2'].Font.Subscript := True; //下标
With ActiveCell.Characters(Start:=1, Length:=1).Font
.Name = "宋体"
.FontStyle = "常规"
.Size = 11
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.ThemeFont = xlThemeFontMinor
End With
With ActiveCell.Characters(Start:=2, Length:=1).Font
.Name = "宋体"
.FontStyle = "常规"
.Size = 11
.Strikethrough = False
.Superscript = True
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.ThemeFont = xlThemeFontMinor
End With
With ActiveCell.Characters(Start:=3, Length:=1).Font
.Name = "宋体"
.FontStyle = "常规"
.Size = 11
.Strikethrough = False
.Superscript = False
.Subscript = True
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ThemeColor = xlThemeColorLight1
.TintAndShade = 0
.ThemeFont = xlThemeFontMinor
End With
我录制了一段宏 ,关于With ActiveCell.Characters(Start:=3, Length:=1).Font 这怎么在DELPHI里面写?上面是设置整个单元的,我想实现的是设置单元格里一两个字符的为上下标
Start, Length: OleVariant;
Start := 3;
Length := 2;
Excelid.ActiveCell.Characters[Start, Length].Font.FontStyle := 'Bold';
Excelid.worksheets[1].Range['A2:A2'].Characters[Start,Length].Font.Color
:= clFuchsia;
Excelid.worksheets[1].Range['A2:A2'].Characters[Start,Length].Font.Superscript
:= True;