/    Sign up×
Community /Pin to ProfileBookmark

Excel To A Webpage

I have an excel file we use for keeping track of technicians and they want to use it for more than one location, which means it needs to goto a webpage and hosted for multiple users. What would be the best way to do this?[upl-image-preview url=https://www.webdeveloper.com/forum/assets/files/2019-01-21/1548081005-182368-clock-inout.jpeg]

to post a comment
HTMLJavaScript

10 Comments(s)

Copy linkTweet thisAlerts:
@NogDogJan 21.2019 — You could simply get a Google G Suite business account, and you're basically good to go, outside of setting up user accounts. https://gsuite.google.com/pricing.html
Copy linkTweet thisAlerts:
@KevinRoachauthorJan 21.2019 — Problem I see with that is the problem I have now, not more than one person can use it at the same time.
Copy linkTweet thisAlerts:
@NogDogJan 21.2019 — @KevinRoach#1600244

Google Sheets and other Google Docs allow you to provide different levels of access (from read-only to full editing access) to other users. But if that does not work for you and you want a more custom solution, I'd personally probably take a database-driven approach -- initially populated by saving the spreadsheet as a CSV and then loading that into the DB. You may be able to find some ready-made solutions, perhaps as a feature/plug-in for a CMS, or a stand-alone web app. It all depends on how much customization you want/need, your ability to write/adapt the code on both the server and client sides, etc. First thing a quick google search I tried found: https://wordpress.org/plugins/tags/spreadsheet/
Copy linkTweet thisAlerts:
@KevinRoachauthorJan 22.2019 — Why a database? I am not tracking or permanently storing anything.
Copy linkTweet thisAlerts:
@cootheadJan 22.2019 — Hi there KevinRoach,

can you supply a link to the _Excel_ file

so that we can experiment with it?

_coothead_
Copy linkTweet thisAlerts:
@KevinRoachauthorJan 22.2019 — I don't have a link and it wont let me attach the file.
Copy linkTweet thisAlerts:
@cootheadJan 22.2019 — Hi there KevinRoach,

why can' t you upload it to your webpage

which is hosted for multiple users ? ?

_coothead_
Copy linkTweet thisAlerts:
@NogDogJan 22.2019 — @KevinRoach#1600286
Why a database? I am not tracking or permanently storing anything.[/quote]

Perhaps I'm misunderstanding, then. I was thinking you wanted multiple users to be able to edit it, which means the data needs to persist somewhere on the server. Whether that's in a DB or a file...*shrug*.
Copy linkTweet thisAlerts:
@KevinRoachauthorJan 23.2019 — Just needs to be a visual change with the drop dons that's it and for multiple people to use on the list. It's just for our secretaries to know where the technicians are.

The Excel file I have showing uses ActiveX controls for the drop down and VBA code for the color changes.
Copy linkTweet thisAlerts:
@esperance20009Feb 12.2019 — Parquet floors are usually long lasting and require little or no maintenance.[2] Unstuck blocks are re-glued. Bitumen-glued blocks require use of either hot bitumen or a cold bitumen emulsion, as other glue types do not adhere to bitumen.

https://ageshop.ir/product-category/parquet/
×

Success!

Help @KevinRoach spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 4.20,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...