[BangPypers] { Parsing excel file }

2014-03-10 Thread Shashidhar Paragonda
>>> Hello python hackers >>> I have a excel file which is .xls format. >>> My requirement is: the excel file contains a manual test cases, in second column, I need to read a file and extract thekeywords like : Login, logout, click to optimize, enhance, so on. >>> any suggestions on how to parse the

Re: [BangPypers] { Parsing excel file }

2014-03-10 Thread Noufal Ibrahim KV
On Mon, Mar 10 2014, Shashidhar Paragonda wrote: > Hello python hackers > > I have a excel file which is .xls format. My requirement is: the > excel file contains a manual test cases, in second column, I need to > read a file and extract thekeywords like : Login, logout, click to > optimize, enh

Re: [BangPypers] { Parsing excel file }

2014-03-10 Thread konark modi
Hi For parsing .xls files with Python, I've used xlrd lib ( https://pypi.python.org/pypi/xlrd) quite extensively. Let's you move around multiple sheets aswell and parse data easily. Regards Konark On Mon, Mar 10, 2014 at 3:59 PM, Noufal Ibrahim KV wrote: > On Mon, Mar 10 2014, Shashidhar Parag

Re: [BangPypers] { Parsing excel file }

2014-03-10 Thread karthik prakash
Hi, There are a couple of options, for excel connectivity in Python. XLRD :- Reading from XLS and XLSX files. XLWT :- Writing to XLS files (currently no support for XLSX) OPENPYXL :- Read and Write only XLSX file. (No support for XLS) Regards, Karthik   On Monday, 10 March 2014 5:21 PM, kona

Re: [BangPypers] { Parsing excel file }

2014-03-10 Thread Mandar Vaze / मंदार वझे
> OPENPYXL :- Read and Write only XLSX file. (No support for XLS) > We are using openpyxl in our product - mainly because we needed to *create* xlsx files. -Mandar ___ BangPypers mailing list BangPypers@python.org https://mail.python.org/mailman/listinf