thank you very much for your advice, but unfortunately this method taking
more than 10 minutes too.
if there's a any better way please.
response = HttpResponse(result.read(),
mimetype='application/ms-excel')
response['Content-Disposition'] = 'attachment;
filename=Car_details_%s.xls' % today
||
\/
response = HttpResponse(result.read(), mimetype='text/csv')
response['Content-Disposition'] = 'attachment;
filename=Car_details_%s.csv' % today
2011/4/28 Sells, Fred <fred.se...@adventistcare.org>
> Since Excel will import a csv file, why not just write a csv file. In
> mysql, while ugly, you could shell down and use the mysql command line
> options to export a query to csv.
>
>
>
> *From:* django-users@googlegroups.com [mailto:
> django-users@googlegroups.com] *On Behalf Of *Od-Erdene Ch
> *Sent:* Thursday, April 28, 2011 6:23 AM
> *To:* django-users@googlegroups.com
> *Subject:* This section is converting database table to excel file
>
>
>
> *hi there*
>
> *this section is converting database table to excel file.*
>
>
>
> *problem is when converting database table to excel file (it is containing
> 6400 [six thousand four hundred] rows) it is spending more than 10 minutes.
> *
>
> *that is very slow. is there any idea to make more faster. Help me*
>
>
>
>
>
> *CODE:*
>
>
>
> if request.GET.has_key('excel') :
>
> if request.GET['excel'] == "true":
>
> qs = CarDetails.objects.all().order_by(sord + sidx)
>
> wb = xlwt.Workbook()
>
> ws = wb.add_sheet(u'CarDetails')
>
> labels = [u"型式", u"車名", u"車輌詳細コード",u'車体形状',u"類別区分番号",u"車輌重量諸元
> ",u"全長",
>
> u"全幅",u"全高",u"用途",u"形状",u"原動機型式",u"総排気量",u"営・自家用区分",
>
> u"乗車定員",u"最大積載量",u"車輌総重量",u"燃料の種類",u"乗車定員括弧",u"
> 最大積載量括弧",
>
> u"ローター数",u"燃料種類",u"燃料種類括弧 その他"]
>
>
>
> ws.write_merge(0, 0, 0, 22, u'車輌マスター管理', get_title_style())
>
>
>
> label_style = get_label_style2()
>
> for i in range(len(labels)) :
>
> ws.write(1, i, labels[i], label_style)
>
> ws.col(0).width = get_computed_width(-30) # by pixel
>
> ws.col(1).width = get_computed_width(150)
>
> ws.col(2).width = get_computed_width(150)
>
> ws.col(3).width = get_computed_width(150)
>
> ws.col(4).width = get_computed_width(150)
>
> ws.col(5).width = get_computed_width(150)
>
> ws.col(6).width = get_computed_width(150)
>
> ws.col(7).width = get_computed_width(150)
>
> ws.col(8).width = get_computed_width(150)
>
> ws.col(9).width = get_computed_width(150)
>
> ws.col(10).width = get_computed_width(150)
>
> ws.col(11).width = get_computed_width(150)
>
> ws.col(12).width = get_computed_width(150)
>
> ws.col(13).width = get_computed_width(150)
>
> ws.col(14).width = get_computed_width(150)
>
> ws.col(15).width = get_computed_width(150)
>
> ws.col(16).width = get_computed_width(150)
>
> ws.col(17).width = get_computed_width(150)
>
> ws.col(18).width = get_computed_width(150)
>
> ws.col(19).width = get_computed_width(150)
>
> ws.col(20).width = get_computed_width(150)
>
> ws.col(21).width = get_computed_width(150)
>
> ws.col(22).width = get_computed_width(150)
>
> today = datetime.strftime(datetime.today(),"%Y-%m-%d")
>
> rown = 2
>
> simple_style = get_simple_style()
>
>
>
> for list in qs :
>
> car_maker_code = ""
>
> car_maker = ""
>
> car_name2 = ""
>
> tax = ""
>
> model = ""
>
> car_name = ""
>
> name = ""
>
> body = ""
>
> class_type_number = ""
>
> weight = ""
>
> length = ""
>
> width = ""
>
> height = ""
>
> usage = ""
>
> view_type = ""
>
> motor_type = ""
>
> totol_piston_cc = ""
>
> is_own = ""
>
> human_size = ""
>
> kg_size = ""
>
> totol_weight = ""
>
> fuel_type = ""
>
> human_size_kakko = ""
>
> kg_size_kakko = ""
>
> rotor_number = ""
>
> fuel_type_kakko = ""
>
> fuel_type_kakko_sonota = ""
>
> if list.model: model = list.model
>
> if list.carname: car_name = list.carname
>
> if list.name: name = list.name
>
> if list.body: body = list.body
>
> if list.class_type_number: class_type_number =
> list.class_type_number
>
> if list.weight: weight = list.weight
>
> if list.length: length = list.length
>
> if list.width: width = list.width
>
> if list.height: height = list.height
>
> if list.usage: usage = list.get_usage_display()
>
> if list.view_type: view_type = list.view_type
>
> if list.motor_type: motor_type = list.motor_type
>
> if list.totol_piston_cc: totol_piston_cc =
> list.totol_piston_cc
>
> if list.is_own: is_own = list.get_is_own_display()
>
> if list.human_size: human_size = list.human_size
>
> if list.kg_size: kg_size = list.kg_size
>
> if list.totol_weight: totol_weight = list.totol_weight
>
> if list.fuel_type: fuel_type = list.get_fuel_type_display()
>
> if list.human_size_kakko: human_size_kakko =
> list.human_size_kakko
>
> if list.kg_size_kakko: kg_size_kakko = list.kg_size_kakko
>
> if list.rotor_number: rotor_number = list.rotor_number
>
> if list.fuel_type_kakko: fuel_type_kakko =
> list.fuel_type_kakko
>
> if list.fuel_type_kakko_sonota: fuel_type_kakko_sonota =
> list.fuel_type_kakko_sonota
>
>
>
> ws.write(rown, 0, unicode(model), simple_style)
>
> ws.write(rown, 1, unicode(car_name), simple_style)
>
> ws.write(rown, 2, unicode(name), simple_style)
>
> ws.write(rown, 3, unicode(body), simple_style)
>
> ws.write(rown, 4, unicode(class_type_number), simple_style)
>
> ws.write(rown, 5, unicode(weight), simple_style)
>
> ws.write(rown, 6, unicode(length), simple_style)
>
> ws.write(rown, 7, unicode(width), simple_style)
>
> ws.write(rown, 8, unicode(height), simple_style)
>
> ws.write(rown, 9, unicode(usage), simple_style)
>
> ws.write(rown, 10, unicode(view_type), simple_style)
>
> ws.write(rown, 11, unicode(motor_type), simple_style)
>
> ws.write(rown, 12, unicode(totol_piston_cc), simple_style)
>
> ws.write(rown, 13, unicode(is_own), simple_style)
>
> ws.write(rown, 14, unicode(human_size), simple_style)
>
> ws.write(rown, 15, unicode(kg_size), simple_style)
>
> ws.write(rown, 16, unicode(totol_weight), simple_style)
>
> ws.write(rown, 17, unicode(fuel_type), simple_style)
>
> ws.write(rown, 18, unicode(human_size_kakko), simple_style)
>
> ws.write(rown, 19, unicode(kg_size_kakko), simple_style)
>
> ws.write(rown, 20, unicode(rotor_number), simple_style)
>
> ws.write(rown, 21, unicode(fuel_type_kakko), simple_style)
>
> ws.write(rown, 22, unicode(fuel_type_kakko_sonota),
> simple_style)
>
> rown += 1
>
> result = StringIO()
>
> wb.save(result)
>
> result.seek(0)
>
> response = HttpResponse(result.read(),
> mimetype='application/ms-excel')
>
> response['Content-Disposition'] = 'attachment;
> filename=Car_details_%s.xls' % today
>
> return response
>
>
>
>
>
> *thanks*
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
