[Pro] Excel to web page

Freeway
1

I have an excel spread sheet and would like to put it online.

It needs to maintain the same sorting / filtering functions. How do I do this?

Thanks

Tony

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

2

Tablekit can do some of this, and if you have the server-side chops,
you can even do editing inline, like a real spreadsheet. The sorting
business is very simple.

http://www.millstream.com.au/view/code/tablekit/

The way it works is to take a regular table of data and extend it
unobtrusively by adding one or more classes to it. For a fully
editable table, you would use the Item / Extend dialog to add these
classes to the table: class="editable sortable listtable".

The editing part has to be backed up on the server by a script which
can accept a POST from the page, interpret which row you are editing,
and update the database with the new value. But if you examine that
last sentence, you will realize that the database needs to have made
that table of data in the first place, so there is a correlation
between the rows in the database and the rows of your spreadsheet. So
let me clarify my previous statement about editing. If you want to
edit the data, rather than just allow the visitor to sort the data in
place, you will need a sort of content management system to hold the
data, display it dynamically, and accept form submissions to change
that data.

Walter

On May 19, 2009, at 10:46 AM, duotone wrote:

I have an excel spread sheet and would like to put it online.

It needs to maintain the same sorting / filtering functions. How do
I do this?

Thanks

Tony

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

3

On 19 May 2009, at 15:46, duotone wrote:

I have an excel spread sheet and would like to put it online.

It needs to maintain the same sorting / filtering functions. How do
I do this?

Make it a download!

best wishes,

Paul Bradforth

http://www.paulbradforth.com

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

4

On 19 May 2009, at 15:46, duotone wrote:

I have an excel spread sheet and would like to put it online.

It needs to maintain the same sorting / filtering functions. How do
I do this?

Make it a download!

best wishes,

Paul Bradforth

http://www.paulbradforth.com

I’ve considered it, but the info is through a paid subscription and having it downloadable will allow people to modify and / or email it to friends… Tony

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

5

Thanks a ton Walt, I’ll look into that.

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

6

Is there not a ‘save as webpage’ bit in Excel? I may be wrong…

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

7

On 19 May 2009, at 16:08, duotone wrote:

I’ve considered it, but the info is through a paid subscription and
having it downloadable will allow people to modify and / or email it
to friends… Tony

Never mind; Walter came up with a much better idea :slight_smile:

best wishes,

Paul Bradforth

http://www.paulbradforth.com

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

8

Yes, but it writes truly awful code, and doesn’t sort/filter/tumble
the data.

Walter

On May 19, 2009, at 11:33 AM, Fergus T wrote:

Is there not a ‘save as webpage’ bit in Excel? I may be wrong…

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

9

You could also do this with Google Docs (http://
spreadsheets.google.com). Upload your spreadsheet, set the users and
permissions, and publish the document. Less elegant than hosting the
data on your server but it may prove a quicker solution for smaller
groups.
Regards,
Tim.
FreewayActions.com - Freeware and shareware actions for Freeway
Express & Pro.

Protect your mailto links from being harvested by spambots with Anti
Spam.
Only available at FreewayActions.com

http://www.freewayactions.com

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

10

I strongly recommend www.EditGrid.com

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

11

On 19 May 2009, 6:20 pm, John-Paul Kernot wrote:

I strongly recommend www.EditGrid.com

WOW, that’s pretty nice. Thanks!

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

12

You could also try http://www.blist.com

freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options