myems / myems-api

            len(reporting_period_data['timestamps']) == 0:

        has_detail_data_flag = False

    if has_detail_data_flag:

        ws['B37'].font = title_font

        ws['B37'] = name+' 能耗详情'

        ws['B'+str(table_row)].fill = table_fill

        ws['B'+str(table_row)].border = f_border

        ws['B'+str(table_row)].alignment = c_c_alignment

        ws['B'+str(table_row)] = '时间'

        time = times[0]

        has_data = False

        max_row = 0

        if len(time) > 0:

            has_data = True

            max_row = table_row + len(time)

            print("max_row", max_row)

        if has_data:

            for i in range(0, len(time)):

                col = 'B'

                row = str(table_row+1 + i)

                # col = chr(ord('B') + i)

                ws[col + row].font = title_font

                ws[col + row].alignment = c_c_alignment

                ws[col + row] = time[i]

                ws[col + row].border = f_border

            for i in range(0, ca_len):

                # 38 title

                col = chr(ord('C') + i)

                ws[col + str(table_row)].fill = table_fill

                ws[col + str(table_row)].font = title_font

                ws[col + str(table_row)].alignment = c_c_alignment

                ws[col + str(table_row)] = reporting_period_data['names'][i] + " (" + reporting_period_data['units'][i] + ")"

                ws[col + str(table_row)].border = f_border

                # 39 data

                time = times[i]

                time_len = len(time)

                for j in range(0, time_len):

                    row = str(table_row+1 + j)

                    # col = chr(ord('B') + i)

                    ws[col + row].font = title_font

                    ws[col + row].alignment = c_c_alignment

                    ws[col + row] = round(reporting_period_data['values'][i][j], 0)

                    ws[col + row].border = f_border

                # bar

                # 39~: bar

                bar = BarChart()

                labels = Reference(ws, min_col=2, min_row=table_row+1, max_row=max_row + 1)

                bar_data = Reference(ws, min_col=3 + i, min_row=table_row, max_row=max_row + 1)  # openpyxl bug

                bar.add_data(bar_data, titles_from_data=True)

                bar.set_categories(labels)

                bar.height = 5.25  # cm 1.05*5 1.05cm = 30 pt

                bar.width = 18

                # pie.title = "Pies sold by category"

                bar.dLbls = DataLabelList()

                # bar.dLbls.showCatName = True  # label show

                bar.dLbls.showVal = True  # val show

                bar.dLbls.showPercent = True  # percent show

                # s1 = CharacterProperties(sz=1800)     # font size *100

                chart_col = 'B'

                chart_cell = chart_col + str(38 + 5*i)

                ws.add_chart(bar, chart_cell)

    else:

        for i in range(37, 69 + 1):

            ws.row_dimensions[i].height = 0.1

    filename = str(uuid.uuid4()) + '.xlsx'

    wb.save(filename)

            len(reporting_period_data['timestamps']) == 0:

        has_detail_data_flag = False

    if has_detail_data_flag:

        ws['B' + str(current_row_flag)].font = title_font

        ws['B' + str(current_row_flag)] = name + ' 详细数据'

        ws['B' + str(table_row)].fill = table_fill

        ws['B' + str(table_row)].border = f_border

        ws['B' + str(table_row)].alignment = c_c_alignment

        ws['B' + str(table_row)] = '日期时间'

        time = times[0]

        has_data = False

        max_row = 0

        if len(time) > 0:

            has_data = True

            max_row = table_row + len(time)

        if has_data:

            for i in range(0, len(time)):

                col = 'B'

                row = str(table_row + 1 + i)

                ws[col + row].font = title_font

                ws[col + row].alignment = c_c_alignment

                ws[col + row] = time[i]

                ws[col + row].border = f_border

            for i in range(0, ca_len):

                col = chr(ord('C') + i)

                ws[col + str(table_row)].fill = table_fill

                ws[col + str(table_row)].font = title_font

                ws[col + str(table_row)].alignment = c_c_alignment

                ws[col + str(table_row)] = reporting_period_data['names'][i] + " (" + reporting_period_data['units'][

                    i] + ")"

                ws[col + str(table_row)].border = f_border

                # 39 data

                time = times[i]

                time_len = len(time)

                for j in range(0, time_len):

                    row = str(table_row + 1 + j)

                    ws[col + row].font = title_font

                    ws[col + row].alignment = c_c_alignment

                    ws[col + row] = round(reporting_period_data['values'][i][j], 0)

                    ws[col + row].border = f_border

                bar = BarChart()

                labels = Reference(ws, min_col=2, min_row=table_row + 1, max_row=max_row)

                bar_data = Reference(ws, min_col=3 + i, min_row=table_row, max_row=max_row)

                bar.add_data(bar_data, titles_from_data=True)

                bar.set_categories(labels)

                bar.height = 5.25

                bar.width = 18

                bar.dLbls = DataLabelList()

                bar.dLbls.showVal = True

                bar.dLbls.showPercent = True

                chart_col = 'B'

                chart_cell = chart_col + str(current_row_flag + 1 + 5 * i)

                ws.add_chart(bar, chart_cell)

    else:

        for i in range(37, 69 + 1):

            ws.row_dimensions[i].height = 0.1

    filename = str(uuid.uuid4()) + '.xlsx'

    wb.save(filename)