////////////////////////////////////////////////////////////
//
// MENU SCRIPT     (scroll to the bottom for menu content)
//
////////////////////////////////////////////////////////////

var isDOM = (document.getElementById ? true : false);
var isIE4 = ((document.all && !isDOM) ? true : false);
var isNS4 = (document.layers ? true : false);

function getRef(id) {
  if (isDOM) return document.getElementById(id);
  if (isIE4) return document.all[id];
  if (isNS4) return document.layers[id];
}


function loadPage(id,nestref,url) {
    // change the 550 value to make the layer wider or smaller
    content_width = 550;
    if (isNS4) {
	var lyr = (nestref)? eval('document.'+nestref+'.document.'+id) : document.layers[id]
	    lyr.load(url,content_width)
    }
    else if(isIE4) parent.content.location = url;
    else if(isDOM) document.getElementById('contentFrame').src = url;
}

function showPage(id) {
    if (isIE4) {
	document.all[id].innerHTML = parent.contentFrame.document.body.innerHTML;
    }
    else if(isDOM) {
	document.getElementById(id).innerHTML = window.frames['contentFrame'].document.getElementById('theBody').innerHTML;
    }
}




function getSty(id) {
  return (isNS4 ? getRef(id) : getRef(id).style);
}

var menuArray = new Array();
for (var i = 0; i<10; i++) menuArray[i]=null;

var numOfMenus = 0;

function registerMenu(menuToAdd) {
   menuArray[numOfMenus] = menuToAdd;
   litNow[numOfMenus] = new Array();
   numOfMenus++;
}

// Hide timeout.
var popTimer = 0;

// Array showing highlighted menu items.
var litNow = new Array();

function popOver(i, menuNum, itemNum) {
  hideAllOtherMenus(i);
  var menu = menuArray[i];
  //alert(menu[menuNum][itemNum].target);
  clearTimeout(popTimer);
  hideAllBut(i, menuNum);
  litNow[i] = getTree(i, menuNum, itemNum);
  changeCol(i, litNow[i], true);
  targetNum = menu[menuNum][itemNum].target;
  if (targetNum > 0) {
    thisX = parseInt(menu[menuNum][0].ref.left) + parseInt(menu[menuNum][itemNum].ref.left);
    thisY = parseInt(menu[menuNum][0].ref.top) + parseInt(menu[menuNum][itemNum].ref.top);
    testH = thisY+parseInt(menu[targetNum][0].ref.height);
    if (parseInt(navigator.appVersion)>3) {
	if (navigator.appName=="Netscape") {
	    winH = window.innerHeight;
	}
	if (navigator.appName.indexOf("Microsoft")!=-1) {
	    winH = document.body.offsetHeight;
	}
    }
    if (testH>winH) {
	thisY = thisY - parseInt(menu[targetNum][0].ref.height)+parseInt(menu[menuNum][itemNum].ref.height);
    }
    with (menu[targetNum][0].ref) {
      left = parseInt(thisX + menu[targetNum][0].x);
      top = parseInt(thisY + menu[targetNum][0].y);
      visibility = 'visible';
    }
  }
}

function hideAllOtherMenus(i) {
  for (var x = 0; x<numOfMenus; x++) {
    if (x!=i) {
      var menu = menuArray[x];
      for (count = 1; count < menu.length; count++)
        menu[count][0].ref.visibility='hidden';
      changeCol(x,litNow[x],false);
    }
  }
}

function popOut(i, menuNum, itemNum) {
 
  var menu = menuArray[i];
  if ((menuNum == 0) && !menu[menuNum][itemNum].target) {
      hideAllBut(i,0);
       showDropDowns();
  }
  else
      popTimer = setTimeout('hideAll();showDropDowns()', 500);
}


function getTree(i, menuNum, itemNum) {
  // Array index is the menu number. The contents are null (if that menu is not a parent)
  // or the item number in that menu that is an ancestor (to light it up).
  var menu = menuArray[i];
  //alert(menu.length);
  itemArray = new Array(menu.length);
  while(1) {
      itemArray[menuNum] = itemNum;
      // If we've reached the top of the hierarchy, return.
      if (menuNum == 0) return itemArray;
      itemNum = menu[menuNum][0].parentItem;
      menuNum = menu[menuNum][0].parentMenu;
  }
}


// Pass an array and a boolean to specify colour change, true = over colour.
function changeCol(i, changeArray, isOver) {
    //  alert("ChangeCol\ni: "+i+"\nchangeArray:"+changeArray+"\nisOver:"+isOver);
  var menu = menuArray[i];
  for (menuCount = 0; menuCount < changeArray.length; menuCount++) {
    if (changeArray[menuCount]) {
      newCol = isOver ? menu[menuCount][0].overCol : menu[menuCount][0].backCol;
      // Change the colours of the div/layer background.
      with (menu[menuCount][changeArray[menuCount]].ref) {
      if (isNS4) bgColor = newCol;
        else backgroundColor = newCol;
      }
	}
  }
}


