Re: (no subject)
Alan Gauld via Tutor <[email protected]>
| Newsgroups | gmane.comp.python.tutor |
|---|---|
| Message-ID | <[email protected]> |
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 - [email protected] To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor