How to apply bold style to a specific word in excel file , using python ?
hi , 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 ? ...
pyexcelerator
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 features in pyExcelerator or xlrd modules.. I dont want to use win32com modules! it makes...
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 sometimes reconfigure the script to handle them. With the one of the templates i ran into pro...
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 contents and deleting it. The problem is that pyExcelerator only way to extract the contents...
How to create an excel file with an autofilter in the first row with xlwt?
Hi, 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 ...
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 ...
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 have a blank template that I copy and populate with the data. In this case, is there a way to...
Adding percentage in python - xlwt / pyexcelerator
Hello, 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. ...