I have been exploring this very thing. I have created the low level Record
classed for the DV and the DVAL record type according to the Excel 97 Dev
kit. Looks like if definitely can be done. I have hit a snag that I
believe is due to not having read the entire book(part of the book says "see
text" but who knows what this is referring to). Here is the output from
BiffViewer of my DV record on a xls file with a drop down list:
[DV]
.optionFlags = 103
.criteria_0 = 1
.criteria_1 = 1
.criteria_2 = 1
.criteria_3 = 1
.criteria_4 = c0009
.criteria_5 = 8000525
.criteria_6 = 4000400
.criteria_7 = 0
.criteria_8 = 5000101
.criteria_9 = 1000500
.validationType = 3
.errorStyle = 0
.strLookup= false
.allowBlank = true
.supressCombo = false
.imeMode = 0
.showInputMessage = false
.showErrorMessage = false
.operatorType = 0
[/DV]
The part that I am trying to figure out is what the criteria values mean.
Randy James
-----Original Message-----
From: John Xiao [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 2:45 PM
To: '[EMAIL PROTECTED]'
Subject: Excel Cell Validation
Is there a way to create validation for Excel files? I am new to this. Can
someone share the insight?
All I want to do is create a validation for the ouput Excel file so that the
cell will have a dropdown list.
Regards,
John
