'Test the creation of an  XlsxWriter file data validation.'

def test_create_file(self):

    workbook = Workbook(self.got_filename)
    worksheet = workbook.add_worksheet()
    worksheet.data_validation('C2', {'validate': 'list', 'value': ['Foo', 'Bar', 'Baz'], 'input_title': 'This    is    the    input    title', 'input_message': 'This    is    the    input    message'})
    input_title = 'This    is    the    longest    input    title1'
    input_message = ('This    is    the    longest    input    message    ' + ('a' * 222))
    values = ['Foobar', 'Foobas', 'Foobat', 'Foobau', 'Foobav', 'Foobaw', 'Foobax', 'Foobay', 'Foobaz', 'Foobba', 'Foobbb', 'Foobbc', 'Foobbd', 'Foobbe', 'Foobbf', 'Foobbg', 'Foobbh', 'Foobbi', 'Foobbj', 'Foobbk', 'Foobbl', 'Foobbm', 'Foobbn', 'Foobbo', 'Foobbp', 'Foobbq', 'Foobbr', 'Foobbs', 'Foobbt', 'Foobbu', 'Foobbv', 'Foobbw', 'Foobbx', 'Foobby', 'Foobbz', 'Foobca', 'End']
    import warnings
    warnings.filterwarnings('ignore')
    worksheet.data_validation('D6', {'validate': 'list', 'value': values, 'input_title': input_title, 'input_message': input_message})
    workbook.close()
    self.assertExcelEqual()
