: Turning linked Excel files into a website My client has asked me to look into something, and ive got white noise in my head now!! They have created several Excel workbooks which contain a
My client has asked me to look into something, and ive got white noise in my head now!!
They have created several Excel workbooks which contain a massive amount of data (eg lists of documents, lists of accidents etc) a lot of which them link to other workbooks, worksheets and websites. Along with a menu page, sub menu pages and other bits. There are probably 30+ worksheets, and nearly all of them are completely different in layout and function.
Oh and that's for one site! so duplicate this 8x to cover the country.
OK so this is basically tabular data with hyperlinks... sort of.
Because this has become so big and clunky they now want to somehow "port" it to a website (I work in ASP.net, and they have in-house servers), and worse still they want to continue to use the old excel system whilst this is being developed, and "sync" the data when it goes live.
I'm at a loss as to if this can even be achieved...
More posts by @Merenda212
2 Comments
Sorted by latest first Latest Oldest Best
I don't like answering my own questions but in this case I feel I have to.
The only feasible way to do this without attempting to completely rewrite excel in html & javascript is to use:
Microsoft Sharepoint Excel Services.
en.wikipedia.org/wiki/Excel_Services
It can be achieved, I've seen something like it at work (with interactive maps even), but do warn them that it's tedious, that they'll have to re-upload the whole files with every new update and that the smallest mistake can break the whole site. You may also consider warning them to expect it to cost more, both upfront AND with every bit of functionality added later.
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.