I needed to create in-cell dropdownlist in excel using VB.NET,
So i used the code,
With xlWorksheet.Range("H2", "H101").Validation
.Add(Type:=Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, AlertStyle:=Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Operator:=Microsoft.Office.Interop.Excel.XlFormatConditionOperator.xlBetween, Formula1:="Maintenance Planning")
It works fine with Excel 2003, but it does not works on Excel 2007.
It shows below message,
Excel was able to open the file by repairing or removing the unreadable content.
Removed Feature: Data validation from /xl/worksheets/sheet1.xml part
Its the log file listing repairs,
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<summary>Errors were detected in file 'C:\Documents and Settings\kothainayaki\Desktop\sk.xls'</summary>
- <removedFeatures summary="Following is a list of removed features:">
<removedFeature>Removed Feature: Data validation from /xl/worksheets/sheet1.xml part</removedFeature>