Add DataValidation List in the Excel using JavaScript ActiveXObject : Excel.Application


  • How to Add Data validation while generating a Excel File using Javascript. I have some static Text like "High,Moderate,Low" which should come down as a Drop Down List.
    Wednesday, January 18, 2012 9:46 AM

All replies

  • I am not very clear your question.

    Do you mean that there are some DropDown list on the web as conditions and generat a Excel file up on the condition?

    Could you show us more infromation about this issue please?


    Thanks for your understanding and support.


    Best Regards,
    Rocky Yue[MSFT]
    MSDN Community Support | Feedback to us
    Friday, January 20, 2012 7:15 AM
  • I want to carry the Information of the Field Value in a web page when extracted to an Excel File.
    For example, if a DropDown Field  has "High,Medium,Low", i want to have the same validation on the excel file while generated forcing the users to select from the list ie "High,Medium,Low". 
    Tuesday, January 24, 2012 1:40 PM
  • Waw, this is a really good idea.

    I would suggest you to try ASP.Net forum and Excel for Developpers forum for better support.



    Hope it helps.

    Best Regards,
    Rocky Yue[MSFT]
    MSDN Community Support | Feedback to us
    Wednesday, January 25, 2012 5:45 AM
  • http://stackoverflow.com/questions/8655185/limitation-while-generating-excel-drop-down-list-with-apache-poi
    Tuesday, February 07, 2012 10:37 AM