INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Excel spreadsheet data into a web page including links

Excel spreadsheet data into a web page including links

(OP)
Hello

Firstly if this is the wrong forum, I apologise, but I'm not quite sure where my query belongs.

I'm doing some work for a family history society, and they have an index of Wills - basically name, year, references and if there is one, a link to the Will transcript.

Currently they are PHP files as these are only available to the members of the society. Their index is sitting in Excel in a number of worksheets, there are thousands of entries. What I'd like to do is to be able to have those spreadsheets displayed within the web page rather than having to copy/paste the information to the PHP page (there's one for each letter of the alphabet). The index changes regularly as updates are made, so I need to be able to update quickly and easily.

I tried saving my Excel workbook as an MHT file and while it displayed fine in Microsoft Edge (just the file not within the webpage) it doesn't in Chrome. I've tried a PDF, but the links to the transcripts don't work - and as there are some 8000 links doing it manually in Acrobat isn't an option.

Can someone advise the best thing to do?

Many thanks

thank you for helping

____________
Pendle

RE: Excel spreadsheet data into a web page including links

Export the workbook/worksheets to MySQL then write a PHP CMS around the data would be my choice.

Not particularly ideal but given that Excel isn't anything like a 'real' database it has to be a compromise.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.

Never mind this jesus character, stars had to die for me to live.

RE: Excel spreadsheet data into a web page including links

I agree with Chris.

Export the excel files to csv, and feed them into a MYSQL database, then you can have PHP automatically read them from there easily.

Any updates to the database would be immediately visible in the website.


You can post in the forum436: MySQL, or forum434: PHP for specifics.

----------------------------------
Phil AKA Vacunita
----------------------------------
OS-ception: Running Linux on a Virtual Machine in Windows which itself is running in a Virtual Machine on Mac OSx.

Web & Tech

RE: Excel spreadsheet data into a web page including links

(OP)
Thanks both, I'll give those ideas a try.

thank you for helping

____________
Pendle

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close