Is there a way to perform the following workflow:
Select cells in an Excel spreadsheet
Copy them using Ctrl+C
Get the content the selected cells in a form of a python list or numpy array into the IPython shell?
解决方案
Update: It seems that the readline thing that @PauloAlmeida mentioned is turned on by default in the 1.0 verison of IPython. So all you have to do is:
from numpy import array
Copy the cells from the spreadsheet
Hit Alt+V instead of Ctrl+V
And you will get in IPython something like:
array([[1, 1], [2, 2]])
Or you can use the pandas library read_clipboard method.
import pandas as pd
pd.read_clipboard() # If you have selected the headers
pd.read_clipboard(header=None) # If you haven't selected the headers
This will return you a pandas DataFrame object which acts similarly to a spreadsheet. You can find more about it in their official documentation.