function hideAllBut(i, menuNum) {
  var menu = menuArray[i];
  var keepMenus = getTree(i, menuNum, 1);
  for (count = 0; count < menu.length; count++)
    if (!keepMenus[count])
      menu[count][0].ref.visibility = 'hidden';
  changeCol(i, litNow[i], false);
}

function hideAll() {
  for (var i = 0; i< numOfMenus; i++) {
    var menu = menuArray[i];
    var keepMenus = getTree(i, 0, 1);
    for (count = 0; count < menu.length; count++)
      if (!keepMenus[count])
        menu[count][0].ref.visibility = 'hidden';
      changeCol(i, litNow[i], false);
  }
}

// *** MENU CONSTRUCTION FUNCTIONS ***

function Menu(isVert, popInd, x, y, width, overCol, backCol, borderClass, textClass) {
  // True or false - a vertical menu?
  this.isVert = isVert;
  // The popout indicator used (if any) for this menu.
  this.popInd = popInd
  // Position and size settings.
  this.x = x;
  this.y = y;
  this.width = width;
  // Colours of menu and items.
  this.overCol = overCol;
  this.backCol = backCol;
  // The stylesheet class used for item borders and the text within items.
  this.borderClass = borderClass;
  this.textClass = textClass;
  // Parent menu and item numbers, indexed later.
  this.parentMenu = null;
  this.parentItem = null;
  // Reference to the object's style properties (set later).
  this.ref = null;
}

function Item(text, href, frame, length, spacing, target) {
  this.text = text;
  this.href = href;
  this.frame = frame;
  this.length = length;
  this.spacing = spacing;
  this.target = target;
  // Reference to the object's style properties (set later).
  this.ref = null;
}

