It would be awesome and a lot more helpful to use excel in glide
Why? What you can do in Excel that you can’t in sheets?
Excel has more built in functions and formulas @yinon_raviv
@yinon_raviv ssheets is only better than excel in collaboration
I’m a heavy user if sheets and teach both Excel and sheet and thus far didn’t encounter something I needed for glide that exist in Excel but can’t do it in sheets
@yinon_raviv if you havent seen any maybe you might be using sheets a lot compared to excel
Because i originally use excel
and also @yinon_raviv
As data in sheets increases it begins to slow down
Excel has higher holding capacity e.t.c
On this I agree with you but for glide limitations it holds well
I would always prefer Sheets for collaboration purposes, plus ARRAYFORMULA and QUERY.
I agree with you for tha t but excel is still better
Can you elaborate functions that Excel has but Sheets doesn’t?
How does Excel work with adding Python scripts, and also with Zapier?
Actually i am not much of a formula wizzard i hardly use them
In formulas and functions sheets and excel have the same
I would be crazy to use development resource to support Excel and then have to maintain two source applications going forward. There are plenty of other “must do” fixes and enhancements that we are waiting for.
Every single formula let our apps slowly and getting out users angry.
I only recommend to use formulas in gsheets if you REALLY NEED IT. Only…
In other cases, DataEditor is our best place to learn and build our apps base
I can… easy!
Microsoft Windows is still the king on desktop world and MS Office with Excel is one of reasons. Any hardware company that wants to make money must have connectivity on Windows and its software market.
What can I do using Excel but not with GS?:
Connectivity with many many systems vía ODBC/OLEDB to read/write data to databases. E.g., ODBC is a standard with more than 25 years working and its performance and background are still a legend, not a legacy!.
I still remember when I saw the JDBC term at 1st time created by Sun… wtf? … couldn’t Sun think about another term to make a different with Microsoft?
And all this is free and you can use it withit Excel very easy.
MS Excel has Visual Basic for Application (VBA) and this is a monster able to create and connect to most external software/hardware.
Many of you have used GS Macros and its “Record Macro” tool right?.. come on, you need to be honest…where did you see and use it at 1st time? … in MS Excel and it has been there since 1993-94 if my memory doesn’t fail me yet!
From Excel I can read/write real-time data from software and devices using DDE, OLE or OPC (these are standards created or used by numerous automation hardware/software suppliers for Process Control and Industrial Automation) and monitor my house or industry if I wish. Even, I could make my own HMI (Human Machine Interface) in Excel in order to start/stop a pump, light bulb or motor.
Try to do it in GS is still a nightmare because is another word, another concept and have other needs. Use Zapier here? no way, it’s a joke!
This video is an attempt of what I have wanted to do with GS from long ago and then use Glide as frontend to help users to control their homes/shops but so far, there is no an efficient and simple workaround:
What can I do using GS but not with Excel?:
GS is open and works 24x7 on internet, it is always alive and making calculations and queries. MS Excel can do it too (on Windows world) but if you close the file, the magic will disappear!
GS has many Add-On free and useful, you don’t have to wait for Google to have a new improvement/feature in your spreadsheet.
Functions like ArrayFormula(), Query(), ImportRange(), ImportHTML(), etc, are things very useful and valuable. Excel doesn’t have this kind of things although has other very powerful.
Saludos @ThinhDinh, te cuidas.
Thanks for the detailed explanation Gustavo
Regarding the points about connecting to databases, I don’t have much experience with it as I have only worked with small to moderate size databases until now, but Google Sheets also comes with a way to connect and read/write to databases using Scripts, albeit with a few drawbacks as Ben Collins has detailed here. I think the best way to handle this is a combination of Python & Google Sheets.
VBA is excellent and yes it comes first but now we can record Macros in Sheets as well. Point still stands about Sheets can do the same thing.
About the HMI, admittedly I have no experience with it and at first sight I think it’s gonna be hard to do it in GS, so agree about that.
Well, if we are using no-code or low-code solutions, try to read a database via scripts doesn’t seem very logical although I understand the case.
I know programing and have used many programming languages (even Cobol… a dinosaur) but if I can avoid it, I’m going to do it. I’d rather software where I only have to configure settings instead of programming or create code but I know how the real world is and sometimes we need to use the plan B without pain/mercy: script!
In Excel I can use a wizard tool to read and retrieve data from many external sources (DB) without any script or even better, put an ActiveX control and let it do the job but (and I’m not going to lie) sometimes we need to create some VBA code for special cases.
At the end, both solutions are fine and powerful and we just need to know where and when to use them.