Local drive portal page

[SAS]

Been scratching my head over this for a few days.

The companies local drive is a mess with 101 folders and files no one can find. I've created an information portal page out of html but stuck on two things:

1) Is it possible to link to a cell with in an excel document via html in someway? (i.e. I can show the average speed of the shift on the information portal dynamically?)

2) How easy would it be to add a small section to allow shift managers to leave messages on the portal without having to edit any raw html? Is there some javascript to allow editing in a similar way to posting on here where if you past a link a box appears asking you to enter the information and then submitting it?

 

[Shovel]

2) How easy would it be to add a small section to allow shift managers to leave messages on the portal without having to edit any raw html? Is there some javascript to allow editing in a similar way to posting on here where if you past a link a box appears asking you to enter the information and then submitting it?

You can't do this with JavaScript. JS is a client side technology, and changing the content of pages (such as appending comments) requires a server side activity.

There are lots of content management systems out there for a variety of server-side technologies. You might find that a simple Blogging too like Wordpress will do what you want (and can be simplified further with template editing).

1) Is it possible to link to a cell with in an excel document via html in someway? (i.e. I can show the average speed of the shift on the information portal dynamically?)

No. Not with raw HTML. You're talking about taking a value from an Excel worksheet and including it in an HTML output yes?

The only way I know of to do this works like this (I've never done it, so exact details are sketchy).

Your Portal page would need to be an ASP.NET Web Application. When using .NET you can make use of a .NET namespace from Microsoft that can manipulate MS Office documents, such as Excel worksheets and I believe you can use that to read the data and then output into your HTML template.

That, however, is really fucking complicated I'm afraid. And doesn't even get into the complexity of working with ASP.NET itself.