function writeMenus(i)
{
  
  var menu = menuArray[i];
  if (!isDOM && !isIE4 && !isNS4) return;
  
  for (currMenu = 0; currMenu < menu.length; currMenu++) with (menu[currMenu][0]) {
    // Variable for holding HTML for items and positions of next item.
      var str = '', itemX = 0, itemY = 0, menuHeight=0;

    // Remember, items start from 1 in the array (0 is menu object itself, above).
    // Also use properties of each item nested in the other with() for construction.
    for (currItem = 1; currItem < menu[currMenu].length; currItem++) with (menu[currMenu][currItem]) {
      var itemID = i+'menu' + currMenu + 'item' + currItem;
      

      // The width and height of the menu item - dependent on orientation!
      var w = (isVert ? width : length);
      var h = (isVert ? length : width);
      if (isVert) menuHeight+=h;

      // do some checking to make sure the menu fits on the screen (BUGGY)
      //if ((itemY+h) > self.height) itemY = itemY-h;
      //itemX = self.width;


      // Create a div or layer text string with appropriate styles/properties.
      // Thanks to Paul Maden (www.paulmaden.com) for helping debug this in IE4, apparently
      // the width must be a miniumum of 3 for it to work in that browser.
      if (isDOM || isIE4)
      	{
        str += '<div id="' + itemID + '" style="position: absolute; left: ' + itemX + '; top: ' + itemY + '; width: ' + w + '; height: ' + h + '; visibility: inherit;';
        if (backCol) str += 'background: ' + backCol + '; ';
        str += '" ';
	}
	if (isNS4)
	{

        str += '<layer id="' + itemID + '" left="' + itemX + '" top="' + itemY + '" width="' +  w + '" height="' + h + '" visibility="inherit" ';
        if (backCol) str += 'bgcolor="' + backCol + '" ';
	}
	if (borderClass) str += 'class="' + borderClass + '" ';

      // Add mouseover handlers and finish div/layer.


      if (href=='')
      {
         str += 'onMouseOver="popOver(' +i+',' + currMenu + ',' + currItem + ');hideDropDowns('+i+')" onMouseOut="popOut('+i+',' + currMenu + ',' + currItem + ')">';
      }
      else
      {
      	if (frame)
	      str += 'onClick="window.open(\''+href+'\')" onMouseOver="popOver('+i+','+currMenu+','+currItem + ');hideDropDowns('+i+')" onMouseOut="popOut('+i+',' + currMenu + ',' + currItem + ')">';
	    else
	      str += 'onClick="location.href=\'' + href + '\'" onMouseOver="hideDropDowns('+i+');popOver(' +i+',' + currMenu + ',' + currItem + ')" onMouseOut="popOut('+i+',' + currMenu + ',' + currItem + ')">';
	    
      }

      // Add contents of item (default: table with link inside).
      // In IE/NS6+, add padding if there's a border to emulate NS4's layer padding.
      // If a target frame is specified, also add that to the <a> tag.

      str += '<table width="' + (w - 8) + '" border="0" cellspacing="0" cellpadding="' + (!isNS4 && borderClass ? 3 : 0) + '"><tr><td align="left" valign="middle" height="' + (h - 7) + '">';
    
      //if (isNS4) 
      //	  //str+='<link class="' + textClass + '">'+text+'</link>';// onClick="location.href=\''+href+'\'">' + text + '</link>';
      //	  str+='<a class="'+textClass+'" href="'+href+'">'+text+'</a>';
      //else
      if (isDOM || !isNS4) str+='<span class="'+textClass+'">'+text+'</span>';
      //else if(frame=='') str+='<a href="'+href+'">'+text+'</a>';
      else str+=text;
      //str+='<font class="'+textClass+'">'+text+'</font>';
      //style="cursor: pointer; cursor:hand"
      //}
      //else
      //{
      //str+= '<a class="' + textClass + '" href="' + href + '"' + (frame ? ' target="' + frame + '">' : '>') + text + '</a>';
      
      str+='</td>';

      if (target > 0) {

        // Set target's parents to this menu item.
        menu[target][0].parentMenu = currMenu;
        menu[target][0].parentItem = currItem;

        // Add a popout indicator.
        if (popInd) str += '<td class="' + textClass + '" align="right" valign="middle">' + popInd + '</td>';
      }
      str += '</tr></table>' + (isNS4 ? '</layer>' : '</div>');
      if (isVert){
	  itemY += length + spacing;
	  menuHeight+=spacing;
      }
      else itemX += length + spacing;

    }
    
    if (isDOM) {
      var newDiv = document.createElement('div');
      document.getElementsByTagName('body').item(0).appendChild(newDiv);
      newDiv.innerHTML = str;
      ref = newDiv.style;
      ref.position = 'absolute';
      ref.visibility = 'hidden';
      if (isVert) ref.height = menuHeight;
    }

    // Insert a div tag to the end of the BODY with menu HTML in place for IE4.
    if (isIE4) {
	strHTML = '<div id=i+"menu' + currMenu + 'div" ' + 'style="position: absolute; visibility: hidden;';
	if (isVert) strHTML += ' height: '+menuHeight+';';
	strHTML+='>' + str + '</div>';
	document.body.insertAdjacentHTML('beforeEnd', strHTML);
	ref = getSty(i+'menu' + currMenu + 'div');
    }

    // In NS4, create a reference to a new layer and write the items to it.
    if (isNS4) {
	//alert(str);
      ref = new Layer(0);
      ref.document.write(str);
      ref.document.close();
    }

   for (currItem = 1; currItem < menu[currMenu].length; currItem++) {
      itemName = i+'menu' + currMenu + 'item' + currItem;
      if (isDOM || isIE4) menu[currMenu][currItem].ref = getSty(itemName);
      if (isNS4) {
	  menu[currMenu][currItem].ref = ref.document.layers[currItem-1];
	  //alert(getSty(itemName));
      }
    }

  }
  //alert(str)
  with(menu[0][0]) {
    ref.left = x;
    ref.top = y;
    ref.visibility = 'visible';
  }
}


var popOldWidth = window.innerWidth;
nsResizeHandler = new Function('if (popOldWidth != window.innerWidth) location.reload()');

// This is a quick snippet that captures all clicks on the document and hides the menus
// every time you click. Use if you want.

if (isNS4) document.captureEvents(Event.CLICK);
document.onclick = clickHandle;

function clickHandle(evt)
{
 if (isNS4) document.routeEvent(evt);
 hideAll();
}

function buildMenus() {
 for (var i = 0; i<numOfMenus; i++) {
      writeMenus(i);
      //alert(numOfMenus);
      //alert("Writing menu "+i);
  }
  //writeMenus(menuArray[0]);
}

function hideDropDowns(i) 
{
  
  if(i>0) 
    return;
    if (document.all)
     {
     if (document.all('SearchDrop1') != null)
	    document.all('SearchDrop1').style.visibility = "hidden";
     if (document.all('SearchDrop2') != null)
	    document.all('SearchDrop2').style.visibility = "hidden";
     if (document.all('FAQDropDown1') != null)
	    document.all('FAQDropDown1').style.visibility = "hidden";
	 if (document.all('ProductList') != null)
	    document.all('ProductList').style.visibility = "hidden";
     }
     else if(isNS4) {
	//if(document.ids.FAQDropDown1 != undefined){
	//	document.ids.FAQDropDown1.display = "none";
	//	document.layers['FAQDropDown1'].visibility = "hide";
	//}
     }
}

