how do I import excel functions to FrontPage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make a website that has a form that uses basic excel functions such
as SUM and IF decision variables. More specifically, I want to use check
boxes and I want other values to change based on which check box is clicked
on. Thanks for any help!
 
SLIPSTREAM said:
I want to make a website that has a form that uses basic excel
functions such as SUM and IF decision variables. More specifically, I
want to use check boxes and I want other values to change based on
which check box is clicked on. Thanks for any help!
Click to expand...

You need to write a javascript function.

It has many functions available to help

SUM would be done by looping around elements
An example
var sum= 0 , Lmax = 5
for (var L=1 ; L <= Lmax ; L++)
{sum += document.getElementByID("ident" + L).value }
return sum

IF functions are as simple as
if (var == value)
{ // do something
}

Have a look at http://www.w3schools.com/default.asp or many other sites
(Google for "Javascript")
 
Hi,

The Excel function are not available in FrontPage or any web design package. To accomplish you'll need to program either the client
side or server side using a programming language.
 
WOW! That's totally what I want my site to do. I'm downloading the program
right now--if this works like I think it will, I will be very indebted to you
(developing this site is supposed to save my company a ton of $$$)

Thanks so much for the tip!!
 
happy to help.
you should also know the author is very good about letting you send him a
spreadsheet, and sending back a
version that will work with his converter.

he did this for me, full sheet, once before purchase, once since.. both
times in about a day.

I couldn't use one excel function, he showed me how to do the same thing in
another way
(I had an array-he sent me enough lines to finish the sheet in another
manner- going line by line)
check the list at
http://www.spreadsheetconverter.com/article/articleview/33/1/1/ for
supported
excel functions..
 
Back
Top