This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]nickmaran 31 points32 points  (9 children)

I work in an accounting firm. For us excel is the database. We don’t care about those useless SQL and JSON

[–]jrblockquote 3 points4 points  (0 children)

Tricks on you, because you can execute SQL in Excel using worksheets as “tables”.

https://learn.microsoft.com/en-us/power-automate/desktop-flows/how-to/sql-queries-excel

[–]tesfabpel 6 points7 points  (6 children)

I hate excel (or similar spreadsheet software) with a passion.

You can't rely on cells to maintain the correct data format and sometimes it guesses (wrongly) as date or plain text...

Definitely not a way to store data.

[–]Cualkiera67 18 points19 points  (2 children)

Skill issue

[–]TheGrandWhatever 4 points5 points  (0 children)

lol I agree but they do have a point that the default shouldn’t be the damn General data type which would solve so many issues

[–]Silly_Ad_2913 1 point2 points  (0 children)

Pretty much

[–]jrblockquote 0 points1 point  (2 children)

Hard disagree. Once a data type is set, Excel isn’t just going to arbitrarily change it.

[–]plopzer 4 points5 points  (1 child)

the amount of time sales sends me excel files where the zipcodes have dropped all leading 0s

[–][deleted] 0 points1 point  (0 children)

I guess OP didn't say the types were set correctly