def B():
sheetB = wb.create_sheet('주요국가별 출원동향', 1)
B그래프data = Data.주요국출원동향()
for r in dataframe_to_rows(B그래프data, index=False, header=True):
sheetB.append(r)
sheetB.insert_cols(2)
for row, cellobj in enumerate(list(sheetB.columns)[1]):
n = '=right(A%d,2)' % (row + 1)
cellobj.value = n
sheetB['B22'] = '합계'
sheetB['C22'] = '=SUM(C2:C21)'
sheetB['D22'] = '=SUM(D2:D21)'
sheetB['E22'] = '=SUM(E2:E21)'
sheetB['F22'] = '=SUM(F2:F21)'
chartB1 = LineChart()
dataB1 = Reference(sheetB, min_col=3, min_row=1, max_row=21, max_col=6)
catsB1 = Reference(sheetB, min_col=2, min_row=2, max_row=21)
chartB1.add_data(dataB1, titles_from_data=True)
chartB1.set_categories(catsB1)
chartB1.y_axis.majorGridlines = None
chartB1.width = 15
chartB1.height = 10
chartB1.legend.position = 't'
chartB1.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
sheetB.add_chart(chartB1, 'H2')
chartB2 = PieChart()
dataB2 = Reference(sheetB, min_col=3, min_row=22, max_col=6)
labelsB2 = Reference(sheetB, min_col=3, min_row=1, max_col=6)
chartB2.add_data(dataB2, from_rows=22, titles_from_data=False)
chartB2.set_categories(labelsB2)
chartB2.width = 5
chartB2.height = 5
chartB2.legend = None
chartB2.graphical_properties = GraphicalProperties(
ln=LineProperties(noFill=True, solidFill=None, gradFill=None))
chartB2.dLbls = DataLabelList()
chartB2.dLbls.showPercent = True
sheetB.add_chart(chartB2, 'M1')
def C():
# 데이터 정리
sheetC = wb.create_sheet('주요국 내 상위다출원국가', 2)
C상위다출원국가KR = Data.상위다출원국가('KR')
C상위다출원국가JP = Data.상위다출원국가('JP')
C상위다출원국가US = Data.상위다출원국가('US')
C상위다출원국가EP = Data.상위다출원국가('EP')
for r in dataframe_to_rows(C상위다출원국가KR, index=False, header=True):
sheetC.append(r)
sheetC['A22'] = ''
sheetC['A23'] = ''
for r in dataframe_to_rows(C상위다출원국가JP, index=False, header=True):
sheetC.append(r)
sheetC['A45'] = ''
sheetC['A46'] = ''
for r in dataframe_to_rows(C상위다출원국가US, index=False, header=True):
sheetC.append(r)
sheetC['A68'] = ''
sheetC['A69'] = ''
for r in dataframe_to_rows(C상위다출원국가EP, index=False, header=True):
sheetC.append(r)
sheetC['A91'] = ''
sheetC['A92'] = ''
sheetC.insert_cols(2)
for row, cellobj in enumerate(list(sheetC.columns)[1]):
n = '=right(A%d,2)' % (row + 1)
cellobj.value = n
# 엑셀 함수
sheetC['B22'] = '합계'
sheetC['C22'] = '=SUM(C2:C21)'
sheetC['D22'] = '=SUM(D2:D21)'
sheetC['E22'] = '=SUM(E2:E21)'
sheetC['F22'] = '=SUM(F2:F21)'
sheetC['A23'] = ' '
sheetC['B45'] = '합계'
sheetC['C45'] = '=SUM(C25:C44)'
sheetC['D45'] = '=SUM(D25:D44)'
sheetC['E45'] = '=SUM(E25:E44)'
sheetC['F45'] = '=SUM(F25:F44)'
sheetC['A46'] = ' '
sheetC['B68'] = '합계'
sheetC['C68'] = '=SUM(C48:C67)'
sheetC['D68'] = '=SUM(D48:D67)'
sheetC['E68'] = '=SUM(E48:E67)'
sheetC['F68'] = '=SUM(F48:F67)'
sheetC['A69'] = ' '
sheetC['B91'] = '합계'
sheetC['C91'] = '=SUM(C71:C90)'
sheetC['D91'] = '=SUM(D71:D90)'
sheetC['E91'] = '=SUM(E71:E90)'
sheetC['F91'] = '=SUM(F71:F90)'
sheetC['A92'] = ' '
# 그래프 그리기
chartC11 = LineChart()
dataC11 = Reference(sheetC, min_col=3, min_row=1, max_col=6, max_row=21)
catsC11 = Reference(sheetC, min_col=2, min_row=2, max_row=21)
chartC11.add_data(dataC11, titles_from_data=True)
chartC11.set_categories(catsC11)
chartC11.y_axis.majorGridlines = None
chartC11.width = 15
chartC11.height = 10
chartC11.legend.position = 't'
chartC11.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
sheetC.add_chart(chartC11, 'H2')
chartC12 = PieChart()
dataC12 = Reference(sheetC, min_col=3, min_row=22, max_col=6)
labelC12 = Reference(sheetC, min_col=3, min_row=1, max_col=6)
chartC12.add_data(dataC12, from_rows=22, titles_from_data=False)
chartC12.set_categories(labelC12)
chartC12.width = 5
chartC12.height = 5
chartC12.legend = None
chartC12.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
chartC12.dLbls = DataLabelList()
chartC12.dLbls.showPercent = True
sheetC.add_chart(chartC12, 'M1')
chartC21 = LineChart()
dataC21 = Reference(sheetC, min_col=3, min_row=24, max_col=6, max_row=44)
catsC21 = Reference(sheetC, min_col=2, min_row=25, max_row=44)
chartC21.add_data(dataC21, titles_from_data=True)
chartC21.set_categories(catsC21)
chartC21.y_axis.majorGridlines = None
chartC21.width = 15
chartC21.height = 10
chartC21.legend.position = 't'
chartC21.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
sheetC.add_chart(chartC21, 'H25')
chartC22 = PieChart()
dataC22 = Reference(sheetC, min_col=3, min_row=45, max_col=6)
labelC22 = Reference(sheetC, min_col=3, min_row=24, max_col=6)
chartC22.add_data(dataC22, from_rows=45, titles_from_data=False)
chartC22.set_categories(labelC22)
chartC22.width = 5
chartC22.height = 5
chartC22.legend = None
chartC22.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
chartC22.dLbls = DataLabelList()
chartC22.dLbls.showPercent = True
sheetC.add_chart(chartC22, 'M24')
chartC31 = LineChart()
dataC31 = Reference(sheetC, min_col=3, min_row=47, max_col=6, max_row=67)
catsC31 = Reference(sheetC, min_col=2, min_row=48, max_row=67)
chartC31.add_data(dataC31, titles_from_data=True)
chartC31.set_categories(catsC31)
chartC31.y_axis.majorGridlines = None
chartC31.width = 15
chartC31.height = 10
chartC31.legend.position = 't'
chartC31.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
sheetC.add_chart(chartC31, 'H48')
chartC32 = PieChart()
dataC32 = Reference(sheetC, min_col=3, min_row=68, max_col=6)
labelC32 = Reference(sheetC, min_col=3, min_row=47, max_col=6)
chartC32.add_data(dataC32, from_rows=68, titles_from_data=False)
chartC32.set_categories(labelC32)
chartC32.width = 5
chartC32.height = 5
chartC32.legend = None
chartC32.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
chartC32.dLbls = DataLabelList()
chartC32.dLbls.showPercent = True
sheetC.add_chart(chartC32, 'M47')
chartC41 = LineChart()
dataC41 = Reference(sheetC, min_col=3, min_row=70, max_col=6, max_row=90)
catsC41 = Reference(sheetC, min_col=2, min_row=71, max_row=90)
chartC41.add_data(dataC41, titles_from_data=True)
chartC41.set_categories(catsC41)
chartC41.y_axis.majorGridlines = None
chartC41.width = 15
chartC41.height = 10
chartC41.legend.position = 't'
chartC41.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
sheetC.add_chart(chartC41, 'H71')
chartC42 = PieChart()
dataC42 = Reference(sheetC, min_col=3, min_row=91, max_col=6)
labelC42 = Reference(sheetC, min_col=3, min_row=70, max_col=6)
chartC42.add_data(dataC42, from_rows=91, titles_from_data=False)
chartC42.set_categories(labelC42)
chartC42.width = 5
chartC42.height = 5
chartC42.legend = None
chartC42.graphical_properties = GraphicalProperties(ln=LineProperties(
noFill=True))
chartC42.dLbls = DataLabelList()
chartC42.dLbls.showPercent = True
sheetC.add_chart(chartC42, 'M70')
