this post was submitted on 23 Aug 2023
526 points (97.0% liked)

Technology

59672 readers
4136 users here now

This is a most excellent place for technology news and articles.

Our Rules

  1. Follow the lemmy.world rules.
  2. Only tech related content.
  3. Be excellent to each another!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, to ask if your bot can be added please contact us.
  9. Check for duplicates before posting, duplicates may be removed

Approved Bots

founded 1 year ago
MODERATORS
L3s
[email protected]
[email protected]
L4s
enu
526
Microsoft announces Python formulas in Excel... which have to get sent to the cloud (techcommunity.microsoft.com)
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/technology
97 comments fedilink hide all child comments
 

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 off~~the~~line

you are viewing a single comment's thread
view the rest of the comments
[–] Kethal 49 points 1 year ago* (last edited 1 year ago)

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.