I have written the javascript code for client side using Google Map API that is running well when i am reading excel sheet having 170 rows but when i tried to run it on excel having 237 rows so it gives error in the array "farah[...]5 is null or not an object",then i ok to debugg but debugger doesn't show anything and map opens but as i want to plot polygon doesn't appears.The same code is showing polygons well for excel of 170 rows.
In the excel sheet,i used latitude value in col 3 and longitude value in col 2,ID is in col 5 for which i want to store values and plot polygon is after col 6 and onwards.
Below is my code.Please can anyone solve this problem.
Collapse - <html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml">
-
<head>
-
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
-
<title>Google Maps API Sample</title>
-
<script src="http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAA1XbMiDxx_BTCY2_FkPh06RRaGTYH6UMl8mADNa0YKuWNNa8VNxQEerTAUcfkyrr6OwBovxn7TDAH5Q" type="text/javascript"></script>
-
<script type="text/javascript">
-
document.write("<pre>");
-
function initialize() {
-
farah=new Array()
-
samrah=new Array()
-
var Excel;
-
Excel = new ActiveXObject("Excel.Application");
-
Excel.Visible = false;
-
var a=Excel.Workbooks.Open("C:/desktop/Book5.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;
-
}
-
n=prompt("ENTER THE ID","");
-
var x,y,a;
-
for(a=1;a<farah.length;a++)
-
{if(n==farah[a][5])
-
{x=farah[a][1];
-
y=farah[a][2];}}
-
if (GBrowserIsCompatible()) {
-
var map = new GMap2(document.getElementById("map_canvas"));
-
map.setCenter(new GLatLng(y,x), 15);
-
map.addControl(new GSmallMapControl());
-
map.addControl(new GMapTypeControl());
-
map.addControl(new GMapTypeControl());
-
-
for(m=1;m<farah.length;m++)
-
{
-
bsc=farah[m][5];
-
if(n==bsc)
-
{
-
samrah=new Array()
-
u=0;y=6;
-
if(farah[m][6]!=null)
-
{
-
do
-
{samrah[u]=farah[m][y];
-
u++;
-
y++;
-
}
-
while(farah[m][y]!=null);
-
u--;
-
}
-
}
-
m++;
-
bsc1=farah[m][5];
-
-
if(n==bsc1)
-
{
-
samrah=new Array()
-
u=0;y=6;
-
if(farah[m][6]!=null)
-
{
-
do
-
{samrah[u]=farah[m][y];
-
u++;
-
y++;
-
}
-
while(farah[m][y]!=null);
-
u--;
-
}}
-
m++
-
bsc2=farah[m][5];
-
-
-
if(n==bsc2)
-
{
-
samrah=new Array()
-
u=0;y=6;
-
if(farah[m][6]!=null)
-
{
-
do
-
{samrah[u]=farah[m][y];
-
u++;
-
y++;
-
}
-
while(farah[m][y]!=null);
-
u--;
-
}}
-
-
}
-
-
-
-
for(t=1;t<farah.length;t++)
-
{cell=farah[t][5]
-
for(j=0;j<samrah.length;j++)
-
{
-
-
if(samrah[j]==cell)
-
{
-
c3=farah[t][0];
-
lat =farah[t][2];
-
lon = farah[t][1];
-
var latOffset = 0.05;
-
var lonOffset = 1;
-
var latOffset2 = 0.05;
-
var lonOffset2 = 1;
-
-
switch(c3)
-
{
-
case "1":
-
{polygon = new GPolygon([
-
new GLatLng(lat , lon ),
-
new GLatLng(lat - (latOffset2-0.049), lon + (lonOffset-0.9995)),
-
new GLatLng(lat - (latOffset2-0.049), lon - (lonOffset-0.9995)),
-
new GLatLng(lat , lon ),
-
], "0x987654", 0.1 , 0.9, "0x987654", 0.9);
-
-
map.addOverlay(polygon);
-
break;}
-
case "2":
-
{polygon2 = new GPolygon([
-
new GLatLng ( lat, lon),
-
new GLatLng(lat ,lon + (lonOffset2-0.999)),
-
new GLatLng(lat + (latOffset-0.049),lon + (lonOffset2-0.999)),
-
new GLatLng(lat,lon),
-
], "0x987654", 0.1 , 0.9, "0x987654", 0.9);
-
map.addOverlay(polygon2);
-
break;}
-
default:
-
{polygon3 = new GPolygon([
-
new GLatLng( lat, lon),
-
new GLatLng( lat, lon - (lonOffset2-0.999)),
-
new GLatLng( lat + (latOffset-0.049), lon - (lonOffset2-0.999)),
-
new GLatLng( lat ,lon),
-
], "0x987654", 0.1 , 0.9, "0x987654", 0.9);
-
map.addOverlay(polygon3);
-
break;}}
-
}
-
}
-
}
-
}
-
}
-
</script>
-
</head>
-
<body onload="initialize()" onunload="GUnload()" style="font-family: Arial;border: 0 none;">
-
<div id="map_canvas" style="width: 1000px; height: 900px"></div>
-
</body>
-
</html>
1  1268  acoder 16,027
Recognized Expert Moderator MVP
You may want to double-check your Excel file. It may be that one of the rows has something missing.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: leke |
last post by:
Hi, I am trying to learn PHP but am having some problems getting my code
running in Explorer 6.
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php echo '<p>Hello World</p>'; ?>...
|
by: Pls Help |
last post by:
Hi,
I've encountered a weird TrackBar issue, it seems to hang completely when
the TrackBar.Maximum is set to certain large values.. what's going on? Have
tried this on a few different 2000/XP...
|
by: Axter |
last post by:
I normally use a program call Doxygen to document my source
code.(http://www.stack.nl/~dimitri/doxygen)
This method works great for small and medium size projects, and you can
get good...
|
by: tito |
last post by:
Hi All,
I am trying to write a code which will convert the Excel sheet document to Pie Diagarm using Perl Script.I have already searched in CPAN which gives the details of...
|
by: Martin Walke |
last post by:
Hi all,
I have an ASP application where I need to not only read the selected item
from a combo box on a web page but also all the options in the combo box.
Can someone point me in the right...
|
by: sathyan8294 |
last post by:
what is vb.net code for changing the values in datagrid and save the changed values using vb.net windows application
|
by: ramona chauhan |
last post by:
Hi
This is ramona . i want to know the code for reading an excel file.
please provide the required code.
|
by: JFKJr |
last post by:
I have an excel file, which has columns C and D grouped together, I am trying to delete blank columns and rows from the excel file, ungroup the columns and import the file to MS Access using Access...
|
by: =?Utf-8?B?U2hlZXMgQWJpZGk=?= |
last post by:
I read an article on the link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;306572 related to
reading data from Excel using OLEDB The topic's heading is: How to query and
display excel...
|
by: ronakinuk |
last post by:
how to mark comment on a block of code in one click in excel vba
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
