Um exemplo mínimo de como usar #Python para ler dados de uma planilha #Excel com a biblioteca #openpyxl e como modificar um arquivo #Word com a biblioteca #docx

https://gist.github.com/villares/560e231da78cd1b8f5701c5a6897348f

Seeking #recommendations for #alternatives to #Microsoft #Excel. Ideally #FOSS but not a hard requirement. I tried #LibreOffice #Calc and #CryptPad but found their capabilities lacking. E.g., I need something comparable to Excel's tables that allows me to refer to table and column names in my formulas instead of just cell locations. It looks like #SoftMaker can, but they also integrate #ChatGPT, and I'd like to avoid my money helping destroy the #environment and oppress the #GlobalSouth.

Ich habe gerade über den gem. Verein der Kinder eine Lehrerkollegin kennen gelernt. Informatik, Administratorin, sympathisch. Hessen, berufliches Gymnasium.

- sie verbindet gerade etliche private Schüler #iPads mit dem schulischen MDM und Classroom.

- alle Schüler melden sich an den Schul-PCs mit ihrem #Microsoft-Konto an.

- es gibt ein verpflichtendes #MS365 mit OneNote Kursbüchern.

- Nein, natürlich habe sie die AGB nicht gelesen. Und auch keine Vorgaben / Einschränkungen des Bildungsministeriums. Es sei ja doch erlaubt.

- ja, das sei ja schon "etwas bedenklich", aber es sei ja ein Schulbeschluss und ihr Chef habe das "von oben" für alle verpflichtend so angeordnet. Dafür sei es ja auch praktisch, einheitlich und Standard. Und #Word, #Excel, #Powerpoint stehe schließlich im Lehrplan.

"Mit Produktname und Herstellervorgabe?"

Nein, so direkt ja nicht. Aber was denn sonst?

Ich erzähle nur von meiner nicht vorhandenen freiwilligen Einwilligung.

Jetzt sitzt sie wo anders.

Open science this, open data that. And than you get a ton of .xlsx files

Tired of Excel’s limitations? Learn how Python can help you automate reports, build dashboards, and create clear visuals—no prior coding experience needed. If you know spreadsheets, you're ready to go.

Pre-order now and get 30% off with code BEYONDEXCEL for the pre-order sale! (6/23–6/29)

https://nostarch.com/python-excel

I hate #Microsoft with a white-hot intensity.

I have to use #Office365 for work. I created a spreadsheet that is not needed - someone else had created a better version. I want to delete it.

There is no option of any kind at all to delete the file from inside the #Excel 365 view.

If you go out to #OneDrive, it first shows you its Home view with recent files. All you can do from there is share, copy or open the file again.

If you go into the OneDrive My Files view and navigate to find the file, you can select the checkcircle (not a checkbox lest it prompts an interaction, and only visible when you hover in the right place) beside the file, and finally Delete appears in the inconspicous ribbon at the top or in the More Actions menu that appears if you hover in just the right place to get three dots and then click on them.

After all that, even with all open tabs closed, it refuses for at least five minutes to delete the file because it tells me it is locked.

After an indecent timeout of something somewhere, on my fifth attempt, it finally lets me delete the file.

They REALLY want to hang on to every possible bit of data so they can learn from it. And I guess so that people have to expand the storage for their OneDrive accounts to retain old shopping lists and the like.

I've been in IT long enough that I still think of disc and memory as things that needs to be managed and conserved.

Wishing them every success - but it won’t necessarily be easy: From #Word and #Excel to #LibreOffice: #Danish ministry says goodbye to #Microsoft https://www.heise.de/en/news/From-Word-and-Excel-to-LibreOffice-Danish-ministry-says-goodbye-to-Microsoft-10438942.html

You know that your data is garbage when you find yourself clicking through excel trendlines and functions at random #Data #Excel #Research

The #European #Spreadsheet #Productivity and #Risk Interest Group (eusprig.org) are pleased to announce that streaming tickets are now available for the EuSpRIG 2025 Annual Conference.

This year’s conference will be held on Thursday 3rd and Friday 4th July 2025 at the University of Greenwich, London.
To view the full programme and book your in-person or streaming place, visit:
https://www.eventbrite.co.uk/e/eusprig-2025-annual-conference-spreadsheet-productivity-and-risks-tickets-1219511143659?aff=mastdodon

Please share this announcement with colleagues and professional networks. @EuSpRIG
#Excel

Throwback Saturday

Here's a shot from the 2023 #London #Triathlon I found looking for a #shadows shot. I was looking down from a footbridge close to the #ExCel centre in the Royal Docks.

R FOR DATA SCIENCE

Looking to take your #Rskills to the next level as a #UniversityofCopenhagen #researcher, employee, or #PhD student? We've got the #course for you!

R for Data Science
16-18 June 2025
Panum, University of Copenhagen

Register here as an employee: https://lnkd.in/dyQx6K63
Register here for ECTS credits as a PhD student: https://lnkd.in/da47HJ3f

#excel #rstudio #r #datascience #data #phd #research #datascience #UCPH

European Spreadsheet Risk Annual Conference Programme announced
Thursday 3rd and Friday 4th July 2025
University of Greenwich, London, UK

https://eusprig.org/conferences/eusprig-annual-conference/

Spreadsheet Entertainment
AI and LLMs
Excel languages
Research into human-computer interaction
Horror Stories

Register on https://eusprig2025.eventbrite.co.uk/

@EuSpRIG #eusprig #conference #London #HCI #research #AI #LLMs #Excel #TDD #Spreadsheet #Risk

After mostly de-googlefying earlier this year, I've now taken a leaf out of @CiaraNi's book and started de-microsofting too.

Notepad++ is a no brainer and I've downloaded @libreoffice too.

Started going through my personal documents and changing the format from Office to Open Document Format.

Ah - the thrill and satisfaction of removing big tech...

Spending hours manually updating your Excel dashboards and reports? Copying, pasting, reformatting... It's tedious, time-consuming, and leaves room for error. What if your key visuals updated automatically when the source data changes?

Excel has a powerful, often overlooked feature perfect for this: the Camera Tool!

It lets you create dynamic, linked visuals from different sheets onto one central summary page. https://youtu.be/25zHZOeBxyY
#ExcelTips #Excel #DataVisualisation #Productivity

Looking through my forgotten corner of my shed I found a gem. I was hoping to finally install some clean Excel without the bloatware, but I think I misplaced my floppy drive 25 years ago . And I have a sneaking suspicion that I would not be able to read anyhting from 30 year old floppies. #Excel #retrocomputing