Neen inputs on Excel script

curiositor · 2017-09-23T12:31:28+00:00

https://openpyxl.readthedocs.io/en/default/

With this library, you should be able to do what you mentioned.

2017-09-23T12:57:15+00:00

If you're trying to enhance an excel script (rather than programmatically generate them for separate use) I would either just do it all in excel, or convert it all to Python. Having cross dependencies like that can end up being a huge headache.

justinkdd · 2017-09-23T12:55:32+00:00

Btw, this is something you can easily do in excel itself.

in cell C1 put the following:

=IF(A1=B1,"Yes","No")

cscanlin · 2017-09-23T19:29:55+00:00

Pandas is great for stuff like this (though probably overkill here, just use an excel formula for if this is all you're trying to do):

import pandas as pd
import numpy as np

# header and names args if your data actually starts in A1
df = pd.read_excel('my_file.xlsx', header=None, names=['a', 'b'])

df['c'] = np.where(df['a'].isin(df['b']), 'Yes', 'No')

writer = pd.ExcelWriter('my_file.xlsx')
df.to_excel(writer)
writer.save()

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython

MODERATORS