function showDropDowns() { 
  if(document.all) {
	if (document.all('SearchDrop1') != null)
		document.all('SearchDrop1').style.visibility = "visible";
	if (document.all('SearchDrop2')!= null)
		document.all('SearchDrop2').style.visibility = "visible";
	if (document.all('FAQDropDown1') != null)
		document.all('FAQDropDown1').style.visibility = "visible";
	if (document.all('ProductList') != null)
		document.all('ProductList').style.visibility = "visible";
  }
  
  else if(isNS4) {
	//if(document.ids.FAQDropDown1 != undefined){
	//	document.layers['FAQDropDown1'].visibility = "show";
	//}
  }
}




////////////////////////////////////////////////////////////
//
// MENU CONTENT
//
////////////////////////////////////////////////////////////

var menu2 = new Array();

menu2[0] =  new Array();
menu2[0][0] = new Menu(true,'<img src="include/bluearrow.gif">',10,270,180,'#99ADC2','#5E7893','','itemText2');
menu2[0][1] = new Item('<SPAN class="MENU1">Welcome</SPAN>','default.aspx.html','',25,2,0);
menu2[0][2] = new Item('<SPAN class="MENU1">Introduction</SPAN>','default.aspx.html','',25,2,1);
menu2[0][3] = new Item('<SPAN class="MENU1">Quick Start</SPAN>','default.aspx.html','',25,2,2);
menu2[0][4] = new Item('<SPAN class="MENU1">ExcelTemplate in Depth</SPAN>','features/exceltemplate.aspx.html','',25,2,3);
menu2[0][5] = new Item('<SPAN class="MENU1">ExcelApplication in Depth</SPAN>','features/excelapplication.aspx.html','',25,2,4);
menu2[0][6] = new Item('<SPAN class="MENU1">HotCell Technology</SPAN>','features/roundtrip_post.aspx.html','',25,2,0);
menu2[0][7] = new Item('<SPAN class="MENU1">Samples</SPAN>','http://support.softartisans.com/OfficeWriter/ExcelWriter/doc/features/samples.asp','new',25,2,0);
menu2[0][8] = new Item('<SPAN class="MENU1">Programmer Reference</SPAN>','reference/default.aspx.html','',25,2,5);
menu2[0][9] = new Item('<SPAN class="MENU1">Installation</SPAN>','install/default.aspx.html','',25,2,7);
menu2[0][10] = new Item('<SPAN class="MENU1">External Links</SPAN>','','',25,2,8);
menu2[0][11] = new Item('<SPAN class="MENU1">&nbsp;WordWriter</SPAN>','../WordWriter/default.aspx.html','',25,2,0);
menu2[0][12] = new Item('<SPAN class="MENU1">&nbsp;Reporting Services 2005<br>&nbsp;Integration</SPAN>',"./../ReportingServices2005/default.aspx.html",'',40,2,0);
menu2[0][13] = new Item('<SPAN class="MENU1">&nbsp;Reporting Services 2000<br>&nbsp;Integration</SPAN>',"./../ReportingServices2000/default.aspx.html",'',40,2,0);
menu2[0][14] = new Item('<SPAN class="MENU1">&nbsp;ExcelWriter for .NET</SPAN>',"./../ExcelWriter/default.aspx.html",'',25,2,0);

menu2[1] =  new Array();
menu2[1][0] = new Menu(true,'<img src="include/bluearrow.gif">',175,0,200,'#99ADC2','#dddddd','itemBorder','itemText2');
menu2[1][1] = new Item('<SPAN class="MENU2">The Web Reporting Solution</SPAN>','intro/webreport.aspx.html','',20,0,0);
menu2[1][2] = new Item('<SPAN class="MENU2">What is ExcelWriter?</SPAN>','intro/whatisexcelwriter.aspx.html','',20,0,0);
menu2[1][3] = new Item('<SPAN class="MENU2">Features & Benefits</SPAN>','intro/features.aspx.html','',20,0,0);
menu2[1][4] = new Item('<SPAN class="MENU2">ExcelWriter Editions</SPAN>','intro/versions.aspx.html','',20,0,0);
//menu2[1][5] = new Item('<SPAN class="MENU2">New in Version 5</SPAN>','intro/new.aspx.html','',20,0,0);
menu2[1][5] = new Item('<SPAN class="MENU2">Requirements</SPAN>','intro/requirements.aspx.html','',20,0,0);
menu2[1][6] = new Item('<SPAN class="MENU2">Frequently Asked Questions</SPAN>','intro/faq.aspx.html','',20,0,0);

menu2[2] =  new Array();
menu2[2][0] = new Menu(true,'<IMG SRC="include/bluearrow.gif">',175,0,200,'#99ADC2','#dddddd','itemBorder','itemText2');
menu2[2][1] = new Item('<SPAN class="MENU2">Create a Spreadsheet with ExcelTemplate</SPAN>','quickstart/first_template_com.aspx.html','',40,0,0);
menu2[2][2] = new Item('<SPAN class="MENU2">Create a Spreadsheet with ExcelApplication</SPAN>','quickstart/first.aspx.html','',40,0,0);


