Tagged Questions
0
votes
3answers
56 views
I need to extract data from multiple .txt files and move them to an Excel file, using Python
The .txt file contains 68 lines. Line 68 has 5 pieces of data that I need to extract, but I have no idea how. I have about 20 .txt files, all of which need their line 68 read. I need all of the ...
4
votes
1answer
51 views
Conditionally formatting text strings from Excel using python
I would like to format a spreadsheet (xls or xlsx) so that any cells containing a word or ending with a certain string are formatted by filling the background with a specific color.
For example, if ...
-1
votes
1answer
16 views
Need to save Data from mulitiple instances of a class to different columns in the same excel file using xlwt
I am making this program. The idea is to save the time from a stopwatch to an excel sheet. But it would be better to save them all into one excel sheet. Right now it saves to multiple ones. I just ...
0
votes
0answers
12 views
Run a xlsm marco in ubuntu box
I created a Macro convert xlsm to pdf. Now, i wanna put the xlsm on an ubuntu box, then use a python script to call the convert Macro automatically.
After dig in xlrd & xlwt lib, i found those ...
3
votes
1answer
49 views
removing gridlines from excel using python
I'm trying to remove gridlines from excel worksheet which I created using openpyxl, and it's not working.
I'm doing this:
wb = Workbook()
ws = wb.get_active_sheet()
ws.show_gridlines = False
...
1
vote
1answer
41 views
Python: Modifying Excel files while maintaing formatting
Is there any way to modify a few cells in an existing Excel file without losing formatting, and without using xlutils?
I have access to xlwt, and xlrd, but not xlutils.
Thank you!
3
votes
1answer
32 views
Python and win32com.client seem to be missing methods, in particular SetSourceData
I'm working on using Python to automate some Excel data analysis. I have most of the basics down, but I can't seem to find any way to call SetSourceData or SeriesCollection successfully. I've read ...
3
votes
1answer
55 views
Insert PDF into Excel, Python
I wrote a python script that I use to create a spreasheet with various calculations. I want to further insert a pdf into the spreadhseet (pdf is desireable, but a jpeg is useable). I've been flipping ...
-1
votes
2answers
50 views
Converting data from excel file into power point [closed]
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
58 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
26 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
68 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
45 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
95 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
1answer
32 views
Sort Column using openpyxl
I have created Excel sheet and written data into Excel file.
Do we have any functionality for sort column using openpyxl?
I could not attach Excel sheet and droping one row of excel sheet:
0 ...
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
45 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
104 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
75 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
46 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
40 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
42 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
70 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
56 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 ...
0
votes
0answers
52 views
excel python interface
i am working project where ANAYS WORKBENCH is interfaced with MS EXCEL via python script.
# IronPython imports to enable Excel interop
import clr
clr.AddReference("Microsoft.Office.Interop.Excel")
...
0
votes
1answer
26 views
Reading .xml Excel files in Python
I've some .xml files generated by Excel that I've to read with Python. I looked for Python Excel libraries, but they doesn't seems to read .xml files. Parsing manually seems complicated. What do you ...
1
vote
0answers
38 views
Python - Apply the formatting of an existing workbook to another workbook
I am relatively new to coding in Python, and here is my problem:
1- When I update data of an existing .xlsx file (using openpyxl), the outcome is a .xlsx that looses all the previous formatting. I've ...
1
vote
1answer
51 views
Accessing the value of the intersection of named ranges of an Excel spreadsheet in Python using xlrd?
In Excel VBA, you can use the Intersect function which returns a range object that is the intersection of the arguments. You can then get a value from that like so.
Intersection("Name1", ...
0
votes
1answer
74 views
Access data in Excel - Reuter from python
I'm using Reuters integrated in Excel to retrieve market data. For task automation , I currently use VBA but now I want to switch to python. The package pyxll does not help much because the principle ...
2
votes
1answer
188 views
how to insert jpeg image into excel sheet in unix
I am able to insert bmp images using insert_bitmap command of the xlwt module in python using the following code:
import xlwt
from PIL import Image
book = xlwt.Workbook()
sheet3 = ...
