How to pass Excel object(made by ActiveX object) into function using javascript

Question

2.50/5 (2 votes)

See more:

Hi all,
Actually i made the code in which onloading event of body i want to open Excel which is in one function and onClick event of checkbox i want to work with that excel in another function.
Can anyone please tell me how to pass excel object in other function.
Thanks in advance.

<html>
<head>
<script type="text/javascript">
function initialize()
{Excel = new ActiveXObject("Excel.Application"); 
Excel.Visible = false; 
a=Excel.Workbooks.Open("C:/desktop/P1."+x).sheets(1);
return a;
}
function search(b)
{n=b.usedrange.rows.count;
alert(n);
}
</script>
</head>
<body  önload="x=initialize()">
<input type="checkbox" id="b1"  önClick="search(x)">
</body>
</html>

Posted 13-Apr-11 6:55am

Farah Siraj

Updated 13-Apr-11 7:00am

TweakBird

v2

Add a Solution

Comments

TweakBird 13-Apr-11 13:01pm

Please use <pre> tag for code blocks.

Manfred Rudolf Bihy 15-Apr-11 8:32am

Sorry Farah, for posting untested code yesterday. I thought ironing out the most blatant mistakes would suffice, but alas it wasn't enough. This time I got my sample code fixed and please try it out heeding the message right below "Modification".
Thanks,

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manfred Rudolf Bihy · Answer 1 · 2011-04-13T10:33:00

Restructure your code a bit analogous to this:

Modification:

Sorry Farah for posting untested code. This time I tried out the example I posted below and it works. So please try to resolve your issue by using the code below as an example. I removed some funny characters that were there. Instead of an o in onclick and onload there was an ö both times. I adjusted the path in my example because I had to generate an Excel workbook for the test. Please substitute your path instead, but look at what you did in your excel path. I'm not sure why you wanted to append x to the end of the filename because x would have been the excel worksheet (see your önload in the body tag).

XML

<html>
<head>
<script type="text/javascript">
    // This global variable may not really be needed, but you might want to use it later on so I made it global
    var myExcelSheet = undefined;

    function initialize(){
        Excel = new ActiveXObject("Excel.Application");
        Excel.Visible = false;
        return Excel.Workbooks.Open("C:/temp/test.xlsx").sheets(1);
    }

    function search(sheet){
        var n = sheet.usedrange.rows.count;
        alert(n);
    }

    function onBodyLoaded()
    {
        // Sets the global variable myExcelSheet here
        myExcelSheet = initialize();
    }
</script>
</head>
<body  onload="onBodyLoaded();">
<form>
    <input type="checkbox" id="b1"  onClick="search(myExcelSheet)">
</form>
</body>
</html>

You should really debug this using IE's "Developer Tools" where you can set breakpoints in your javascript and then go through your code step by step.

Happy coding!

-MRB