dcsimg
Validating a Cell in the MS Excel worksheet through Java
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Renjith_C
Posted On:   Friday, May 31, 2002 12:08 PM

Please help me in writing code for Validating a Cell in the MS Excel worksheet. Steps to be followed in the Excel application to put a validation in cell. 1. Menu -> Data -> Validation 2. Select the 'Settings' Tab 3. Click on the 'Allow' List box. 4. Select 'List' 5. Enter the Values to be validated seperated by commas. Now we can see the validations in that cell. I have to achieve the same result through Java. ie., I have to create an Excel Sheet with such validation dynamicaly.    More>>

Please help me in writing code for Validating a Cell
in the MS Excel worksheet.




Steps to be followed in the Excel application to put a
validation in cell.




1. Menu -> Data -> Validation


2. Select the 'Settings' Tab


3. Click on the 'Allow' List box.


4. Select 'List'


5. Enter the Values to be validated seperated by
commas.




Now we can see the validations in that cell.
I have to achieve the same result through Java. ie., I
have to create an Excel Sheet with such validation
dynamicaly.

   <<Less
About | Sitemap | Contact