-2

I am working on a project. I need to read a xls file using Python. The intention is I don't want to put hard corded values in my coding, instead I want to read it from the xls sheet, so that if values get changes due to upgrade in xls sheet, it won't affect my coding.

Pratik
  • 9
  • 1
  • 3
    [Have you searched your exact question online?](https://www.google.com/search?q=How+to+read+xls+sheet+using+Python%3F). Please show us your attempts. – BruceWayne Oct 16 '20 at 05:07
  • Does this answer your question? [Reading/parsing Excel (xls) files with Python](https://stackoverflow.com/questions/2942889/reading-parsing-excel-xls-files-with-python) Stack Overflow is not a substitute for [doing your own research](https://meta.stackoverflow.com/q/261592/843953). Please take the [tour], read [ask] and [what's on-topic here](/help/on-topic), and ask a question about a _specific_ problem you're having after you _make an honest attempt_. Don't forget to provide a [mre]. Welcome to Stack Overflow! – Pranav Hosangadi Oct 16 '20 at 05:13

1 Answers1

-1

try this library openpyxl. It supports read/write xlsx with python

Pip install : pip install openpyxl

https://pypi.org/project/openpyxl/

  • Questions as basic as this have usually been asked and answered. In such cases, the recommended course of action is to find the original question and flag / vote to close this one as a duplicate of the original. Please take the [tour] and read [answer]. Welcome to Stack Overflow! – Pranav Hosangadi Oct 16 '20 at 05:14