#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    139
    Rep Power
    3

    Working with Excel


    Hello, i have the need to analyze some data that is in an Excel spreadsheet.

    i need to look through lines of Excel file data and look for specific elements, and write them to a file, etc.

    i know how to do everything except look at the Excel file using Python. Any suggestions?

    Thanks very much.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2012
    Posts
    26
    Rep Power
    0
    I don't think thats directly possible in python (not sure :/)
    maybe an extensio library

    but can't you just save the file in .csv format and open it with

    Code:
    import csv
    with open('yourfile.csv', 'rb') as csvfile:
        data = csv.reader(csvfile)
        for row in data:
            print( ', '.join(row))
    (not sure long ago I used .csv)

    otherwise, google is your friend

    Yegers

IMN logo majestic logo threadwatch logo seochat tools logo