def test_create_file(self):
    'Test the creation of a simple XlsxWriter file.'
    workbook = Workbook(self.got_filename)
    worksheet = workbook.add_worksheet()
    chart = workbook.add_chart({'type': 'stock'})
    date_format = workbook.add_format({'num_format': 14})
    chart.axis_ids = [45740032, 45747200]
    data = [[39083, 39084, 39085, 39086, 39087], [27.2, 25.03, 19.05, 20.34, 18.5], [23.49, 19.55, 15.12, 17.84, 16.34], [25.45, 23.05, 17.32, 20.45, 17.34]]
    for row in range(5):
        worksheet.write(row, 0, data[0][row], date_format)
        worksheet.write(row, 1, data[1][row])
        worksheet.write(row, 2, data[2][row])
        worksheet.write(row, 3, data[3][row])
    worksheet.set_column('A:D', 11)
    chart.add_series({'categories': '=Sheet1!$A$1:$A$5', 'values': '=Sheet1!$B$1:$B$5'})
    chart.add_series({'categories': '=Sheet1!$A$1:$A$5', 'values': '=Sheet1!$C$1:$C$5'})
    chart.add_series({'categories': '=Sheet1!$A$1:$A$5', 'values': '=Sheet1!$D$1:$D$5', 'data_labels': {'value': 1, 'position': 'right'}})
    worksheet.insert_chart('E9', chart)
    workbook.close()
    self.assertExcelEqual()
Test the creation of a simple XlsxWriter file.
def test_create_file(self):
    
    workbook = Workbook(self.got_filename)
    worksheet = workbook.add_worksheet()
    chart = workbook.add_chart({'type': 'stock'})
    date_format = workbook.add_format({'num_format': 14})
    chart.axis_ids = [45740032, 45747200]
    data = [[39083, 39084, 39085, 39086, 39087], [27.2, 25.03, 19.05, 20.34, 18.5], [23.49, 19.55, 15.12, 17.84, 16.34], [25.45, 23.05, 17.32, 20.45, 17.34]]
    for row in range(5):
        worksheet.write(row, 0, data[0][row], date_format)
        worksheet.write(row, 1, data[1][row])
        worksheet.write(row, 2, data[2][row])
        worksheet.write(row, 3, data[3][row])
    worksheet.set_column('A:D', 11)
    chart.add_series({'categories': '=Sheet1!$A$1:$A$5', 'values': '=Sheet1!$B$1:$B$5'})
    chart.add_series({'categories': '=Sheet1!$A$1:$A$5', 'values': '=Sheet1!$C$1:$C$5'})
    chart.add_series({'categories': '=Sheet1!$A$1:$A$5', 'values': '=Sheet1!$D$1:$D$5', 'data_labels': {'value': 1, 'position': 'right'}})
    worksheet.insert_chart('E9', chart)
    workbook.close()
    self.assertExcelEqual()