>>> 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
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
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
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
> 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