Include Python Code In Excel?

Question

I'd like to be able to include python code snippets in Excel (ideally, in a nice format -- all colors/formats should be kept the same).

What would be the best way to go about it?

EDIT: I just want to store python code in an Excel spreadsheet for an easy overview -- I am not going to run it -- just want it to be nicely visible/formatted as part of an Excel worksheet.

I don't understand what you are trying to archive, do you want run the python in excel? — Trufa
– Trufa, Commented Jun 2, 2011 at 15:11
I just want to store the python code in a worksheet (say, in a textbox), for reference purposes and easy overview of the code. I want the code to be easy to view, with colors etc. — user3262424
– user3262424, Commented Jun 2, 2011 at 15:22
Why? Excel seems to be an incredibly poor tool for code review. — Steven Rumbalski
– Steven Rumbalski, Commented Jun 2, 2011 at 15:34
How about gist.github.com? It might be exactly what you are looking for (minus the excel.) — Eric Wilson
– Eric Wilson, Commented Jun 2, 2011 at 16:37

Steven Rumbalski · Accepted Answer · 2011-06-02 18:05:36Z

2

I think that gist (from github) is precisely what you are looking for. From the description:

Gist is a simple way to share snippets and pastes with others. All gists are git repositories, so they are automatically versioned, forkable and usable as a git repository.

edited Jun 2, 2011 at 18:05

Steven Rumbalski

45.8k10 gold badges96 silver badges125 bronze badges

answered Jun 2, 2011 at 17:25

Eric Wilson

59.8k82 gold badges208 silver badges272 bronze badges

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

1 Comment

user3262424 Over a year ago

I really which things could be embedded into Excel, but if I can't find a solution, this is an alternative.

jsbueno · Accepted Answer · 2011-06-02 21:38:55Z

1

While Excel itself doesnot support other scripting Langauges than VBA, the open source OpenOffice and LibreOffice packages - which include a spreadsheet - can be scriptable with Python. Still, they won't allow Python code to be pasted on teh cells out of the box - but it is possible to write Python code which can act on the spredsheet contents (and do all the other things Python can do).

answered Jun 2, 2011 at 21:38

jsbueno

114k11 gold badges159 silver badges239 bronze badges

Collectives™ on Stack Overflow

Include Python Code In Excel?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related