(no subject)

[nonethefewer]

Dear the world:

I want, right now, a Javascript spreadsheet-esque thing.

Features:

- First use asks for row/column values.
- Gives me a space to enter data.  So, not just a table generator, but a table plus content generator.
- Add/delete rows/cols as necessary.
- Export HTML.
- Open source, adurr.

Nice to have:

- Cell alignment.
- Back/fore colouring.

And nothing else.  I don't need an Excel clone, I'm just looking for something to do tables quickly for me.

Thankscerely,

-X

Comments

[va-bofh.livejournal.com]

Why would you want that in Javascript? Javascript manipulates the DOM. I've created a row/insert function for Javascript but you can't right-click to get the html. PHP would be much easier. A form with your inputs, click "Submit" and you have your page. Colors and such are style stuff and better in css but could also be added.

Try: http://mooks.us/stuff/table.html
PHP: http://mooks.us/stuff/table.txt

[the-xtina.livejournal.com]

Primarily because I'm trying to get something simple to export to Mediawiki format.  Editing a largish table with, saaay, weapons and armor data becomes a pain in the ass after the first few rows.

[va-bofh.livejournal.com]

What's the format of the data (weapons and armor)? Generally when I do that, I convert the spaces to tabs then write a script to create the table using the data. Since it's wikipedia, I use the | and || vs the normal table stuff.

#!/usr/bin/perl

open (<input ... >,"weapons.dat");
while (<input ... >) {
chomp;

(@weapons) = split("\t");

print "|";
for ($j = 0; $j < $#weapons; $j++) {
print $weapons[$j], "||";
}
print "\n|-\n";
}

close INPUT;

That way I should end up with something like:

====Bikes====
{|
!Bikes!!Hand!!Accel!!Speed!!Pilot!!Body!!Armor!!Sensor!!Avail!!Cost!!Page
|-
|Dodge Scoot (Scooter)|| +1||10/15||60||1||4||2||1|| -||3,000N||sr4.341
|-
|Harley-Davidson Scorpion (Chopper)|| +2||15/30||120||2||8||4||1|| -||12,000N||sr4.341
|}

[the-xtina.livejournal.com]

Nothing huge, a Flash game I'm playing:

http://armorgames.com/play/5003/arcuz

Surprisingly involving.

So the issue isn't one-time table creation, in which case uploading and parsing would be fine, it's ongoing "Oh, is that what that kind of sword costs!" data-gathering.

I suppose I could download a Flash decompiler and figure it out, but my way is more fun.

[va-bofh.livejournal.com]

Oh, is it a single page? Try:

#!/usr/bin/perl

print "{|\n";
for ($i = 0; $i < 30; $i++) {
print "|";
for ($j = 0; $j < 20; $j++) {
print "blank||";
}
print "\n|-\n";
}
print "|}\n";

You'll just have to take out the last |- and modify the script for the number of columns/rows you want to create for Wikipedia.

[va-bofh.livejournal.com]

Hmmm... programming hat on (well, I've been programming programming a bunch lately :) ).

I could probably create a three or four step dealy:

1. html to get the rows, etc.
2. generate the grid with input fields.
3. fill in the fields, when done, click submit
4. generate a wikipedia output screen.

You could do a couple of lines at a time and just add them to the wiki page as you go along.

Just a thought.

[the-xtina.livejournal.com]

Yeah, my thought is:

- have a button or summat in the wiki to start this shit
- ask for rows and columns
- generate the grid, &c
- if I click Add, add a row
- on this button, add Wiki markup to the draft box

Downside would be future editing... buuut, that depends on... well, whether I want to incorporate a draft-save thing, or an edit-existing thing.

[the-xtina.livejournal.com]

Saying "You know, it wouldn't be hard" is ever my doom.  *wry*

[va-bofh.livejournal.com]

Finished. Try the first link again :)

[va-bofh.livejournal.com]

The scripts are simple enough, you could add a wiki markup to the script. I use span /span for mine and have a separate css markup page for highlights (I highlight my Shadowrun adventures).


Hey! Speaking of Shadowrun. I'm running a Google Wave Shadowrun game. If you want to pop over and lurk (see what sort of stuff I'm doing), check out the Shadowrun Wave (https://wave.google.com/wave/#restored:wave:googlewave.com!w%252BtFsknOOOB). If you don't have a google wave account and want one, pass along a gmail address and I can throw an invite your way.