Excel to JavaScript?

taff posted this at 20:05 — 27th March 2002.

Joined: Jun 2001

I'm sure that I'm probably dreaming in technicolor here but I figured it's worth a shot.

I need to convert an Excel spreadsheet into a JavaScript form. Looking at the math, I way underestimated this one. My question is:

Is there some sort of tool/app that will generate this for me?

Please say yes!

.....

dk01 posted this at 21:47 — 27th March 2002.

He has: 516 posts

Joined: Mar 2002

Ok I am new here but the way I see it you have 2 options and both would include using some sort of server side language (ie. ASP, PHP, CGI) if you decide you would like to read directly from the Excel database then you could use ASP's excel data connection at 7host.com:
http://www.7host.com/example_detail.asp?example_id=10
The other option would be to export your database to a text file and then have the server-side language read the text file. (In ASP you can try 4guysfromrolla.com) At any rate I hope you get what your looking for!
-dk

mairving posted this at 21:55 — 27th March 2002.

They have: 2,256 posts

Joined: Feb 2001

I dunno there Taff. I would think that first you would need to get your excel info into a database, then build a form to the data, which you could use js for. Is this a spreadsheet with a lot of formulas?

Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states

taff posted this at 22:49 — 27th March 2002.

They have: 956 posts

Joined: Jun 2001

Yeah, I guess I should elaborate some. There is no data here per se. It is basically a calculation form - plug in a, b, c (and d, e, f, g, h, etc!) to calculate x, y, z.

My original plan was to just create a form and function from scratch but I somewhat underestimated the complexity of the form. Odds are I'll just have to bite the bullet and start from scratch but I would hate to do that and THEN find a shortcut

.....

detox posted this at 02:02 — 28th March 2002.

They have: 571 posts

Joined: Feb 2001

Seems to me the data driven / server side way of doing this is better. Are you just wanting to apply calculations toa set of returned form fields?

My solution:
If so then wrap it up in an ASP/VB class and apply the transformation. That would be a lot faster than incorporating excel plus it would decrease server load.......

The majority of Users solution:

PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP!!!!!!!

taff posted this at 21:01 — 28th March 2002.

They have: 956 posts

Joined: Jun 2001

ok. This is way too freakin' complicated for my mathematically-challenged, javascript-deficient mind to wrap itself around!

There aren't THAT many input fields (perhaps 10?) but the formulae are complex and conditional. Stuff like:

=IF(D12>MIN(D21,15000),5000,IF(D12<10000,0,MIN(15000,D21)-D12))

eek!

I was expecting things like X=(A+B)/C*D
I would even have a hard time with that!

Detox, you say that this would be doable in PHP? As of now, I have no idea what the client has lined up for hosting but it looks like I need to go back to the well for funding on this one. Luckily, I didn't lock myself in on the price for this one.

taff

'rithmetic never WAS one of my strong R's