コード例 #1
0
ファイル: views.py プロジェクト: SongJLG/johan-doc
    def render_data(self, request):
        from report import Report, Paragraph, Spacer, Table
        from django.http import HttpResponseRedirect
        from mysite.urls import tmpDir, tmp_url
        cells=[cell_format(a) for a in self.cells]
        rn=request.REQUEST.get("reportname",'')
        
        title=rn and rn or self.title
        if self.head=="":
            heads=[k for k in self.data[0].keys()]
        else:
            heads=self.head
        file_name=u"%s_%s.pdf"%(title, datetime.datetime.now().strftime("%Y%m%d%H%M%S"))
        filecode=request.REQUEST.get("fielcode",'gb18030')
        
        whs=colwidths = [len(i.encode(filecode)) for i in heads]
        wcells=[[len(item.encode("gb18030")) for item in line] for line in cells[:40]]
        wcells.insert(0, whs)
        chars_cnt=sum(wcs)
        page_size=get_page_size(chars_cnt)

        p=Report()
        p.set_page_size(page_size[1], page_size[2])
        allws=min(6, max(3.7, 2.85*(p.width-23)/chars_cnt)) #计算每个字符的最大可能宽度
        page_head=(Paragraph(title, p.style_title), )
        grid_head=[Paragraph(col_text, p.style_grid_head) for col_text in heads]
        p.colwidths=[(allws*item or 20) for item in wcs]
        p.grid_head_height=20
        p.row_height=15
        p.print_report(cells, page_size[3], grid_head, page_head, file_name=u"%s/%s"%(tmpDir(), file_name))
        f="/"+tmp_url()+file_name
        return HttpResponseRedirect(f.encode("utf-8"))
コード例 #2
0
ファイル: views.py プロジェクト: SongJLG/johan-doc
 def render_data(self, request):
     import xlwt
     from django.http import HttpResponse,HttpResponseRedirect
     from mysite.urls import tmpDir, tmp_url
     rn=request.REQUEST.get("reportname",'')
     title=rn and rn or self.title
     sheet_name=u"%s_%s"%(title, datetime.datetime.now().strftime("%Y%m%d%H%M%S"))
     
     if self.head=="":
         heads=[k for k in self.data[0].keys()]
     else:
         heads=self.head
     
     lines=[xls_format(a) for a in self.cells]
     lines.insert(0, xls_format(self.head))
     filecode=request.REQUEST.get('filecode','gb18030')#编码
     
     wb = xlwt.Workbook(encoding=u"%s"%filecode)
     ws = wb.add_sheet(sheet_name)
     
     row_index=0
     for row in lines:
         col_index=0
         for col in row:
             ws.write(row_index,col_index,col)
             col_index+=1
         row_index+=1
     filename="%(d1)s_%(d2)s.xls"%{
         "d1":u"%s"%title,
         "d2":datetime.datetime.now().strftime("%Y%m%d%H%M%S")
     }
     wb.save(u"%s/%s"%(tmpDir(), filename))
     f="/"+tmp_url()+filename
     return HttpResponseRedirect(f.encode("utf-8"))
コード例 #3
0
ファイル: views.py プロジェクト: xiaojiangcode/johan-doc
    def render_data(self, request):
        import xlwt
        from django.http import HttpResponse, HttpResponseRedirect
        from mysite.urls import tmpDir, tmp_url
        rn = request.REQUEST.get("reportname", '')
        title = rn and rn or self.title
        sheet_name = u"%s_%s" % (
            title, datetime.datetime.now().strftime("%Y%m%d%H%M%S"))

        if self.head == "":
            heads = [k for k in self.data[0].keys()]
        else:
            heads = self.head

        lines = [xls_format(a) for a in self.cells]
        lines.insert(0, xls_format(self.head))
        filecode = request.REQUEST.get('filecode', 'gb18030')  #编码

        wb = xlwt.Workbook(encoding=u"%s" % filecode)
        ws = wb.add_sheet(sheet_name)

        row_index = 0
        for row in lines:
            col_index = 0
            for col in row:
                ws.write(row_index, col_index, col)
                col_index += 1
            row_index += 1
        filename = "%(d1)s_%(d2)s.xls" % {
            "d1": u"%s" % title,
            "d2": datetime.datetime.now().strftime("%Y%m%d%H%M%S")
        }
        wb.save(u"%s/%s" % (tmpDir(), filename))
        f = "/" + tmp_url() + filename
        return HttpResponseRedirect(f.encode("utf-8"))
