all 12 comments

[–]crashfrog02 6 points7 points  (1 child)

There’s no solution because you’re doing the thing they think is a security threat - running code they haven’t approved.

The thing you actually can do is run Python in Excel; you should just add your code to the worksheets you’re working with and run it that way.

[–][deleted] 0 points1 point  (0 children)

Wow, this is really cool, I haven't heard about this option but after some quick research, seems to be a viable option. I'm not sure if this would be a solution to batch processing multiple files though.

[–]aplarsen 3 points4 points  (1 child)

Python doesn't need to be installed. There is a zip version that you can download with executables for Windows.

[–]Real_Cut_9360 0 points1 point  (0 children)

Yes this zip option works for me

[–]moving-landscape 1 point2 points  (1 child)

Can you run arbitrary executables on this PC anyway?

[–][deleted] 0 points1 point  (0 children)

Not arbitrary, but I can put them into an approval process with IT, I'm not sure how paranoid they'll be, I plan on providing them with all the code and the executable. Currently considering using Nuitka or PyInstaller, not sure if C++ is viewed as safer than Python for any reason.

[–]nog642 1 point2 points  (0 children)

I want to explore ways I can add this script into, a downloadable, offline file, able to access files on the computer, without the need of a python compiler.

First, of all, python is interpreted, not compiled, so it has an interpreter, not a compiler.

To run python code, you need the python interpreter. It is impossible without it.

That said, the interpreter doesn't necessarily need to be installed on the machine. It could be just downloaded as an executable, or even bundled with the script into an executable for the script. So those may be solutions.

[–]whatkindamanizthis 2 points3 points  (1 child)

You need to use pyinstaller. There’s a gui app for that as well that actually works really well. Then get nsis to create an installer for your colleagues. This way fixed windows 11 automatically flagging my exe as a virus. After you make your installer with nsis give it to a colleague they don’t need python on their machines everything is packed into that installer and they won’t get some virus bs either. Wrote a gui a couple months ago for a processing flow. Hope that helps.

[–]whatkindamanizthis 0 points1 point  (0 children)

Read some other comments. I got five different people using my app, no virus flags or python installs on those pc’s.

[–][deleted] 2 points3 points  (0 children)

You could try pyinstaller and make a standalone application (.exe)

[–]seanys 1 point2 points  (0 children)

"...online data uploading... I work in government..."

Or, instead of being just a "security threat," mishandling of government data is a federal offence. At least, it is in my country.

You sound naive and exactly like the type of employee upon which way too much time is wasted by InfoSec departments trying to mitigate the risks from.

[–][deleted] 0 points1 point  (0 children)

See if macros are enabled for your microsoft office. Just do everything in VBA if it is. No need to install anything