4 ms·

Excel has get and transform that makes this easy + an odbc provider (you can query excel as an sql database). A reminder for everyone excel web is actually ent

by inglor 4y ago

Excel has get and transform that makes this easy + an odbc provider (you can query excel as an sql database). A reminder for everyone excel web is actually entirely free and you can create stuff with https://excel.new https://excel.new We spent a lot of time making it faster and rewrote a bunch of it ^^ (I'm just an engineer, I don't speak for my corporate overlords)

KRAKRISMOTT 4y ago
How's Excel web's feature parity?
capableweb 4y ago
excel.new has a "weird" TLD, no mention of Microsoft in the domain and asks me to auth with my Microsoft account before I can even see the site. If I came across this in the wild, I'd for sure think this is some phishing or generally bad website.
- switch007 4y ago
  Agreed. That’s bad even for Microsoft. What is wrong with excel.office.com with a version toggle?
  - arjvik 4y ago
    excel.new is a shortcut to creating a new spreadsheet, not a brand new version of Excel
    - switch007 4y ago
      excel.office.com/new then
- cldellow 4y ago
  Those are all valid points, of course, and you can navigate to excel.office.com if you don't trust the OP (although it will also immediately redirect you to an auth window) The .new TLD is pretty nifty. sheets.new gets you the same thing as excel.new, but for Google.
  - capableweb 4y ago
    At least excel.office.com is on the official office.com domain, easy to verify. Using X.new seems like a bad idea, there is no way for me to understand if it's actually a official project by the companies themselves or just a random developer who has set that up. Maybe one day it'll ask someone for auth, they don't notice it's at microsoftweb.com instead of microsoftonline.com and get phished. Really hard to trust random domains when a simple excel.office.com/new would do just as fine.
gigel82 4y ago
That link took me through 6 redirects, at least 2 rendered flashes of various colors in the browser. I love Excel, BTW :) just wanted to let you know in case you want to make it even faster (and easier to onboard presumably based on the domain).
nhatcher 4y ago
Hi inglor! As someone who has been writing spreadsheets engines for the last 10+ years I am a big fan of how Excel has taken the lead in innovation in the last couple of years with dynamic formulas and the LAMBDA. So congratulations on your part of it! BTW, I must have been interesting to find an algorithm that can evaluate the new dynamic formulas. I would like to see one day more public information on spreadsheet evaluation algorithms. As the people from sourcetable[1] put it: > Spreadsheets are one of the hardest things you can build — right up there with compilers. I think I would like to see a "democratization" of the technology and find books, and lectures about it as popular as we find books and lectures about compilers. As for the OP I find their take interesting, of course you can accomplish that with more established tools but it was a refreshing read and an interesting, if not inspiring, notation. PS: Is it possible that there is a regression when computing sheets with lots of open ranges (like =SUM(D:D)) [1]: https://www.sourcetable.com/jobs https://www.sourcetable.com/jobs

by inglor 4y ago

KRAKRISMOTT 4y ago

How's Excel web's feature parity?

capableweb 4y ago

excel.new has a "weird" TLD, no mention of Microsoft in the domain and asks me to auth with my Microsoft account before I can even see the site. If I came across this in the wild, I'd for sure think this is some phishing or generally bad website.

switch007 4y ago
Agreed. That’s bad even for Microsoft. What is wrong with excel.office.com with a version toggle?
- arjvik 4y ago
  excel.new is a shortcut to creating a new spreadsheet, not a brand new version of Excel
  - switch007 4y ago
    excel.office.com/new then
cldellow 4y ago
Those are all valid points, of course, and you can navigate to excel.office.com if you don't trust the OP (although it will also immediately redirect you to an auth window) The .new TLD is pretty nifty. sheets.new gets you the same thing as excel.new, but for Google.
- capableweb 4y ago
  At least excel.office.com is on the official office.com domain, easy to verify. Using X.new seems like a bad idea, there is no way for me to understand if it's actually a official project by the companies themselves or just a random developer who has set that up. Maybe one day it'll ask someone for auth, they don't notice it's at microsoftweb.com instead of microsoftonline.com and get phished. Really hard to trust random domains when a simple excel.office.com/new would do just as fine.

gigel82 4y ago

That link took me through 6 redirects, at least 2 rendered flashes of various colors in the browser. I love Excel, BTW :) just wanted to let you know in case you want to make it even faster (and easier to onboard presumably based on the domain).

nhatcher 4y ago

Hi inglor! As someone who has been writing spreadsheets engines for the last 10+ years I am a big fan of how Excel has taken the lead in innovation in the last couple of years with dynamic formulas and the LAMBDA. So congratulations on your part of it! BTW, I must have been interesting to find an algorithm that can evaluate the new dynamic formulas. I would like to see one day more public information on spreadsheet evaluation algorithms. As the people from sourcetable[1] put it: > Spreadsheets are one of the hardest things you can build — right up there with compilers. I think I would like to see a "democratization" of the technology and find books, and lectures about it as popular as we find books and lectures about compilers. As for the OP I find their take interesting, of course you can accomplish that with more established tools but it was a refreshing read and an interesting, if not inspiring, notation. PS: Is it possible that there is a regression when computing sheets with lots of open ranges (like =SUM(D:D)) [1]: https://www.sourcetable.com/jobs https://www.sourcetable.com/jobs