Live data from Hacker News

My thoughts on Python in Excel

xlwings.org

121–123 of 123 posts

Re: My thoughts on Python in Excel

#121
post #88

Earlier quoted context omitted.

> The mistake is "the grid". The spreadsheet as a way to allow IT-illiterate to do stuff on a desktop is a mistake. But why?

At a basic level because we almost never have to deal with pure tabular data without anything else. A spreadsheet was designed to deal with pure data, even without a note. Than since in the real world we need notes, titles, small bits of text etc spreadsheets devs add styling and the nightmare began, a grid to deal with data, but also formatting styles, people to manually tweak column and row width and height, add co…

So you want everyone to be a mechanic to drive a car?

Re: My thoughts on Python in Excel

#122
post #88

Earlier quoted context omitted.

At a basic level because we almost never have to deal with pure tabular data without anything else. A spreadsheet was designed to deal with pure data, even without a note. Than since in the real world we need notes, titles, small bits of text etc spreadsheets devs add styling and the nightmare began, a grid to deal with data, but also formatting styles, people to manually tweak column and row width and height, add co…

So you want everyone to be a mechanic to drive a car?

A professional mechanic certainly not, someone who know the car enough to understand why there is a strange noise from the beaks and a kind of hiss from the belt (in an ICE) yes. Not differently from why I want any adult know enough about drains, sewers to understand why not throwing pads in the WC or why I want anyone knowing enough about food to understand why we cook certain foods and we eat others raw.

It's a classic concept: the general and generic culture ANY Citizen should possess, learnt back at school. Without that we are all robots, beasts pastured by the shepherd unable to comprehend why we do something instead of something else and so unable to decide peers between peers in a Democracy. Anyone have his/her own specialization, but we must still know a bit of anything at a high level, but still enough to understand if something could be logic/true or not.

A society that work, evolve positively is formed of Citizens not meat-based robot able only to do 1/4 turn of a wrench. People who crack their windshield in the winter, defrosting it with boiling water, others left without fuel at sea in the summer and so on should not be a thing. A child is a child, an adult MUST BE an adult, a Citizen. It's about time to say "if you have to use a computer, a desktop, to work you MUST know it enough, not being just able to click around not even knowing what is a file". In the west world due to such evolution we are unable to do almost anything these days, we have lost much of our best scientific and industrial power because of such idea.

Re: My thoughts on Python in Excel

#123

Earlier quoted context omitted.

Would you mind explaining in more detail what your custom library enabled?

It's been long enough that my memories are fuzzy. I do remember defining a specific format for a cover page: merging a large block of cells and customizing the font information within. I suspect I had other formatting convenience functions to make the reports more consistent. I created a single data structure to wrap the workbook and worksheet objects and include a "current" row/cell tracker, so that I could invoke a…

Super helpful, thank you for taking the time to share this, I appreciate it.
Post reply on HN