data manipulation

[Krishna]

I have a script that reads an excel file and and do manipulations on
it. But, now, I have a text file that needs the same manipulation. I
tried the same script, but it will not work, when I use command such
as: workbook = xlrd.open_workbook('C:/trial.txt'), its giving me
errors saying "expected BOF record". I was wondering how to work
around this. Do I have to do some format conversion to accomplish this
or am I missing something

Thanks
Krishna

 

[Jeff]

The function expects an excel file. It cannot read a plain text
file. You would need to figure out a way to convert the text file
data into an excel format and save it to a new file first.

The proper way to handle this is to make your data processing
functions expect a defined format. Then, you write importer functions
for various types of files that convert the data in each file to the
defined format. That way, you can support various file formats and
reuse your processing functions on all of them.