Methods of reading in and creating a list/array with excel information from excel

Question

Imagine I am given two columns: a,b,c,d,e,f and e,f,g,h,i,j (commas indicating a new row in the column)

How could I read in such information from excel and put it in an two separate arrays? I would like to manipulate this info and read it off later. as part of an output.

In excel you open VBA and you make your variable equal to the range of the columns you want. See this question — Forward Ed
– Forward Ed, Commented May 4, 2016 at 20:57
@lismUK quite possible, but not stated, and the question was tagged with excel. — Forward Ed
– Forward Ed, Commented May 4, 2016 at 22:22
@LismUK Yes they are, but again the question does not rule out the possibility of VBA within excel. Python is a very educated guess, but not the sole possibility. — Forward Ed
– Forward Ed, Commented May 4, 2016 at 22:29

Thtu · Accepted Answer · 2016-05-04 21:05:08Z

1

You have a few choices here. If your data is rectangular, starts from A1, etc. you should just use pandas.read_excel:

import pandas as pd
df = pd.read_excel("/path/to/excel/file", sheetname = "My Sheet Name")
print(df["column1"].values)
print(df["column2"].values)

If your data is a little messier, and the read_excel options aren't enough to get your data, then I think your only choice will be to use something a little lower level like the fantastic xlrd module (read the quickstart on the README)

answered May 4, 2016 at 21:05

Thtu

2,03217 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Methods of reading in and creating a list/array with excel information from excel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related