[Tutor] (no subject)

[trent shipley]

Zumstein, Felix
Python for Excel
O'Reilly Media, Inc.
Mar 2021

On Fri, Aug 11, 2023 at 10:02 AM Alan Gauld via Tutor <tutor at python.org>
wrote:

> On 11/08/2023 14:52, Mats Wichmann wrote:
> > On 8/11/23 01:31, Avijit Shukla wrote:
> >> I need to learn about reading excel files..from system..
> >>
> >> if possible you can share steps with sample code??
> >
> > I think you got one response already
>
> I think this is the extra "detail" that I asked for.
> He wants to *read* excel files *from the system*,
> whatever that means!
>
> Taken at face value, I assume he wants to read
> the data from a .xlsx file. And for that the best
> module is probably xlrd. Although I notice that a
> web search suggests pandas.read() can cope with xlsx
> files too. But pandas is quite a heavyweight module
> if you only want to read the data.
>
> OTOH if you were doing serious data processing
> then pandas is probably the best option!
>
> There are plenty pandas tutorials on the web
> and on Youtube so I'll let the OP search for those.
>
> The official xlrd module tutorial is here:
>
> https://xlrd.readthedocs.io/en/latest/
>
> You also mentioned openpyxl which I've never used
> but notice it can be used to both read and write
> which might be an advantage...
>
> I also don't know how any of these tools cope
> with tabbed sheets, calculated fields and macros.
>
> --
> Alan G
> Author of the Learn to Program web site
> http://www.alan-g.me.uk/
> http://www.amazon.com/author/alan_gauld
> Follow my photo-blog on Flickr at:
> http://www.flickr.com/photos/alangauldphotos
>
>
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> https://mail.python.org/mailman/listinfo/tutor
>