XlsxWriter는 Excel 파일에서 생성, 쓰기, 산술 연산 및 그래프 그리기와 같은 여러 작업을 수행할 수 있는 Python 라이브러리입니다.
예시
# import xlsxwriter module import xlsxwriter # Workbook() takes one, non-optional, argument which is the filename #that we want to create. workbook = xlsxwriter.Workbook('updown_chart.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 italic format object italic = workbook.add_format({'italic': 1}) # Add the worksheet data that the charts will refer to. Data1 = ['Subject', 'Mid Exam Score', 'End Exam Score'] Data2 = [ ["Math", "Physics", "Computer", "Hindi", "English", "chemistry"], [90, 78, 60, 80, 60, 90], [45, 39, 30, 40, 30, 60] ] # Write a row of data starting from 'A1' with bold format . worksheet.write_row('A1', Data1, italic) #Write a column of data starting from 'A2', 'B2', 'C2' respectively worksheet.write_column('A2', Data2[0]) worksheet.write_column('B2', Data2[1]) worksheet.write_column('C2', Data2[2]) # set the wdith of B and C column worksheet.set_column('B:C', 15) # Create a chart object that can be added to a worksheet using add_chart() method. # here we create a line chart object . chart1 = workbook.add_chart({'type': 'line'}) # Adding the Up-Down Bars. chart1.set_up_down_bars() # Add a data series to a chartusing 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. chart1.add_series({ 'categories': '= Sheet1 !$A$2:$A$7', 'values': '= Sheet1 !$B$2:$B$7', }) # Configure the second series. chart1.add_series({ 'categories': '= Sheet1 !$A$2:$A$7', 'values': '= Sheet1 !$C$2:$C$7', }) # Add a chart title. chart1.set_title({'name': 'Exam Score Distribution'}) # Add x-axis label chart1.set_x_axis({'name': 'Subjects'}) # Add y-axis label chart1.set_y_axis({'name': 'Marks'}) # Set an Excel chart style. chart1.set_style(11) # 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', chart1, {'x_offset': 20, 'y_offset': 5}) # Finally, close the Excel file via the close() method. workbook.close()