ASP输出EXECL表,不能建立数据有效性单元格
需要用ASP输出的EXECL表上一个单元格自动生成“数据有效性”
用类似以下的语句
xlWorkBook.Worksheets(1).Range( "A2 "). Formula1="111,2222"
系统提示
'800a01b6' 提示组件不支持,难道ASP不支持
我看EXECL VBA 是以下代码
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="111,222,333,444"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.IMEMode = xlIMEModeNoControl
.ShowInput = True
.ShowError = True
End With
怎么转换VB SCRIPT?