Python read Excel file

1. Read the CSV file in Python :

CSV is a comma delimiter format generally we use the EXECL generated format is XLS and xlsx directly renamed to CSV will be error:

Error: Line contains NULL byte

Insun Solution: The cause of the error is to rename the execl file with the suffix xls to csv as normal. If you save as a CSV file, you won't get an error.

For example, we have a CSV file:

#!/usr/bin/env python

# -*- coding:utf-8 -*-   import csv with  open ( ‘egg.csv‘ , ‘rb‘ ) as f: reader  = csv.reader(f) for row  in reader: print row

Python read Excel file