menu2[3] =  new Array();
menu2[3][0] = new Menu(true,'<IMG SRC="include/bluearrow.gif">',175,0,250,'#99ADC2','#dddddd','itemBorder','itemText2');
menu2[3][1] = new Item('<SPAN class="MENU2">How to Use Templates</SPAN>','features/templates_howto.aspx.html','',20,0,0);
menu2[3][2] = new Item('<SPAN class="MENU2">Creating Data Markers</SPAN>','features/datamarkers.aspx.html','',20,0,0);
menu2[3][3] = new Item('<SPAN class="MENU2">Using an Array as a Data Source</SPAN>','features/templates_array.aspx.html','',20,0,0);
menu2[3][4] = new Item('<SPAN class="MENU2">Using a Database as a Data Source</SPAN>','features/templates_databasebind.aspx.html','',20,0,0);
menu2[3][5] = new Item('<SPAN class="MENU2">Output Options</SPAN>','features/output_exceltemplate.aspx.html','',20,0,0);
menu2[3][6] = new Item('<SPAN class="MENU2">Templates and Charts</SPAN>','features/templatewithchart.aspx.html','',20,0,0);
menu2[3][7] = new Item('<SPAN class="MENU2">Templates and PivotTables</SPAN>','features/templatewithpivottables.aspx.html','',20,0,0);
menu2[3][8] = new Item('<SPAN class="MENU2">Passing ExcelTemplate to ExcelApplication</SPAN>','features/templatetoapp.aspx.html','',40,0,0);

menu2[4] =  new Array();
menu2[4][0] = new Menu(true,'<IMG SRC="include/bluearrow.gif">',175,0,280,'#99ADC2','#dddddd','itemBorder','itemText2');
menu2[4][1] = new Item('<SPAN class="MENU2">Addressing Cells</SPAN>','features/addressing.aspx.html','',20,0,0);
menu2[4][2] = new Item('<SPAN class="MENU2">Setting Values</SPAN>','features/values.aspx.html','',20,0,0);
menu2[4][3] = new Item('<SPAN class="MENU2">Adding a Formula','features/formula.aspx.html','',20,0,0);
menu2[4][4] = new Item('<SPAN class="MENU2">Adding Formatting to a Spreadsheet</SPAN>','features/format.aspx.html','',20,0,0);
menu2[4][5] = new Item('<SPAN class="MENU2">Output Options</SPAN>','features/output_excelapp.aspx.html','',20,0,0);
menu2[4][6] = new Item('<SPAN class="MENU2">Preserving Leading Zeros in Numeric Strings</SPAN>','features/format_leadingzeros.aspx.html','',20,0,0);
menu2[4][7] = new Item('<SPAN class="MENU2">Reading an Existing Spreadsheet</SPAN>','features/read.aspx.html','',20,0,0);
menu2[4][8] = new Item('<SPAN class="MENU2">Modifying an Existing Spreadsheet</SPAN>','features/open.aspx.html','',20,0,0);
menu2[4][9] = new Item('<SPAN class="MENU2">Adding Charts</SPAN>','features/charts.aspx.html','',20,0,0);
menu2[4][10] = new Item('<SPAN class="MENU2">Creating a Complex Chart</SPAN>','features/charts_complex.aspx.html','',20,0,0);
menu2[4][11] = new Item('<SPAN class="MENU2">Creating a PivotTable','features/pivottables.aspx.html','',20,0,0);
menu2[4][12] = new Item('<SPAN class="MENU2">The Range Object</SPAN>','features/range.aspx.html','',20,0,0);
menu2[4][13] = new Item('<SPAN class="MENU2">Page Setup</SPAN>','features/pagesetup.aspx.html','',20,0,0);
menu2[4][14] = new Item('<SPAN class="MENU2">Formatting Headers & Footers</SPAN>','features/headersandfooters.aspx.html','',20,0,0);
menu2[4][15] = new Item('<SPAN class="MENU2">Protecting your Worksheet</SPAN>','features/protecting.aspx.html','',20,0,0);
menu2[4][16] = new Item('<SPAN class="MENU2">Multilingual Support</SPAN>','features/multilingual.aspx.html','',20,0,0);
//menu2[4][17] = new Item('<SPAN class="MENU2">XML Import</SPAN>','features/xmlimport.aspx.html','',20,0,0);
menu2[4][17] = new Item('<SPAN class="MENU2">Passing ExcelApplication to ExcelTemplate</SPAN>','features/apptotemplate.aspx.html','',20,0,0);
//menu2[4][18] = new Item('<SPAN class="MENU2">ExcelApp.Open vs. ExcelTemplate</SPAN>','features/openvstemplate.aspx.html','',20,0,0);


