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…

  • snowsuit2654@lemmy.blahaj.zoneEnglish
    13·
    4 months ago

    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 a tags 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

      • Blackmist@feddit.ukEnglish
        3·
        4 months ago

        I like Sublime Text for this.

        Watching supposedly technical people use Excel to mangle batch SQL statements together makes me cry.

      • thevoidzero@lemmy.world
        2·
        4 months ago

        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.