Results 1 to 6 of 6
Related
-
Web hosting, web dev, Internet publishing, tech and affiliate domains For Sale Forum: Domain Name Sales
Replies: 1 -
security for VPS.. Forum: Web Hosting Forum
Replies: 0 -
publishing in Ipowerweb Forum: Web Hosting Forum
Replies: 2 -
Yahoo Publishing Network Forum: Affiliate Marketing and Reseller Programs
Replies: 4 -
Excel Forum: HTML Forum
Replies: 5
-
07-02-2004, 07:47 AM #1
Publishing Excel Spreadsheets/Security?
Hi all,
i need to publish an excel spreadsheet to the web and keep the functionality, validation and security/user password prompts etc intact!
This is something ive never done before. Is it possible to do all this?
Also ive heard that saving as webpage in excel creates a whole load of pointless code therefore creating HUGE files, is there a better way to go about this?
One more thing, do some hosts not allow certain file types? Ive just tried uploading a file with a .mht extension but it only displays the header and no spreadsheet?
Thanks in advance,
krak_d.Last edited by krak_d; 07-02-2004 at 08:35 AM. Reason: incomplete
-
07-03-2004, 08:52 AM #2
Hi krak_d,
You can just dump an .xls on the web, and should download from any browser, or open in Internet Explorer. However, its not at all secure (Even with the password protection, trust me, I had to 'crack' an .xls in work and it was not hard)
Depending on your priorities, you may want to look into adapting it slightly. For example, if the data is whats important, then ASP can read the .xls file as a data source, and you could of course then password off that page.
Or if the download is important, zip it up and password the download.If one of our members helps you, please click theicon to add to their reputation!
No support via email or private message - use the forums!
Before you ask, have you Searched?
-
07-03-2004, 09:43 AM #3
Thanks Dean.
The spreadsheet holds information relating to a few thousand box files held by a secure storage company that deal regularly with solicitors etc. so i imagine security is a very big issue. What i've been told so far is that the storage company want there spreadsheet to be available and searchable online so people can call them up and ask them to pull that particular boxfile and courier it to them. A little vague i know but i'm meeting with them next week to clarify exactly what thay want and more to the point if i can do it!
By the sounds of it ASP is going to be the way to go ...unfortunately i know nothing of it, in fact i don't think my OS supports it (M$ ME)
I thought about just ftp'ing the excel sheet(s) but i don't know how often they will need to be updated or if the clients searching the spreadsheets will want to have to download it to do there search!
...Look like i may have to get a 3rd party in to do this one properly, i 'll keep you posted!
krak_d
-
07-03-2004, 10:31 AM #4
Personally, I would transfer the whole thing from a spreadsheet to a secure database.
You can save the spreadsheet as a .csv and improt into a database easily enough.
Is your webserver ME? my god. Thats scary.If one of our members helps you, please click theicon to add to their reputation!
No support via email or private message - use the forums!
Before you ask, have you Searched?
-
07-03-2004, 11:29 AM #5
I'm venturing into unknown territory!
You can save the spreadsheet as a .csv and improt into a database easily enough.
krak_d
-
07-03-2004, 01:46 PM #6
Heres one in PHP for mySQL
http://codewalkers.com/seecode/448.htmlIf one of our members helps you, please click theicon to add to their reputation!
No support via email or private message - use the forums!
Before you ask, have you Searched?
[Hostripples India] - Best Canada Linux SSD VPS Server!
02-15-2019, 12:46 AM in Web Hosting Forum