Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the flying billionaires heads up in the clouds who don’t give a fuck for life offtheline
Damn they found a way to make python slower
Emulate that shit with Java!
I used to make high performance distributed computing server-systems for Investment banks.
Since the advent of Just In Time compiling, Java isn’t slow if properly used.
It can however be stupidly slow if you don’t know what you’re doing (so can something like Assembly: if you’re using a simple algorithm with a O(n) = n^2 execution time instead of something with O(n) = n*log(n) time, it’s going to be slow for anything but a quantum computer, which is, for example, most libraries with sorting algorithms use something more complex than the silly simple method of examining every value against every other value).
java isn’t slow
I mean, whatever speed java has or doesn’t have, what the other person said was emulate, you’ll have your os then on top of that the JVM then on top of that your python implementation, then finally the python code. If that’s faster than os->python imp…
Just like Python doesn’t run from the source code through the interpreter all the time (instead, if I’m not mistaken, the interpreter pass converts the code to a binary runtime form, so interpretation of the source is done only once), so does “modern” Java (I put modern between quotes because it’s been like that for almost 20 years) convert the code in VM format to binary assembly code in the local system (the technology is called JIT, for Just-In-Time compiler).
It’s Jython and it’s like 25 years old
Still on python2 as well (Stable version )
If you need python 3 there’s also graalvm but its python support is still “experimental”.
Plus Java IS slow, quite slower than compiled languages at least
java is a compiled language
deleted by creator
If you go that detailed, then the jvm is JIT compiler, not an interpreter, so Java code still mostly runs natively on the processor. Java is quite fast achieving pretty close performance to C++, the only noticeable problems are on desktop because of the slow jvm startup and slow GUI libraries compared to native ones.
deleted by creator
There is another compilation step inside the Java Virtual Machine which “compiles” the VM Assembly code to native code at runtime.
This is what’s called JIT compilation and has been part of the standard Java Virtual Machine for about 2 decades and the default - at least server side - for almost as long (i.e. you have to explicitly pass a parameter to disable it at startup if you want the old runtime interpreted VM opcode behaviour).
Source: I used to design and develop mission critical high performance distributed server systems in Java for banks since before 2008 and it definitelly is capable of handling it (the bottleneck tended to be the TB-size database, not the Java application).
Eh…Java source code compiles into bytecode which runs in a virtual machine. Compare this to a language like C which compiles to native machine code. Java still gets interpreted.
The bytecode is turned into native code before execution
That’s not how it works. If that really was how it worked there’d be no point even having bytecode; you’d just straight up get the native code. Unless you’re talking about JIT, but your wording seems to be implying that all the bytecode turns into native code at once.
That made a python interface wrapper arround VB Script.
I don’t get it. Why I need cloud to run Python scripts which can be done locally? Installing Python isn’t hard and MS can bundle it as a library with Office either.
This sounds like a security check. Our liability and ransomware insurance both require scripts to be turned off for excel and word.
I believe security threats can be mitigated locally without resorts to cloud.
Actually, one can argue using cloud is less secure because there is a risk of sensitive data leaked out of cooperate network.
You could argue that, but I wouldn’t recommend it.
Microsoft has a massive amount of resources to throw at securing their environment, whereas most businesses simply don’t have the ability to field a dedicated security team. The solution many reach is to offload risk to your software vendor, in this case Microsoft. Then, if there is data lost, it’s Microsoft’s fault, and it’s their problem to fix, too. It’s not ideal, but it’s the world we’re living in.
Cloud doesn’t have access to local drives…but in this day and age, python could be containerized or sandboxed. Sounds messy though.
Richard Stallman on Service as a Software Substitute:
https://www.gnu.org/philosophy/who-does-that-server-really-serve.htmlNot everyone has an opportunity to work with Python in their work environment. I’m on the “business” side of the company, capable of doing most of programming stuff myself (Python, C#, SQL, etc.), whereas only “IT” people can work with the proper compileable code. And I’m left out working with VBA macros, or ask IT to write a script for me, which will take 1 year to develop. This change now will improve my local productivity for sure.
This issue isn’t about authoring the script, is about why it needs to execute on the cloud rather locally.
Fair point, maybe I replied to a wrong comment. Nonetheless, I’ve seen comments saying “just use native Python”. Not everyone can do that.
This happened in my old place - also on the business side. Asked for python, got it, then had it immediately removed because of security risks.
I told the head that I could still access tables and shit via excel if I wanted so what does it matter? He didn’t realise this, and asked that I told no-one else it could be done. FFS.
When you save your doc to one drive then you can access it from the web version of office. That’s the reason they’ve been encouraging developers to write add-ins that run from the cloud. I’m guessing that this is for similar reasons
You can also access docs by uploading it to the web version of office. Correct me if I’m wrong but last I remembered add-ins don’t choose between desktop and web.
Does anyone not think Microsoft is going to use all their cloud data for training language models?
“We promise not to” doesn’t seem realistic to me. Proving they used it is impossible.
Surprising no one. You can’t even autosave files in Office software anymore unless you use OneDrive.
unfortunately the local storage technology just isn’t there yet. we have to rely on the magic of the cloud to handle complex things like auto saving files and running python interpreters
😂😂😂
What does Lemmy think about emoji
In general I think emojis add nonverbal context clues to conversations and in my experience are a valuable tool for conveying information quickly. I’m seeing them used in all but the most formal of cases in a work environment and I don’t think that particular train is going to be stopping anytime soon.
That gives me a great idea to design emojis for corporate use. The ones that we have are unsuitable but like you said… They add a layer of communication
I think blobmoji is best
Yeh that pisses me off. When I looked that up, I saw that on the Microsoft help forums their response was ‘well, you never really had that feature locally anyway’.
This is inside-out programming. I want my code to read data files, not my data files to contain code.
The first example is how to take cells in the sheet and make a data frame in an Excel equation. That’s easy, pandas.read_excel(): no clound needed, no need to hunt through cells of a sheet to find your code.
time to mine monero on their servers
deleted by creator
Holy shit Excel is still like it was 20 years ago. And now, when they want to add such a useful feature, it comes with that bag of crap with it? Fucking hell. I know why I switched all non-trivial stuff to python.
Defining reusable functions? Diagrams with parametric ranges? (Only the title can be a cell reference, nothing else) Zooming in diagrams? More than 1 x axis? More than 2 y axis? …
So this is basically a native version of xlwings that requires exposing your excel data?
Does xlwings require any specific Python installation? Can I use it with my WinPython 3.10 installation on Windows 10?
As long as it can run Python, yes. It functions as a library just like VBA.
Removed by mod
