Spraedsheet cell format using java script

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • junior programmer
    New Member
    • Nov 2007
    • 1

    Spraedsheet cell format using java script

    Hi Guys,

    I am posting my first question to this forum.. If any thing is not clear I am happy to repost it with more detail..

    Ok My question is:

    I am using a java script code to export data from a web page to excell sheet.. using the ActiveX Object..

    Its working fine.. The only problem is "column formating".. each column is in "General format" (eg. if decimal no is 135.90 it displays on the spread sheet like 135.9)..But i want to diplay it as 135.90.

    How can i change the format of a particular column with java script

    If anybody can help..
    Ill really appreciate..

    Thanks,
  • acoder
    Recognized Expert MVP
    • Nov 2006
    • 16032

    #2
    Welcome to TSDN!

    You'll need the NumberFormat property. Note that this isn't JavaScript, but JScript (a proprietary version).

    Comment

    Working...