lsxWriter là một thư viện Python sử dụng thư viện này có thể thực hiện nhiều thao tác trên các tệp excel như tạo, viết, các phép toán số học và vẽ đồ thị.
Ví dụ
# import xlsxwriter module
import xlsxwriter
# Workbook() takes one, non-optional, argument which is the filename #that we want to create.
workbook = xlsxwriter.Workbook('chart_combined.xlsx')
# The workbook object is then used to add new worksheet via the #add_worksheet() method.
worksheet = workbook.add_worksheet()
# Create a new Format object to formats cells in worksheets using #add_format() method .
# here we create bold format object .
bold = workbook.add_format({'bold': True})
# Add the worksheet data that the charts will refer to.
headings = ['Number', 'Batch 1', 'Batch 2']
data = [
[2, 3, 4, 5, 6, 7],
[10, 40, 50, 20, 10, 50],
[30, 60, 70, 50, 40, 30],
]
# Write a row of data starting from 'A1' with bold format .
worksheet.write_row('A1', headings, bold)
# Write a column of data starting from 'A2', 'B2', 'C2' respectively .
worksheet.write_column('A2', data[0])
worksheet.write_column('B2', data[1])
worksheet.write_column('C2', data[2])
# Create a chart object that can be added to a worksheet using #add_chart() method.
#here we create a column chart object.This will use as the primary #chart.
column_chart1 = workbook.add_chart({'type': 'column'})
# Add a data series to a chart using add_series method.
# Configure the first series.
# = Sheet1 !$A$1 is equivalent to ['Sheet1', 0, 0].
# note : spaces is not inserted in b/w = and Sheet1, Sheet1 and !
# if space is inserted it throws warning.
column_chart1.add_series({
'name': '= Sheet1 !$B$1',
'categories': '= Sheet1 !$A$2:$A$7',
'values': '= Sheet1 !$B$2:$B$7',
})
# Create a new line chart.This will use as the secondary chart.
line_chart1 = workbook.add_chart({'type': 'line'})
# Configure the data series for the secondary chart.
line_chart1.add_series({
'name': '= Sheet1 !$C$1',
'categories': '= Sheet1 !$A$2:$A$7',
'values': '= Sheet1 !$C$2:$C$7',
})
# Combine both column and line chatrs together.
column_chart1.combine(line_chart1)
# Add a chart title
column_chart1.set_title({ 'name': 'Combined chart - same Y axis'})
# Add x-axis label
column_chart1.set_x_axis({'name': 'Test number'})
# Add y-axis label
column_chart1.set_y_axis({'name': 'Sample length (mm)'})
# add chart to the worksheet with given offset values at the top-left #corner of a chart is anchored to cell D2
worksheet.insert_chart('D2', column_chart1, {'x_offset': 25, 'y_offset': 10})
# Finally, close the Excel file via the close() method.
workbook.close()