513
HTML with Excel
(lemmy.world)
My sister started a new position that involves HTML. She tried to explain an issue to me, but I'm not a web guy. I told her to send it to me on Monday and she sent this...
Now I want to know what the issue was.
And the “solution”.
I have used Excel to make tags from a table before. Usually just for one off stuff and before I was very familiar with JavaScript.
E.g. if you have a table of 100 urls you could use excel to easily turn them into
atags using the various text formulas like concat.It's probably never the best tool for the job but sometimes I'll do stuff in Excel just because I'm very familiar with it.
To clarify I am not a programmer by trade lol
I saw a meme somewhere along the line that Excel is the third best tool for every job.
You know how people say "Devil you know is better than God you don't"?
Excel is that Devil people know. It's not the best tool for a lot of stuffs but it let's people do things.
I saw a co-worker generate sequence for formula in excel for another cell in excel. They wanted to do average of all January data, instead of averageif/sumif/countif etc, they generated a sequence a1+a13+a25...... And used excels' drag down thing to make the formula. I'm like who could even verify it.
Oh for sure
FWIW many modern text editors just let you modify multiple lines at once.
I like Sublime Text for this.
Watching supposedly technical people use Excel to mangle batch SQL statements together makes me cry.