Sub Count_Selection()
Dim cell As Object
Dim count As Integer
count = 0
For Each cell In Selection
count = count + 1
Next cell
MsgBox count & " item(s) selected"
End Sub
Dim cell As Object
Dim count As Integer
count = 0
For Each cell In Selection
count = count + 1
Next cell
MsgBox count & " item(s) selected"
End Sub
解决方案 »
- EXE主窗体改变尺寸时,窗体中的Panel也会跟着变(Panel.Align设为了alClient),但其中嵌入的DLL窗体不会跟着变
- 学习的迷茫 请用Delphi 开发数据库经验的朋友来指点!!!
- 请教一个有关clientdataset的问题!问题可能会比较多!
- DrawGrid1单元格多行文本垂直居中显示的最简单方法
- 用DBgridEh汇总感觉好慢,请高手指点
- 求救:改变文件目录名称和删除文件目录以及目录中的所有文件的涵数是什么
- office文档在delphi应用程序中的问题
- 想求一份程序员的工作(DELPHI+SQL2000)
- 该死的DATA MODULE类,我要杀了他!!!!!!!!!!!!!!!
- 怎样在DBGrid的title中图标啊?
- delphi编译出来的exe文件突然变的很大
- 动态菜单
begin
ExcelApplication1.Connect;
ExcelApplication1.Workbooks.Add(EmptyParam, 0);
ExcelApplication1.Visible[0] := True;
(ExcelApplication1.Worksheets.Item[1] as _Worksheet).Range['E1', 'E5'].Select;
end;procedure TForm1.Button2Click(Sender: TObject);
var
Enum: IEnumVariant;
Selection: OleVariant;
Application: OleVariant;
Count: Integer;
rgVar: OleVariant;
vFetched: Longword;
begin
Application := ExcelApplication1.Application;
Selection := Application.Selection;
Enum:= IUnknown(Selection._NewEnum) as IEnumVariant;
Count := 0;
while Enum.Next(1, rgVar, vFetched) = S_OK do Inc(Count);
ShowMessage(IntToStr(Count));
end;
这个代码怎么转换?
谢谢!
For Each cell In Selection
msgbox(cell.value)
Next cell
begin
ShowMessage(rgVar);
Inc(Count);
end;
受之以鱼不如受之议渔
再谢