//menu2[5] =  new Array();
//menu2[5][0] = new Menu(true,'<IMG SRC="include/bluearrow.gif">',175,0,200,'#99ADC2','#dddddd','itemBorder','itemText2');
//menu2[5][1] = new Item('<SPAN class="MENU2">What is HotCell Technology?</SPAN>','features/roundtrip_post.aspx.html','',20,0,0);
//menu2[5][2] = new Item('<SPAN class="MENU2">HotCell Upload Example</SPAN>','features/roundtrip_upload.aspx.html','',20,0,0);
//menu2[5][3] = new Item('<SPAN class="MENU2">HotCell Drill-Down Example</SPAN>','features/drilldown.aspx.html','',20,0,0);

menu2[5] =  new Array();
menu2[5][0] = new Menu(true,'<IMG SRC="include/bluearrow.gif">',175,0,250,'#99ADC2','#dddddd','itemBorder','itemText2');
menu2[5][1] = new Item('<SPAN class="MENU2">Object Model</SPAN>','reference/objectmodel.aspx.html','',20,0,0);
menu2[5][2] = new Item('<SPAN class="MENU2">ExcelTemplate</SPAN>','reference/ExcelTemplate.aspx.html','',23,0,9);
	menu2[9] =  new Array();
	menu2[9][0] = new Menu(true,'<img src="include/bluearrow.gif">',245,0,200,'#99ADC2','#dddddd','itemBorder','itemText2');
	menu2[9][1] = new Item('<SPAN class="MENU2">ExcelTemplate Object</SPAN>','reference/exceltemplate.aspx.html','',20,0,0);
	menu2[9][2] = new Item('<SPAN class="MENU2">AnsiToUnicode Method</SPAN>','reference/exceltemplate_com_ansitounicode.aspx.html','',20,0,0);
	menu2[9][3] = new Item('<SPAN class="MENU2">ContentType Property</SPAN>','reference/exceltemplate_com_contenttype.aspx.html','',20,0,0);
	menu2[9][4] = new Item('<SPAN class="MENU2">DecryptPassword Property</SPAN>','reference/exceltemplate_com_DecryptPassword.aspx.html','',20,0,0);
	menu2[9][5] = new Item('<SPAN class="MENU2">EncryptPassword Property</SPAN>','reference/exceltemplate_com_EncryptPassword.aspx.html','',20,0,0);
	menu2[9][6] = new Item('<SPAN class="MENU2">DataSource Property</SPAN>','reference/exceltemplate_com_datasource.aspx.html','',20,0,0);
	menu2[9][7] = new Item('<SPAN class="MENU2">Open Method</SPAN>','reference/exceltemplate_com_open.aspx.html','',20,0,0);
	menu2[9][8] = new Item('<SPAN class="MENU2">PreserveStrings Property</SPAN>','reference/exceltemplate_com_preservestrings.aspx.html','',20,0,0);
	menu2[9][9] = new Item('<SPAN class="MENU2">Process Method</SPAN>','reference/exceltemplate_com_process.aspx.html','',20,0,0);
	menu2[9][10] = new Item('<SPAN class="MENU2">SpreadSheetsCreatedToday Property</SPAN>','reference/exceltemplate_com_spreadsheetscreatedtoday.aspx.html','',33,0,0);
	menu2[9][11] = new Item('<SPAN class="MENU2">UnicodeToAnsi Method</SPAN>','reference/exceltemplate_com_unicodetoansi.aspx.html','',20,0,0);
