Initialization Error: ".$errmsg."
"); } // Grab the test Word data. // $sPage = ""; $errmsg = SOWord( "127.0.0.1:7777", "path3", "momentum-fischer-pumps.doc", $sPage, "percy", "percy" ); if (strlen($errmsg)) { echo("SOWord Error: ".$errmsg."
"); } else { echo("Word data: ".$sPage."
"); } // Try to grab Excel data with bad credentials (username/password). // $errmsg = SOExcel( "127.0.0.1:7777", "path3", "ITS_Sales_Funnel___May_12.xls", 1, $arrayExcelData, "A1", "K35", "percy", "not-the-right-password" ); if (strlen($errmsg)) { echo("SOExcel Error: ".$errmsg."
"); } // Grab the test Excel data. // $errmsg = SOExcel( "127.0.0.1:7777", "path3", "ITS_Sales_Funnel___May_12.xls", 1, $arrayExcelData, "A1", "K35", "percy", "percy" ); if (strlen($errmsg)) { echo("SOExcel Error: ".$errmsg."
"); } else { echo("Cell A3: ".$arrayExcelData["A3"]."
"); echo("Cell D17: ".$arrayExcelData["D17"]."
"); } // Update Excel data. // $errmsg = SOExcelUpdate("127.0.0.1:7777", "path3", "beautyJungleRevenue.xls", 1, "F3", "1-14-1961", "D", "percy", "percy"); if (strlen($errmsg)) { echo("SOExcelUpdate Error: ".$errmsg."
"); } else { echo("No error reported updating Excel
"); } // Grab the test Access data. // $errmsg = SOAccess("127.0.0.1:7777", "path11", "mlb2000.mdb", "Batters 200 Hits", $arrayAccessData, 0, 100, "percy", "percy" ); if (strlen($errmsg)) { echo("SOAccess Error: ".$errmsg."
"); } else { echo("Row 3 Firstname: ".$arrayAccessData[3]["firstname"]."
"); echo("Row 9 Year: ".$arrayAccessData[9]["year"]."
"); echo("Row 21 Expr1: ".$arrayAccessData[21]["expr1"]."
"); echo("Row 99 lastname: ".$arrayAccessData[99]["lastname"]."
"); echo("Row 99 hr: ".$arrayAccessData[99]["hr"]."
"); echo("Row 99 rbi: ".$arrayAccessData[99]["rbi"]."
"); } } while (0); ?>