I'm trying to make a parser in python, and what this will do will convert csv into an excel document (xls), is there a way you can format a csv in a python script to a certain excel layout? I'm finding this very difficult and don't know where to start
4
-
Have you looked at the csv module? docs.python.org/2/library/csv.htmlEdgeCaseBerg– EdgeCaseBerg2015-08-06 14:19:41 +00:00Commented Aug 6, 2015 at 14:19
-
have you seen openpyxl? There seem to be several libraries already, although I haven't tried them - should make the excel-facing side easier.Steven Kay– Steven Kay2015-08-06 14:22:55 +00:00Commented Aug 6, 2015 at 14:22
-
stackoverflow.com/questions/17684610/python-convert-csv-to-xlsx dupFirebladeDan– FirebladeDan2015-08-06 14:28:30 +00:00Commented Aug 6, 2015 at 14:28
-
possible duplicate of Recommend a Python library to read Excel XLS filesTolio– Tolio2015-08-06 14:29:11 +00:00Commented Aug 6, 2015 at 14:29
Add a comment
|
2 Answers
Welcome to StackOverflow Shaneyg8! Since this is your first post I figure I'd add a few notes about the site while answering your question.
First off:
Python CSV Module will help you with the CSV part. You can easily read a CSV and perform operations on each row like so:
>>> import csv
>>> with open('eggs.csv', 'rb') as csvfile:
... spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
... for row in spamreader:
... #Do Stuff!
Second, check out the excellent resource commented by Steven Kay and choose the one whose documentation makes the most sense to you. I'd probably start with openpyxl since it's recommended by the list. Though choosing the right library will be up to your needs and which formats you plan to support and handle with your program.
Last, when you post on Stack Overflow you should let us know what you've tried so far. Did you google your question first? Did you look up csv/excel libraries before asking? Did you try looking up "python convert csv to xlsx"? These are things that can answer your question faster than any of us can, and once you put in that effort to try, if you find yourself lost or wondering how to use feature X, then come t the site, let us know about your issue, and ask the specific question for clarification.
The more information you give us about what you tried, the more information we can give back to you and future viewers of your question.
In your case, you may want to look at the two questions that are related/similar to your question here:
https://stackoverflow.com/questions/3504604/recommend-a-python-library-to-read-excel-xls-files
Comments
I believe this is a duplicate of Recommend a Python library to read Excel XLS files, but I will answer to give you the directions.
As commented by @EdgeCaseBerg, you can use CSV File Reading and Writing along with xlrd to achieve what you want.
