delphi操作excel怎样插入一个可选的列?
var
ExcelApp,WorkBook:Variant;
i,j:integer;
begin
ExcelApp:=CreateOleObject('Excel.Application');
ExcelApp.WorkBooks.Add;
WorkBook:=ExcelApp.WorkBooks.Open(D:\a.xls);
ExcelApp.ActiveSheet.Columns[2].Insert;
ExcelApp.Cells[1,2].Value := '性别';
end;
以上的代码插入的列是不可选的,怎样插入一个可选的列?下面可以选男或者女?
var
ExcelApp,WorkBook:Variant;
i,j:integer;
begin
ExcelApp:=CreateOleObject('Excel.Application');
ExcelApp.WorkBooks.Add;
WorkBook:=ExcelApp.WorkBooks.Open(D:\a.xls);
ExcelApp.ActiveSheet.Columns[2].Insert;
ExcelApp.Cells[1,2].Value := '性别';
end;
以上的代码插入的列是不可选的,怎样插入一个可选的列?下面可以选男或者女?
Columns("J:J").Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="male,female"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
'男,女') ;
加上这句应该就可以了,试试
ExcelApp.ActiveSheet.Columns[5].Validation.add(xlValidateList,xlValidAlertStop, xlBetween,'男,女');
ExcelApp.ActiveSheet.Columns[8].Validation.add(xlValidateDate,xlValidAlertStop, xlBetween,'1930-1-1','2099-12-31');
ExcelApp.ActiveSheet.Columns[18].Validation.add(xlValidateWholeNumber,xlValidAlertStop, xlBetween,'100000','999999');
谢谢zhnglicho