70 users online (0 members and 70 guests)  


  Results 1 to 6 of 6

Related

  1. Replies: 1
  2. security for VPS..    Forum: Web Hosting Forum
    Replies: 0
  3. publishing in Ipowerweb    Forum: Web Hosting Forum
    Replies: 2
  4. Yahoo Publishing Network    Forum: Affiliate Marketing and Reseller Programs
    Replies: 4
  5. Excel    Forum: HTML Forum
    Replies: 5
  1. #1
    krak_d's Avatar
    Senior Member

    Status
    Offline
    Join Date
    Mar 2004
    Location
    Liverpool
    Posts
    166

    Question 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

  2. #2
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    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 the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  3. #3
    krak_d's Avatar
    Senior Member

    Status
    Offline
    Join Date
    Mar 2004
    Location
    Liverpool
    Posts
    166
    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

  4. #4
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    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 the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  5. #5
    krak_d's Avatar
    Senior Member

    Status
    Offline
    Join Date
    Mar 2004
    Location
    Liverpool
    Posts
    166
    I'm venturing into unknown territory!

    You can save the spreadsheet as a .csv and improt into a database easily enough.
    Can you recommend any links/tutorials etc on this ?

    krak_d

  6. #6
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662
    Heres one in PHP for mySQL

    http://codewalkers.com/seecode/448.html
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?