User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » Excel to Web Application Page [1]  
Drovkin
All American
8438 Posts
user info
edit post

How exactly would you do this?

I have some basic coding background (C++, HTML, CSS, a little java) and was wondering what would be the best way for taking a workbook that has several macros and converting it into a web application?

We have a quoting tool at my work that is currently just an excel file that is emailed around as it's updated, but it's getting to be too complicated to keep wraps on it. I'd like to build a web app for internal use that would use all of the same features.

7/6/2016 3:36:05 PM

synapse
play so hard
60908 Posts
user info
edit post

Step 1: Procure a bunch of servers
Step 2: Install a Sharepoint Farm
Step 3: Upload that .xlsx to Sharepoint
Step 4: Pay yourself on the back

7/6/2016 3:46:32 PM

moron
All American
33692 Posts
user info
edit post

Isn't this what Office 360 basically is? Or convert it to a Google Doc?

7/6/2016 3:46:35 PM

FroshKiller
All American
51873 Posts
user info
edit post

If you have Office 365, you ought to look into this:

https://support.office.com/en-us/article/Embed-your-Excel-workbook-on-your-web-page-or-blog-from-SharePoint-or-OneDrive-for-Business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773

7/6/2016 3:47:48 PM

Talage
All American
5080 Posts
user info
edit post

I get the impression from the OP that he wants to trash the spreadsheet entirely but maybe not.

Are we talking about something where they just fill in a bunch of fields and one of the pages in the workbook spits out some numbers that the macros computed?
If it is as simple as that I'd just make it an HTML form with a little javascript in the background for whatever computations you need.

If you do end up making this, be prepared for push-back from people who have been using their precious spreadsheet for the last 15 years and don't trust any new fangled ways of doing things .

7/7/2016 5:21:29 PM

dtownral
Suspended
26632 Posts
user info
edit post

I don't think Office 365 can do macros through the browser interface anyways

7/8/2016 7:53:13 AM

moron
All American
33692 Posts
user info
edit post

^^ yeah, he'll probably want to use a database (but could just use a file-- although this is not recommended) and have the form push the data to the database.

Then write the magical code to parse the data from the DB and do the calculations and stuff.

It's a good project actually, because it will give OP a chance to learn something new, and even if they don't end up using the form, he'll get some kudos. If they DO end up using the form, he just helped automate someone out of a job or pay raise and maybe earned a raise for himself.

[Edited on July 8, 2016 at 12:15 PM. Reason : ]

7/8/2016 12:15:02 PM

Novicane
All American
15408 Posts
user info
edit post

if your company has sharepoint , look into Nintex forms. Try to get your sharepoint admin to load it for you.

You can have a sharepoint access DB driven back end powered by a form driven front end pretty efficiently. I believe the form can perform simple math functions for you.

7/13/2016 4:39:44 AM

 Message Boards » Tech Talk » Excel to Web Application Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.38 - our disclaimer.