DataValidation Example with write_xlsx Gem

data_validation_example.rb

require 'write_xlsx'

workbook = WriteXLSX.new('write_xlsx_example.xlsx')

dropdownSheet = workbook.add_worksheet('DropDown Values')
dropdownSheet.write_row(0,0,['open', 'high', 'close'])
dropdownSheet.protect('password')

worksheet = workbook.add_worksheet

worksheet.data_validation('A1:A100',
{
    :validate        => 'list',
    #:value           => ['open', 'high', 'close'],
    :value           => "'DropDown Values'!A$1:C$1",
    #:input_title     => 'Input an integer:',
    :input_message   => 'Choose the value from the dropdown',
    :error_message   => 'Please use the dropdown selector to choose the value'
})

dropdownSheet.hide
worksheet.set_first_sheet
worksheet.activate
workbook.close