Compatibilty issue of "usedrange"property with Google Map APIs

Question

0.00/5 (No votes)

See more:

Hi All,

I've a problem that when i'm loading program of reading the excel sheet using "usedrange" property so its running well but when i integrated this code with my Google map API code so its showing an error in property of "usedrange" is that "its undefined or null or not an object".

Please can anyone make this code run well.Or tell me the better alternative. I'm badly in need of this code error free:

&lt;html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml"&gt; 
&lt;head&gt; 
&lt;meta http-equiv="content-type" content="text/html; charset=utf-8" /&gt; 
&lt;title&gt;Google Maps API Sample&lt;/title&gt; 
&lt;script src="http://maps.google.com/maps?file=api&amp;v=2&amp;sensor=fa lse&amp;key=ABQIAAAA1XbMiDxx_BTCY2_FkPh06RRaGTYH6UMl8m ADN a0YKuWNNa8VNxQEerTAUcfkyrr6OwBovxn7TDAH5Q" type="text/javascript"&gt;&lt;/script&gt;  
&lt;/head&gt; 
&lt;body onload="initialize()" onunload="GUnload()" style="font-family: Arial;border: 0 none;"&gt;
&lt;div id="map_canvas" style="width: 500px; height: 300px"&gt;&lt;/div&gt; 
&lt;/body&gt; 
&lt;/html&gt;

JavaScript

function initialize() { 
var farah=new Array() 
var Excel; 
Excel = new ActiveXObject("Excel.Application") 
Excel.Visible = false 
var a=Excel.Workbooks.Open("C:/desktop/test.xlsx").sheets(1) 
for (var r=1;r<=a.usedrange.rows.count;r++) 
{farah[r-1]=new Array() 
for (var c=1;c<=a.usedrange.columns.count;c++) 
farah[r-1][c-1]=a.Cells(r,c).Value;} 
var x=0,y=0; 
for(len in farah) 
{x+=farah[len][1]; 
y+=farah[len][2];} 
p1=(x/farah.length) 
p2=(y/farah.length); 
//document.write(p1+p2); 
if (GBrowserIsCompatible()) 
{ 
var map = new GMap2(document.getElementById("map_canvas")); 
var center = new GLatLng(p1,p2); 
map.setCenter(center, 10); 
map.addControl(new GSmallMapControl()); 
map.addControl(new GMapTypeControl()); 
function createMarker(point) { 
var marker = new GMarker(point); 
GEvent.addListener(marker, "click", function() { 
marker.openInfoWindowHtml("Marker lattitude and longitude" + point + "karachi" ); 
}); 
return marker; 
} 
var point=new GLatLng(78.9,122.9) 
map.addOverlay(createMarker(point)) 
}}

Posted 17-Jun-10 19:00pm

Farah Siraj

Updated 18-Jun-10 7:26am

Sandeep Mewara

v2

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)