怎样用DELPHI控制EXCEL中某一单元格的某一边框是否显示??
解决方案 »
- 串口通信
- Sql經典問題,高手們給指點指點
- 关于BDE配置连接数据库的问题!!!!
- 图片存储在sql server数据表中,请问如何将其打印出来?
- 怎样改变Tcanvas的背景颜色,这个貌似简单问题居然把我难住了
- 关于帮助文件的问题,急!(问题解决,马上给分)
- 在delphi中怎样清除和隐藏一个子窗口,急、急!!
- 在SCO UNIX shell中,如何判断进程是否在运行
- 当鼠标在listbox窗体上滑动时如何使滑过的文字高亮显示
- Socket服务器后,Socket客户程序总是连不上去"错误代码是10061".这样写好吗?我觉得可以解决Socket的线程问题.是我的ip写错了吗?
- 请大家帮忙做个评估。
- 窗体和字体的设置?
with Aname.RefersToRange,Borders do
begin
HorizontalAlignment:= xlRight;
Item[xlEdgeBottom].Weight:=xlMedium;
Item[xlEdgeTop].Weight:=xlMedium;
Item[xlInsideHorizontal].Weight:=xlThin;
item[xlInsideVertical].Weight:=xlThin;
end;
//先全加上边框
If RowsNum < 26 then
begin
Ranges := sheet.Range['A2:'+ char(Length(TimeNum) + 65)
+ IntToStr(Query1.RecordCount + 4)];
ranges.Borders.LineStyle := xlContinuous;
Ranges.WrapText := True;
end
else if RowsNum = 26 then
begin
Ranges := sheet.Range['A2:Z' + IntToStr(Query1.RecordCount + 4)];
ranges.Borders.LineStyle := xlContinuous;
Ranges.WrapText := True;
end
else if (RowsNum > 26) and (RowsNum <= 52) then
//Èç¹ûÓÐ26¸öº½°àÒÔÉÏ
begin
Ranges := sheet.Range['A2:A'+ char(Length(TimeNum) + 39)
+ IntToStr(Query1.RecordCount + 4)];
ranges.Borders.LineStyle := xlContinuous;
Ranges.WrapText := True;
end
else if (RowsNum > 52) and (RowsNum <= 78) then
//Èç¹ûÓÐ52¸öº½°àÒÔÉÏ78°àÒÔÏÂ
begin
Ranges := sheet.Range['A2:B'+ char(Length(TimeNum) + 13)
+ IntToStr(Query1.RecordCount + 4)];
ranges.Borders.LineStyle := xlContinuous;
Ranges.WrapText := True;
end
else if (RowsNum > 78) and (RowsNum <= 104) then
//Èç¹ûÓÐ52¸öº½°àÒÔÉÏ78°àÒÔÏÂ
begin
Ranges := sheet.Range['A2:C'+ char(Length(TimeNum) + 13)
+ IntToStr(Query1.RecordCount + 4)];
ranges.Borders.LineStyle := xlContinuous;
Ranges.WrapText := True;
end;
//再把不要的边框去掉
Ranges := sheet.Range['A3:A3'];
Ranges.borders[xlEdgeTop].LineStyle := xlNone;