PyExcelerator is a Python library for reading files compatible with Excel 95 or later and writing files compatible with Excel 97 or later.
Questions tagged [pyexcelerator]
15 questions
9
votes
3 answers
TypeError:'datetime.datetime' object is not subscriptable
#!/usr/bin/env python
# coding: utf-8
import MySQLdb
import os,sys
import time
import datetime
from pyExcelerator import *
def main():
'''get datas from mysql to excel'''
w=Workbook()
ws=w.add_sheet('user')
…
user1477974
- 91
- 1
- 1
- 2
6
votes
3 answers
How to create an excel file with an autofilter in the first row with xlwt?
I am using Python 2.6 + xlwt module to generate excel files.
Is it possible to include an autofilter in the first row with xlwt or pyExcelerator or anything else besides COM?
Thanks
jbochi
- 28,816
- 16
- 73
- 90
5
votes
3 answers
How to apply bold style to a specific word in Excel file using Python?
I am using pyexcelerator Python module to generate Excel files.
I want to apply bold style to part of cell text, but not to the whole cell.
How to do it?
Ashish
- 430
- 7
- 13
3
votes
2 answers
Use pyExcelerator to generate dynamic Excel file with Django. Ensure unique temporary filename
I'd like to generate a dynamic Excel file on request from Django. The library pyExcelerator does this, but I haven't found any way to use the contents of the Excel file without generating a server-side temporary Excel file, reading it, using its…
djen
- 515
- 1
- 4
- 7
2
votes
4 answers
pyExcelerator or xlrd - How to FIND/SEARCH a row for the given few column data?
Python communicating with EXCEL... i need to find a way so that I can find/search a row for given column datas. Now, i m scanning entire rows one by one... It would be useful, If there is some functions like FIND/SEARCH/REPLACE .... I dont see these…
user94468
2
votes
4 answers
Adding percentage in python - xlwt / pyexcelerator
just a quick question, how to add percent sign to numbers without modifying number. I have tried format percent with myStyleFont.num_format_str = '0.00%' but it multiplies with 100 but I need just to append percent.
Ty in advance.
Regards.
Whit3H0rse
- 569
- 2
- 8
- 16
2
votes
3 answers
pivots using pyExcelerator/xlrd
How can I go about creating a worksheet (within an excel workbook) with a pivot table using python libs like pyExcelerator / xlrd? I need to generate a daily report that has a pivot table to summarize data on other sheets. One option would be to…
Raj N
- 955
- 1
- 9
- 10
2
votes
1 answer
merge excel cells using pyExcelerator
I want to merge two cells in excel using pyExcelerator ,
ws.write_merge(r1=0,r2=1,c1=0, c2=0, label='test1', style=style1)
#merge cell1(row=0, column=0) with cell2(row=1, column=0)
Why the errors happen?
AssertionErrors,0 < 0 errors
e.b.white
- 783
- 3
- 7
- 17
2
votes
2 answers
pyExcelerator date format
I have been using pyExcelerator library for a while, it works nicely. Now, I would like to be able to export python dates as Date format in the excel sheet. I cannot find out (I read the documentation) how to do.
Any suggestions ?
gpasse
- 4,380
- 7
- 44
- 75
1
vote
1 answer
pyExcelerator and utf8?
I have stolen found the following code on stackoverflow (but forgot where, sorry):
#!/usr/local/bin/python
import string
import sys
import getopt
import re
import os
import os.path
import csv
from pyExcelerator import *
def usage():
""" Display…
nonchip
- 1,084
- 1
- 18
- 36
1
vote
1 answer
pyexcelerator: how to delete a excel-sheet by sheet-name
As titled, I'm using pyexcelerator to operate excel files.
Code:
from pyExcelerator import parse_xls
fpath='D:\\Capacity_20120811.xls'
eData=parse_xls(fpath)
>>> eData
[(u'testExcelReport_hr',
{(0, 0): u'Deletetime',
(0, 1): u'Food',
(0,…
Scott 混合理论
- 2,263
- 8
- 34
- 59
0
votes
0 answers
how to increase column and change background color
I am using version 0.6.4.1 of pyexcelerator in a python 2.7 application. I know there is this website https://pyexcelerator.readthedocs.io/en/latest/ which contains some documentation about how to use the library, but it is a bit difficult for me to…
semantic-dev
- 1,095
- 3
- 14
- 27
0
votes
2 answers
How can i store excel file created using pyExcelerator as input for db.BlobProperty()
How can i store excel file created using pyExcelerator as input for db.BlobProperty() ?
Actally what i need is that Using taskqueue program will create a excel file and store it in the datastore. And will send a link to the users to download the…
Nijin Narayanan
- 2,269
- 2
- 27
- 46
0
votes
2 answers
How to color the entire row using xlwt util of pyexcelerator
The util talks about a function called this
style0 = xlwt.easyxf(
'font: name Times New Roman, colour_index red'
)
there is color red instead of color_index too .
Is there any provision to color the entire row?
Vinod K
- 1,885
- 11
- 35
- 45
0
votes
2 answers
pyExcelerator has problems reading some files
I've got a problem using pyExcelerator when reading some xls-files.
There're some python scripts i wrote, that use this library to parse XLS-files and populate database with info.
The templates for the files these scripts parse may vary and i…
DataGreed
- 13,245
- 8
- 45
- 64