如何使用python将Excel数据读取到数组中

在我从事的实验室中，我们处理了96孔板读数器产生的许多数据.我正在尝试编写一个脚本，该脚本将执行一些计算并使用matplotlib输出条形图.

In the lab that I work in, we process a lot of data produced by a 96 well plate reader. I'm trying to write a script that will perform a few calculations and output a bar graph using matplotlib.

问题在于印版读取器将数据输出到.xlsx文件中.我了解某些模块(例如pandas)具有read_excel函数，您能解释一下我应该如何读取excel文件并将其放入数据框吗?

The problem is that the plate reader outputs data into a .xlsx file. I understand that some modules like pandas have a read_excel function, can you explain how I should go about reading the excel file and putting it into a dataframe?

谢谢

24孔板的数据样本(为简单起见):

Data sample of a 24 well plate (for simplicity):

0.0868  0.0910  0.0912  0.0929  0.1082  0.1350
0.0466  0.0499  0.0367  0.0445  0.0480  0.0615
0.6998  0.8476  0.9605  0.0429  1.1092  0.0644
0.0970  0.0931  0.1090  0.1002  0.1265  0.1455