menu2[5][3] = new Item('<SPAN class="MENU2">ExcelApplication</SPAN>','reference/excelappobj.aspx.html','',23,0,6);
	menu2[6] =  new Array();
	menu2[6][0] = new Menu(true,'<img src="include/bluearrow.gif">',245,0,200,'#99ADC2','#dddddd','itemBorder','itemText2');
	menu2[6][1] = new Item('<SPAN class="MENU2">ExcelApplication Objects</SPAN>','reference/ExcelAppObj_objects.aspx.html','',23,0,10);
		menu2[10] =  new Array();
		menu2[10][0] = new Menu(true,'<img src="include/bluearrow.gif">',195,0,230,'#99ADC2','#dddddd','itemBorder','itemText2');
		menu2[10][1] = new Item('<SPAN class="MENU2">ExcelApplication Object</SPAN>','reference/excelappobj.aspx.html','',20,0,0);
		menu2[10][2] = new Item('<SPAN class="MENU2">3DProperties Object</SPAN>','reference/view3d.aspx.html','',20,0,0);
		menu2[10][3] = new Item('<SPAN class="MENU2">Area Object</SPAN>','reference/area.aspx.html','',20,0,0);
		menu2[10][4] = new Item('<SPAN class="MENU2">Axis Object</SPAN>','reference/axis.aspx.html','',20,0,0);
		menu2[10][5] = new Item('<SPAN class="MENU2">Cells Object</SPAN>','reference/cells.aspx.html','',20,0,0);
		menu2[10][6] = new Item('<SPAN class="MENU2">Cell Object</SPAN>','reference/cell.aspx.html','',20,0,0);
		menu2[10][7] = new Item('<SPAN class="MENU2">Charts Object</SPAN>','reference/charts.aspx.html','',20,0,0);
		menu2[10][8] = new Item('<SPAN class="MENU2">Chart Object</SPAN>','reference/chart.aspx.html','',20,0,0);
		menu2[10][9] = new Item('<SPAN class="MENU2">ChartFrame Object</SPAN>','reference/chartframe.aspx.html','',20,0,0);
		menu2[10][10] = new Item('<SPAN class="MENU2">DataLabels Object</SPAN>','reference/datalabels.aspx.html','',20,0,0);
		menu2[10][11] = new Item('<SPAN class="MENU2">DocumentProperties Object</SPAN>','reference/docproperties.aspx.html','',20,0,0);
		menu2[10][12] = new Item('<SPAN class="MENU2">Font Object</SPAN>','reference/font.aspx.html','',20,0,0);
		menu2[10][13] = new Item('<SPAN class="MENU2">Line Object</SPAN>','reference/line.aspx.html','',20,0,0);
		menu2[10][14] = new Item('<SPAN class="MENU2">PageSetup Object</SPAN>','reference/pagesetup.aspx.html','',20,0,0);
		menu2[10][15] = new Item('<SPAN class="MENU2">Pictures Object</SPAN>','reference/pictures.aspx.html','',20,0,0);
		menu2[10][16] = new Item('<SPAN class="MENU2">Picture Object</SPAN>','reference/picture.aspx.html','',20,0,0);
		menu2[10][17] = new Item('<SPAN class="MENU2">PivotField Object</SPAN>','reference/pivotfield.aspx.html','',20,0,0);		
		menu2[10][18] = new Item('<SPAN class="MENU2">PivotFields Object</SPAN>','reference/pivotfields.aspx.html','',20,0,0);	
		menu2[10][19] = new Item('<SPAN class="MENU2">PivotTable Object</SPAN>','reference/pivottable.aspx.html','',20,0,0);	
		menu2[10][20] = new Item('<SPAN class="MENU2">PivotTables Object</SPAN>','reference/pivottables.aspx.html','',20,0,0);	
		menu2[10][21] = new Item('<SPAN class="MENU2">Range Object</SPAN>','reference/range.aspx.html','',20,0,0);
		menu2[10][22] = new Item('<SPAN class="MENU2">SeriesCollection Object</SPAN>','reference/seriescollection.aspx.html','',20,0,0);
		menu2[10][23] = new Item('<SPAN class="MENU2">Series Object</SPAN>','reference/series.aspx.html','',20,0,0);
		menu2[10][24] = new Item('<SPAN class="MENU2">Style Object</SPAN>','reference/style.aspx.html','',20,0,0);
		menu2[10][25] = new Item('<SPAN class="MENU2">Worksheets Object</SPAN>','reference/worksheets.aspx.html','',20,0,0);
		menu2[10][26] = new Item('<SPAN class="MENU2">Worksheet Object</SPAN>','reference/worksheet.aspx.html','',20,0,0);
	menu2[6][2] = new Item('<SPAN class="MENU2">ExcelApplication Methods</SPAN>','reference/ExcelAppObj_methods.aspx.html','',23,0,11);
		menu2[11] =  new Array();
		menu2[11][0] = new Menu(true,'<img src="include/bluearrow.gif">',195,0,230,'#99ADC2','#dddddd','itemBorder','itemText2');
		menu2[11][1] = new Item('<SPAN class="MENU2">AnsiToUnicode Method</SPAN>','reference/excelappobj_ansitounicode.aspx.html','',20,0,0);
		menu2[11][2] = new Item('<SPAN class="MENU2">CreateFont Method</SPAN>','reference/excelappobj_createfont.aspx.html','',20,0,0);
		menu2[11][3] = new Item('<SPAN class="MENU2">CreateStyle Method</SPAN>','reference/excelappobj_createstyle.aspx.html','',20,0,0);
		menu2[11][4] = new Item('<SPAN class="MENU2">NamedRange Method</SPAN>','reference/excelappobj_namedrange.aspx.html','',20,0,0);
		menu2[11][5] = new Item('<SPAN class="MENU2">Open Method</SPAN>','reference/excelappobj_open.aspx.html','',20,0,0);
		menu2[11][6] = new Item('<SPAN class="MENU2">Save Method</SPAN>','reference/excelappobj_save.aspx.html','',20,0,0);
		menu2[11][7] = new Item('<SPAN class="MENU2">UnicodeToAnsi Method</SPAN>','reference/excelappobj_UnicodeToAnsi.aspx.html','',20,0,0);
	menu2[6][3] = new Item('<SPAN class="MENU2">ExcelApplication Properties</SPAN>','reference/ExcelAppObj_properties.aspx.html','',23,0,12);
		menu2[12] =  new Array();
		menu2[12][0] = new Menu(true,'<img src="include/bluearrow.gif">',195,0,230,'#99ADC2','#dddddd','itemBorder','itemText2');
		menu2[12][1] = new Item('<SPAN class="MENU2">ContentType Property</SPAN>','reference/excelappobj_ContentType.aspx.html','',20,0,0);
		menu2[12][2] = new Item('<SPAN class="MENU2">ShowHScrollBar Property</SPAN>','reference/excelappobj_ShowHScrollBar.aspx.html','',20,0,0);
		menu2[12][3] = new Item('<SPAN class="MENU2">ShowVScrollBar Property</SPAN>','reference/excelappobj_ShowVScrollBar.aspx.html','',20,0,0);		
		menu2[12][4] = new Item('<SPAN class="MENU2">SpreadsheetsCreatedToday Property</SPAN>','reference/excelappobj_SpreadsheetsCreatedToday.aspx.html','',20,0,0);
		menu2[12][5] = new Item('<SPAN class="MENU2">Style Property</SPAN>','reference/excelappobj_Style.aspx.html','',20,0,0);
		menu2[12][6] = new Item('<SPAN class="MENU2">Version Property</SPAN>','reference/excelappobj_Version.aspx.html','',20,0,0);
		menu2[12][7] = new Item('<SPAN class="MENU2">VersionEX Property</SPAN>','reference/excelappobj_VersionEX.aspx.html','',20,0,0);
		menu2[12][8] = new Item('<SPAN class="MENU2">Worksheets Property</SPAN>','reference/excelappobj_Worksheets.aspx.html','',20,0,0);
	menu2[6][4] = new Item('<SPAN class="MENU2">Functions</SPAN>','reference/functions.aspx.html','',20,0,0);
	menu2[6][5] = new Item('<SPAN class="MENU2">Formula Calculation Operators</SPAN>','reference/operators.aspx.html','',20,0,0);
	menu2[6][6] = new Item('<SPAN class="MENU2">Formatting Codes</SPAN>','reference/formatting.aspx.html','',20,0,0);
	menu2[6][7] = new Item('<SPAN class="MENU2">Chart Codes</SPAN>','reference/chartcodes.aspx.html','',20,0,0);
	menu2[6][8] = new Item('<SPAN class="MENU2">PivotTable AutoFormat Types</SPAN>','reference/AutoFormatPivotTable.aspx.html','',20,0,0);

