View Single Post
id10t id10t is online now
Registered
 
id10t's Avatar
 
Join Date: Mar 2003
Posts: 10,443
Quote:
Originally Posted by Paul T View Post
May work for some, but if you have very complex spreadsheets with a ton of VBA, API’s and multiple add-in’s, it most likely will not work. The more complex you get, the more you are stuck with Excel. I can’t even run my stuff in Excel for Mac (which SUCKS), has to be windows version.
As a coder type, I'd be looking at exporting raw data to csv and importing to a real DB then working off either all SQL or a combo of SQL and some language like Java or PHP depending on what exactly you are doing( ie if doing stats I'd go towards PHP and the R libraries, which Java doesn't have).
__________________
“IN MY EXPERIENCE, SUSAN, WITHIN THEIR HEADS TOO MANY HUMANS SPEND A LOT OF TIME IN THE MIDDLE OF WARS THAT HAPPENED CENTURIES AGO.”
Old 10-29-2023, 09:43 AM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #16 (permalink)