If you don't need to do any specific data analysis using pandas, try
openpyxl.
It will read xlsm files and it quite straight forward to use.
https://openpyxl.readthedocs.io/en/stable/
pip install openpyxl.
Ian
--
https://mail.python.org/mailman/listinfo/python-list
On Wed, Sep 2, 2020 at 11:43 AM Steve wrote:
>
> >> Requires numpy, dateutil, pytz, setuptools, and optionally numexpr,
> >> bottleneck, scipy, matplotlib, pytables, lxml, xarray, blosc, snappy,
> >> brotlipy, backports.lzma, statsmodels, sqlalchemy, psycopg2, and whatnot.
>
> >It means you need
From: Chris Angelico
Sent: Tuesday, September 1, 2020 5:08 PM
To: Steve
Cc: Python
Subject: Re: What kind of magic do I need to get python to talk to Excel xlsm
file?
On Wed, Sep 2, 2020 at 6:59 AM Steve wrote:
>
> Wow, that is quite a list
> Here is what I narrowed it down to. Wh
On Wed, Sep 2, 2020 at 6:59 AM Steve wrote:
>
> Wow, that is quite a list
> Here is what I narrowed it down to. What does that paragraph starting with
> "Requires" mean?
>
> ===
> Pandas: a cross-section and time series data analysis toolkit.
>
> Requires numpy
lar system solely inhabited by
functioning robots.
-Original Message-
From: Python-list On Behalf
Of Chris Angelico
Sent: Tuesday, September 1, 2020 4:44 PM
To: Python
Subject: Re: What kind of magic do I need to get python to talk to Excel xlsm
file?
On Wed, Sep 2, 2020 at 6:17 AM St
On Wed, Sep 2, 2020 at 6:17 AM Steve wrote:
>
> Ok, I think I ran into this about a year ago when this was suggested back
> then.
>
> I entered “pip install pandas”
>
> I am told to “install Anaconda which can be deleted later” (huh?)
> Then it tells me “Installing with “Miniconda” (huh? Huh?)
lto:Gronicus@sga.ninja> >
Subject: Re: What kind of magic do I need to get python to talk to Excel xlsm
file?
Hi Steve,
Maybe something like this:
import pandas as pd
dt = pd.read_excel("myData.xls", sheet_name="mySheetName", skiprows=0,
usecols=list(range(0,11
Steve writes:
> Glutton for punishment, I am looking into designing another .py program. I
> would like to pull two columns of information from Excel but the more I look
I've found the xlrd module easy to use for extracting data from
Excel files. But I've only used it on .xsl and .xsls. I've neve
Steve wrote:
> Glutton for punishment, I am looking into designing another .py program.
> I would like to pull two columns of information from Excel but the more I
> look
> into coding on the 'net, the more confusing it looks. I don't understand
> what I need to import or install to get the link
