Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Aug 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation help generating a list of html links from a excel file...

    I have an excel file with 2,500 titles and 2,500 associated urls... does anyone know a simple way to generate a html page which combines the titles with their associated hyperlink?

    Are there any simple programs that can import table data and export html of hyperlinked text?

    - thanks

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    The Netherlands, Baarn, Ut.
    Posts
    4,252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weave a dream...

    Excel has the option of saving a spreadsheet as HTML, but the amount of garbage poured into the end result is staggering and could take ages to clean up.

    When Googling for "clean up excel web page" I hit this page: "Cleaning up Microsoft ... Excel code"; at the bottom of the page and partially in the right side bar the fastest, easiest way is explained. Downside is, you'll need DreamWeaver for it.
    I can imagine some text manipulation tool could achieve something similar, but I'm unfamiliar with such stuff.
    Regards,
    Ronald.
    ronaldvanderwijden.com

  • #3
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    You could possibly use some type of server side language. I know CSV files are a common flat file for server side languages. Perl supposedly has a builtin function that can convert xls files to an sql. PHP can read a CSV (Comma Seperated Values) file quite easily though not sure how to generate links from it.
    Last edited by _Aerospace_Eng_; 08-26-2005 at 10:03 AM.
    ||||If you are getting paid to do a job, don't ask for help on it!||||

  • #4
    New to the CF scene
    Join Date
    Aug 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I seem to end up doing a fair amount of this kind of work, and the easiest way I've found is to first save the Excel file as comma or tab delimted and then use a text editor with decent find and replace capabilities to do the work.

    So, for instance, the first search might be to find all occurences of a new line and replace it with a new line character followed by a <p>, then the next one might be to find all tabs (or commas) and replace them with </p><p>, etc etc.

    If you get into regular expression searching (GREP) then with a little practise these kinds of tasks can be made quite easy (if still tedious

    I'm on a Mac and so I use BBedit (which has the ability to create complex find and replace patterns and then run them sequentially), but I'm sure there are similar programs for Windows.

    Good luck!

  • #5
    Senior Coder
    Join Date
    Oct 2003
    Location
    Australia
    Posts
    1,963
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question From what to what?

    When asking for this sort of advice, you need to post a sample (single row) of your data and a sample of the result you're after...
    Last edited by mindlessLemming; 08-26-2005 at 01:45 PM.

    I take no responsibility for the above nonsense.


    Left Justified

  • #6
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts
    Have you got access to a server.
    Does your host support perl.
    Do you know anything about perl?

    If there were 3 'yes' answers, then the solution is quite straightforward. Even if your unsure of perl, if the first two answers were yes, then, you could let me know or, ask in the perl forum.

    In the end, you could be able to add or delete records in your excel file through your browser and automatically, generate a web page for each record- if that sounds better.

    Bazz
    "The day you stop learning is the day you become obsolete"! - my late Dad.

    Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
    Useful MySQL resource
    Useful MySQL link


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •