Select the correct sheet (XLSX)

PSTO

Hello, when I load an XLSX file, I would like to select the correct sheet, how to do that please ?

sebastiaan

Hi @PSTO ,

In DataMatrix, you can specify the sheet that you want to open like so:

from datamatrix import io
dm = io.readxlsx('my_spreadsheet.xslx', sheet='Name of sheet')

• https://pydatamatrix.eu/1.0/io

Hope this helps!

— Sebastiaan

PSTO

I'm not sure to understand, When I loaded my XLSX in JASP, he only open the first sheet. How to acces datamatrix ? THX

sebastiaan

You posted this in the DataMatrix category, which is a Python library for data analysis. In JASP, I suspect that you cannot specify which sheet you want to open, such that it always opens the first sheet.