menu2[7] =  new Array();
menu2[7][0] = new Menu(true,'<IMG SRC="include/bluearrow.gif">',175,0,220,'#99ADC2','#dddddd','itemBorder','itemText2');
menu2[7][1] = new Item('<SPAN class="MENU2">Installing ExcelWriter</SPAN>','install/install_asp.aspx.html','',20,0,0);
menu2[7][2] = new Item('<SPAN class="MENU2">Removing ExcelWriter</SPAN>','install/remove.aspx.html','',20,0,0);
menu2[7][3] = new Item('<SPAN class="MENU2">Configuring IIS</SPAN>','install/configuringiis.aspx.html','',20,0,0);
menu2[7][4] = new Item('<SPAN class="MENU2">LockedFileRetry Parameter&nbsp;&nbsp;</SPAN>','install/registry.aspx.html','',20,0,0);
menu2[7][5] = new Item('<SPAN class="MENU2">Security Considerations</SPAN>','install/security.aspx.html','',20,0,0);

menu2[8] =  new Array();
menu2[8][0] = new Menu(true,'<IMG SRC="include/bluearrow.gif">',175,0,220,'#99ADC2','#dddddd','itemBorder','');
menu2[8][1] = new Item('<SPAN class="MENU2"><img src="include/weblink.gif">&nbsp;OfficeWriter Online</SPAN>','http://officewriter.softartisans.com/','new',20,0,0);
menu2[8][2] = new Item('<SPAN class="MENU2"><img src="include/weblink.gif">&nbsp;SoftArtisans Forums</SPAN>','http://support.softartisans.com/Forums/ShowForum.aspx.html?ForumID=12','new',20,0,0);
menu2[8][3] = new Item('<SPAN class="MENU2"><img src="include/weblink.gif">&nbsp;SoftArtisans Technical Services</SPAN>','http://support.softartisans.com/','new',20,0,0);
menu2[8][4] = new Item('<SPAN class="MENU2"><img src="include/weblink.gif">&nbsp;SoftArtisans</SPAN>','http://www.softartisans.com/','new',20,0,0);
menu2[8][5] = new Item('<SPAN class="MENU2"><img src="include/mail.bmp">&nbsp;General Questions</SPAN>','mailto:info@softartisans.com','',20,0,0);
menu2[8][6] = new Item('<SPAN class="MENU2">Legal Information</SPAN>','legal_information.aspx.html','',20,0,0);


registerMenu(menu2);