コード例 #4
0
    def render_data(self, request):
        from report import Report, Paragraph, Spacer, Table
        from django.http import HttpResponseRedirect
        from mysite.urls import tmpDir, tmp_url
        import os
        cells = [cell_format(a) for a in self.cells]
        rn = request.REQUEST.get("reportname", '')

        file_path = tmpDir() + "/report_file"
        if not os.path.exists(file_path):
            os.makedirs(file_path)

        title = rn and rn or self.title
        if self.head == "":
            #print self.data[0]
            heads = [k for k in self.data[0].keys()]
        else:
            heads = self.head
        file_name = u"%s_%s.pdf" % (
            title, datetime.datetime.now().strftime("%Y%m%d%H%M%S"))
        filecode = request.REQUEST.get("fielcode", 'gb18030')

        whs = colwidths = [len(i.encode(filecode)) for i in heads]
        wcells = [[len(item.encode("gb18030")) for item in line]
                  for line in cells[:40]]
        wcells.insert(0, whs)
        wcs = map(max, zip(*wcells))  #计算每列的最大值
        chars_cnt = sum(wcs)
        page_size = get_page_size(chars_cnt)

        p = Report()
        p.set_page_size(page_size[1], page_size[2])
        allws = min(6, max(3.7,
                           2.85 * (p.width - 23) / chars_cnt))  #计算每个字符的最大可能宽度
        page_head = (Paragraph(title, p.style_title), )
        grid_head = [
            Paragraph(col_text, p.style_grid_head) for col_text in heads
        ]
        p.colwidths = [(allws * item or 20) for item in wcs]
        p.grid_head_height = 20
        p.row_height = 15
        p.print_report(cells,
                       page_size[3],
                       grid_head,
                       page_head,
                       file_name=u"%s/%s" % (file_path, file_name))
        f = "/" + tmp_url() + "report_file/" + file_name
        return HttpResponseRedirect(f.encode("utf-8"))
コード例 #5
0
ファイル: grid_export.py プロジェクト: baksoikan/zktime_wlm
    def render_data(self, request):
        import xlwt
        from django.http import HttpResponse, HttpResponseRedirect
        from mysite.urls import tmpDir, tmp_url
        rn = request.REQUEST.get("reportname", '')
        title = rn and rn or self.title
        sheet_name = u"%s_%s" % (
            'Sheet', datetime.datetime.now().strftime("%Y%m%d%H%M%S"))

        file_path = tmpDir() + "/report_file"
        if not os.path.exists(file_path):
            os.makedirs(file_path)

        if self.head == "":
            #print self.data[0]
            heads = [k for k in self.data[0].keys()]
        else:
            heads = self.head

        lines = [xls_format(a) for a in self.cells]
        filecode = request.REQUEST.get('filecode', 'gb18030')  #编码

        wb = xlwt.Workbook(encoding=u"%s" % filecode)
        ws = wb.add_sheet(sheet_name)

        fnt = xlwt.Font()
        fnt.name = 'Arial'
        #fnt.colour_index = 4
        #fnt.bold = True

        borders = xlwt.Borders()
        borders.left = 1
        borders.right = 1
        borders.top = 1
        borders.bottom = 1

        align = xlwt.Alignment()
        align.horz = xlwt.Alignment.HORZ_CENTER
        align.vert = xlwt.Alignment.VERT_CENTER

        style = xlwt.XFStyle()
        style.font = fnt
        style.borders = borders
        style.alignment = align

        row_index = 0
        for row in lines:
            col_index = 0
            for col in row:
                ws.write(row_index, col_index, col, style)
                ws.col(col_index).width = 0x0d00 + 2000
                col_index += 1
            row_index += 1
        filename = "%(d1)s_%(d2)s.xls" % {
            "d1": u"%s" % title,
            "d2": datetime.datetime.now().strftime("%Y%m%d%H%M%S")
        }

        #        response = HttpResponse(mimetype=u"application/vnd.ms-excel; charset=utf-8")
        #        response["Content-Disposition"] = u"attachment;"
        #         filename=%(d1)s_%(d2)s.xls"%{
        #            "d1":title,
        #            "d2":datetime.datetime.now().strftime("%Y%m%d%H%M%S")
        #        }
        #       wb.save(response)
        #       return response
        wb.save(u"%s/%s" % (file_path, filename))
        f = "/" + tmp_url() + "report_file/" + filename
        return HttpResponseRedirect(f.encode("utf-8"))