[BangPypers] { Parsing excel file }

[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, konark modi <modi.konark at gmail.com> wrote:
 
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
<noufal at nibrahim.net.in>wrote:

> 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, enhance, so on.  any suggestions on how to parse the
> > keywords or can we parse italized / bolded words.  any suggestions on
> > python library to work on such requirement ?
>
> I can see a few.
> % pip search excel | grep -iw excel | wc -l
> 38
>
> One of those might be useful. xlwt is something I've used in the past.
>
> [...]
>
>
> --
> Cordially,
> Noufal
> http://nibrahim.net.in
> _______________________________________________
> BangPypers mailing list
> BangPypers at python.org
> https://mail.python.org/mailman/listinfo/bangpypers

>
_______________________________________________
BangPypers mailing list
BangPypers at python.org
https://mail.python.org/mailman/listinfo/bangpypers