Tagged Questions
0
votes
2answers
38 views
Converting data from excel file into power point
I am wondering if it possible to automate to extract data from multiple exel file , plot a graph and finally present the data in pointpoint using pre-existing template . I tried Python but could go to ...
2
votes
1answer
46 views
Automate conversion txt to xls
I am looking for the cheapest way of automating the conversion of all the text files (tab-delimited) in a folder structure into .xls format, keeping the shape of columns and rows as it is.
Is there ...
1
vote
1answer
18 views
xlrd original value of the cell
I'm reading xls file using xlrd. The problem is, when xlrd reading value like this "12/09/2012", i get result like this "xldate:41252.0". When I use xlrd.xldate_as_tuple, i get this result:
(2016, ...
0
votes
5answers
61 views
How to export a python list to a csv and add line breaks
I have a python list and I would like to export it to a csv file, but I don't want to store all the list in the same row. I would like to slice the list at a given point and start a new line. ...
0
votes
1answer
40 views
Using python I need to remove commas from my excel file and then convert it to csv
I have the python code to convert an excel file to csv, however portions of the data in the excel file have commas which affects the conversion.
What would be the best way, staying within python, to ...
0
votes
2answers
51 views
Python - How can I install xlutils?
I am using Python 2.5 (and need to stay with that) and have already downloaded xlrd 0.8.0 and xlwt 0.7.2, and they both seem to be working OK.
I will be needing to read from and write to Excel ...
1
vote
2answers
54 views
How can I create dictionary within dictionary
I have the below code:
datedict = defaultdict(set)
with open('d:/info.csv', 'r') as csvfile:
filereader = csv.reader(csvfile, 'excel')
#passing the header
read_header = False
...
0
votes
1answer
37 views
Is Python's xlrd 0.9.2 backward compatible with 0.7?
We're using John Machin's xlrd 0.7.1 in about 20 projects to read Excel spreadsheets. Would updating to the latest version (0.9.2) work out of the box or are there known incompatibilities we should ...
1
vote
0answers
73 views
Issues with excel file. XLRDError: Unsupported format, or corrupt file: What kind of file is this?
I have a bit of code that works with an xls file. It works for everything I've thrown at it except this one file and I don't know how to properly identify what this one file is. I get the file off of ...
0
votes
2answers
54 views
Django: openpyxl saving workbook as attachment
Hi I have a quick question. I didn't find answer in internet maybe someone of you can help me.
So i want to save workbook as attachment but I don't know how lets see an example :
from openpyxl ...
0
votes
1answer
41 views
does Pyvot require Visual Studio?
Possibly a dumb question, but after a lot of searching, I haven't yet found an unambiguous answer. The site states
Pyvot requires CPython 2.6 or 2.7 with the Python for Windows
extensions ...
0
votes
0answers
29 views
Python: how to improve win32 excel interface overriding methods?
I'm using win32com interface to access excel files. My idea is to improve some excel function to avoid boring code. As example I would write
val = sheet.Range(coord).Value
where coord may be one ...
-1
votes
0answers
36 views
Python Win32, how to save an XLSX as a PDF?
in http://msdn.microsoft.com/en-us/library/bb241279.aspx
The PDF of the code is 57, but how to convert all the sheet into PDF?
0
votes
1answer
58 views
Can I export pandas DataFrame to Excel stripping tzinfo?
I have a timezone aware TimeSeries in pandas 0.10.1. I want to export to Excel, but the timezone prevents the date from being recognized as a date in Excel.
In [40]: resultado
Out[40]:
fecha_hora
...
0
votes
0answers
39 views
ZeroMQ -> Excel RTD server .. Is it that difficult?
I am just starting with zeromq. I've got various platforms / languages all talking to each other nicely now and I must admit - it does a really good job.
The last piece of the jigsaw I'd like to do ...
