How to read tabular data copied from Excel into clipboard using python?

Question

Is it possible to fetch the tabular data copied from Excel into a list, tuple or dictionary using python? The data will contain multiple rows and columns, such as range A1:B10, therefore the python array should contain row and column index information as well

Answer 1

I recommend you to save the file as csv and use numpy.genfromtxt

For instance

import numpy as np
data = np.genfromtxt("G:/mydata.csv", delimiter=',', dtype=object)

Choose your params accordingly. From an array you can easily convert to anything you like. If you know, that you have doubles all over, you can set dtype=np.float forthwith.