PythonxlsxExample

import xlsxwriter


# Create an new Excel file and add a worksheet.
workbook = xlsxwriter.Workbook('AbhishekExample.xlsx')
worksheet = workbook.add_worksheet()
worksheet1 = workbook.add_worksheet()

# Increase the cell size of the merged cells to highlight the formatting.
worksheet.set_column('B:D', 12)
worksheet.set_row(3, 30)
worksheet.set_row(6, 30)
worksheet.set_row(7, 30)


# Create a format to center text and add border 
bcenter_format = workbook.add_format({
    'border': 1,
    'valign': 'vcenter',
    'text_wrap': True
    })


# Merge the row 1
worksheet.merge_range('A1:B1', 'WAE Config used for original plans:', bcenter_format)
worksheet.merge_range('C1:G1', 
"'enableFleetOpt': True,'useAsInitialSolution': True,'useGreedyRoutes': True,'timeSlotDistribution': 'SINGLE','connectAllEdges': True,'costOptimizationConfig': {'enable': False, 'volumeBreachFraction': 0.0},'postProcessClusters': True,'relocateUnallocations': False,'updateFleetProperties': False,'storeRequest': True,'writeDistanceMatrixToCsv': False,'extraFleetOpt': False,'allocationConfig': {'iterations': 10},'initialEdgeCount': 10000,'enableFastClustering': False:'", bcenter_format)
worksheet.merge_range('H1:I1', 'Merged Range', bcenter_format)
worksheet.merge_range('J1:N1', 'Merged Range', bcenter_format)

# Create a format to use in the merged range.
bb_format = workbook.add_format({
    'bold': 1,
    'border': 1,
    'text_wrap': True
    })

# Merge the row 3
worksheet.merge_range('A3:F3', 'Merged Range', bb_format)
worksheet.merge_range('H3:I3', 'Merged Range')

heading_format = workbook.add_format({
    'bold': 1,
    'border': 1,
    'font_color': 'white',
    'bg_color': 'black',
    'text_wrap': True
    })

# Add headings to row 5
worksheet.write('A5', 'Batch Name', heading_format)

# Merge col A
for i in range(5, 34, 3): 
    worksheet.merge_range(i, 0, i+2, 0, 'Merged Range', bcenter_format)
    worksheet.merge_range(i, 1, i+2, 1, 'Merged Range', bcenter_format)
    worksheet.merge_range(i, 2, i+2, 2, 'Merged Range', bcenter_format)

#Link Example
worksheet.write('A5', 'Batch Name', heading_format)
worksheet.write_url('D6', 'https://xlsxwriter.readthedocs.io/examples.html', string='Out Of Syllabus')

workbook.close()