~ZiX*SrSSKJr SSKrSSKJr SSKJr "SS\5r "SS \ 5r "S S \ 5r "S S \ 5r g)z"Chart builder and related objects.) annotationsN)contextmanager)WorkbookcR^\rSrSrSrU4Sjr\S5r\S5r Sr Sr U=r $)_BaseWorkbookWriter z:Base class for workbook writers, providing shared members.c6>[[U] 5 Xlg)N)superr__init__ _chart_data)self chart_data __class__s i/var/www/eduai.edurigo.com/question_generate/ques_gen_env/lib/python3.13/site-packages/pptx/chart/xlsx.pyr _BaseWorkbookWriter.__init__s !413%c[R"5nURU5up#URX#5 SSS5 UR 5$!,(df  UR 5$=f)z+bytes for Excel file containing chart_data.N)ioBytesIO_open_worksheet_populate_worksheetgetvaluer xlsx_fileworkbook worksheets r xlsx_blob_BaseWorkbookWriter.xlsx_blobs\JJL  ! !) ,0E  $ $X 9-!!##- ,!!##s A A0c#r# [USS05nUR5nX#4v UR5 g7f)z Enable XlsxWriter Worksheet object to be opened, operated on, and then automatically closed within a `with` statement. A filename or stream object (such as an `io.BytesIO` instance) is expected as *xlsx_file*. in_memoryTN)r add_worksheetclosers rr#_BaseWorkbookWriter._open_worksheets9I T':;**, !!s57c[S5e)za Must be overridden by each subclass to provide the particulars of writing the spreadsheet data. z!must be provided by each subclass)NotImplementedErrorr rrs rr'_BaseWorkbookWriter._populate_worksheet's ""EFFr)r ) __name__ __module__ __qualname____firstlineno____doc__r propertyrrrr__static_attributes__ __classcell__)rs@rrr s?D&$$  GGrrcb\rSrSrSr\S5rSrSr\ S5r Sr Sr S r S rS rS rg )CategoryWorkbookWriter/z Determines Excel worksheet layout and can write an Excel workbook from a CategoryChartData object. Serves as the authority for Excel worksheet ranges. cURRnURS:Xa [S5e[ [ S5UR-S- 5nUR S-nSX#4-$)zd The Excel worksheet reference to the categories for this chart (not including the column heading). rz!chart data contains no categoriesAzSheet1!$A$2:$%s$%d)r categoriesdepth ValueErrorchrord leaf_count)r r6 right_col bottom_rows rcategories_ref%CategoryWorkbookWriter.categories_ref6sk %%00   q @A AC:#3#33a78 **Q. #y&===rc*SURU5-$)z Return the Excel worksheet reference to the cell containing the name for *series*. This also serves as the column heading for the series values. z Sheet1!$%s$1)_series_col_letterr seriess rseries_name_ref&CategoryWorkbookWriter.series_name_refCs  7 7 ???rcbSR"S0URU5[U5S-S.D6$)za The Excel worksheet reference to the values for this series (not including the column heading). z1Sheet1!${col_letter}$2:${col_letter}${bottom_row}r5) col_letterr=)formatrAlenrBs r values_ref!CategoryWorkbookWriter.values_refKs; CII "55f=!&kAo  rcUS:dUS:a [S5eSnU(a<US-nUS:XaSn[[S5U-S- 5nX1-nUS- S-nU(aM<U$)zReturn str Excel column reference like 'BQ' for *column_number*. *column_number* is an int in the range 1-16384 inclusive, where 1 maps to column 'A'. r5i@z&column_number must be in range 1-16384rr4)r8r9r:) column_numbercol_ref remainderrGs r_column_reference(CategoryWorkbookWriter._column_referenceWs~ 1   5EF F %*IA~ SX 1A56J *G+Q.25MmrcHURX5 URX5 g)aV Write the chart data contents to *worksheet* in category chart layout. Write categories starting in the first column starting in the second row, and proceeding one column per category level (for charts having multi-level categories). Write series as columns starting in the next following column, placing the series title in the first cell. N)_write_categories _write_seriesr&s rr*CategoryWorkbookWriter._populate_worksheetws  x3 8/rcpSURR-UR-nURU5$)zR The letter of the Excel worksheet column in which the data for a series appears. r5)r6r7indexrS)r rCrPs rrA)CategoryWorkbookWriter._series_col_letters4 F--333fllB %%m44rcURRnURSUR05nURn[ UR 5HupgXV- S- nURX(Xt5 M g)a Write the categories column(s) to *worksheet*. Categories start in the first column starting in the second row, and proceeding one column per category level (for charts having multi-level categories). A date category is formatted as a date. All others are formatted `General`. num_formatr5N)r r6 add_format number_formatr7 enumeratelevels_write_cat_column) r rrr6r]r7idxlevelcols rrV(CategoryWorkbookWriter._write_categoriessm%%00 ((, 8P8P)QR   #J$5$56JC+/C  " "95 E7rclURX"S5 UHupVUS-nURXrXd5 M g)zl Write a category column defined by *level* to *worksheet* at offset *col* and formatted with *num_format*. r5N) set_columnwrite)r rrerdr]offnamerows rrb(CategoryWorkbookWriter._write_cat_columns7 Sr*IC'C OOCd 7rc4URRRn[UR5H_upEUR SUR 05nXC-nUR SXuR5 URSXuRU5 Ma g)z Write the series column(s) to *worksheet*. Series start in the column following the last categories column, placing the series title in the first cell. r]rr5N) r r6r7r`r^r_rjrl write_columnvalues)r rr col_offsetrcrCr] series_cols rrW$CategoryWorkbookWriter._write_seriess} %%0066 $T%5%56KC!,,lFrDrK staticmethodrSrrArVrbrWr.rHrrr1r1/sU  > >@  > 05 F8 Mrr1c6\rSrSrSrSrSrSrSrSr Sr g ) XyWorkbookWriterz Determines Excel worksheet layout and can write an Excel workbook from XY chart data. Serves as the authority for Excel worksheet ranges. c4URU5S-nSU-$)z Return the Excel worksheet reference to the cell containing the name for *series*. This also serves as the column heading for the series Y values. r5z Sheet1!$B$%d)series_table_row_offset)r rCrms rrD XyWorkbookWriter.series_name_refs$ **62Q6##rc@URS-nURnX#-$)zY Return the number of rows preceding the data table for *series* in the Excel worksheet. )rZdata_point_offset)r rCtitle_and_spacer_rowsdata_point_rowss rrz(XyWorkbookWriter.series_table_row_offsets' !' q 0 22$66rcXURU5S-nU[U5-S- nSX#4-$)z` The Excel worksheet reference to the X values for this chart (not including the column label). r}r5zSheet1!$A$%d:$A$%drzrJr rCtop_rowr=s r x_values_refXyWorkbookWriter.x_values_ref: ..v6:s6{*Q. #w&;;;rcXURU5S-nU[U5-S- nSX#4-$)z` The Excel worksheet reference to the Y values for this chart (not including the column label). r}r5zSheet1!$B$%d:$B$%drrs r y_values_refXyWorkbookWriter.y_values_refrrcURSURR05nURHnURSUR05nURU5nUR US-SUR U5 UR USUR5 UR US-SURU5 M g)z Write chart data contents to *worksheet* in the standard XY chart layout. Write the data for each series to a separate two-column table, X values in column A and Y values in column B. Place the series label in the first (heading) cell of the column. r]r5rN) r^r r_rzrpx_valuesrjrly_valuesr rrchart_num_formatrCseries_num_formatoffsets rr$XyWorkbookWriter._populate_worksheets$.. d>N>N>\>\/]^&&F ( 3 3\6CWCW4X Y 11&9F  " "6A:q&//CS T OOFAv{{ 3  " "6A:q&//CT U'rrHN) r(r)r*r+r,rDrzrrrr.rHrrrwrws! $7<<Vrrwc$\rSrSrSrSrSrSrg)BubbleWorkbookWriterzR Service object that knows how to write an Excel workbook from bubble chart data. cXURU5S-nU[U5-S- nSX#4-$)z~ The Excel worksheet reference to the range containing the bubble sizes for *series* (not including the column heading cell). r}r5zSheet1!$C$%d:$C$%drrs rbubble_sizes_ref%BubbleWorkbookWriter.bubble_sizes_refrrcURSURR05nURHnURSUR05nURU5nUR US-SUR U5 UR USUR5 UR US-SURU5 UR USS5 UR US-SURU5 M g)a Write chart data contents to *worksheet* in the bubble chart layout. Write the data for each series to a separate three-column table with X values in column A, Y values in column B, and bubble sizes in column C. Place the series label in the first (heading) cell of the values column. r]r5rr}SizeN) r^r r_rzrprrjrlr bubble_sizesrs rr(BubbleWorkbookWriter._populate_worksheets$.. d>N>N>\>\/]^&&F ( 3 3\6CWCW4X Y 11&9F  " "6A:q&//CS T OOFAv{{ 3  " "6A:q&//CT U OOFAv .  " "6A:q&2E2EGW X'rrHN)r(r)r*r+r,rrr.rHrrrrs <Yrr) r, __future__rr contextlibr xlsxwriterrobjectrr1rwrrHrrrsT(" %!G&!GH@M0@MF9V*9Vx"Y+"Yr