Human Emulator wiki

export_to_csv

export_to_csv($file_path,$number,$rows="",$cols="",$as_html=true,$separator=";",$frame=-1); - export a table with the specified number or part of it to a csv file

$file_path – path to the file. The path to the file can be full (with the disk specified) so the relative path will be added to the folder where the php file of the running script is located.

$number – the number by which we find the element we need on the page (int) . Element numbers start with 0 and different types of elements have their own numbering.To find out the item number, you can use either the item inspector or the context menu, or view it in the list of items.

$rows – specifies which rows to perform the action with (string). Strings are passed as text with comma - separated line numbers. Line numbering starts from zero. By default, "" (all rows in the table) .

$cols – specifies which columns to perform the action with (string). Columns are passed as text with column numbers separated by commas. Column numbering starts from zero. By default, "" (all rows in the table) .

$as_html – save cell text as html (true), otherwise as their internal text (false)

$separator – column separator in csv file, by default ';'

$frame – the number of the frame in which we are looking for the element (string). Frame numbers start from zero. By default, -1 - the element is not in the frame. You can find out the number of the frame that contains the item you need from the task inspector, the context menu, and the item list panel.
With version 4.6.41 of postpone: you can pass nested frames, the principle is the same, a string is numbered frames separated by : for example, if you transfer "1:0:5" - will the selected frame number 1 in it under the frame with the number 0 and the subframe number 5
Since version 7.0.38, you can pass "url=>XXX", then search for the frame that contains the specified src, or pass "name=>XXX" - then the frame will be searched by the specified part of the name.

After the function returns the result of their work in the script (the return value type is boolean):

true – executed successfully

false to find this element failed (e.g. no items that meet the specified criteria or not this frame)

PHP example:

<?php $xhe_host = "127.0.0.1:7014";
 
//connect the object to control the emulator, if not already connected
if(!isset($path))
  $path = "../../../Templates/xweb_human_emulator.php";
require($path);
 
//Start
echo "<hr> <font color = blue> table->".basename(__FILE__)."</font> <hr>";
 
//1
echo "1.Let's go to the polygon:";
echo $browser->navigate("http://humanemulator.net/poligon/table.html")."<br>";
 
//2
echo "2.Export the entire table with 0 number to csv as html:";
echo $table->export_to_csv("c: \ 1.csv", 0)."<br>";
$app->shell_execute("open", "c: \ 1.csv", "", "c: \", true);
 
//3
echo "3.Export cells(1: 1)(2: 3)(6: 2) table with 0 number to csv as text:";
echo $table->export_to_csv("c: \ 2.csv", 0, "1,2,6", "1,3,2", false)."<br>";
$app->shell_execute("open", "c: \ 2.csv", "", "c: \", false);
 
//4
echo "3.Export non-existent table to csv:";
if($table->export_to_csv("c: \ 0.csv", 100500, "", "", false))
echo "no such element <br>";
 
//five
echo "5.Export the entire table with 0 number to csv as html in frame zero:";
echo $table->export_to_csv("c: \ 3.csv", 0, "", "", true, ";", 0)."<br>";
$app->shell_execute("open", "c: \ 3.csv", "", "c: \", true);
 
//6
echo "6.Export non-existent table to csv in zero frame:";
if($table->export_to_csv("c: \ 0.csv", 100500, "", "", false, ";", 0))
echo "no such element <br>";
 
//7
echo "7.Export table to csv in a non-existent frame:";
if($table->export_to_csv("c: \ 0.csv", 0, "", "", false, ";", 5))
echo "no such frame <br>";
 
//end
echo "<hr> <br>";
 
//Quit
$app->quit();
?>

Python example:

# Additional paths
import sys
sys.path.insert(0, '../../../Templates PY/')
 
xhe_host = "127.0.0.1:7011"
from xweb_human_emulator import *
 
# Start
echo("<hr> <font color = blue> table.xxxxxxxxx </font> <hr>")
 
# 1
echo("1.Let's go to the polygon:")
echo(browser.navigate("http://www.humanemulator.net/poligon/table.html"), "<br>")
 
# 2
echo("2.Export the entire table with 0 number to csv as html:")
echo(table.export_to_csv("c: \ 1.csv", 0), "<br>")
app.shell_execute("open", "c: \ 1.csv", "", "c: \", true)
 
# 3
echo("3.Export cells(1: 1)(2: 3)(6: 2) table with 0 number in csv as text:")
echo(table.export_to_csv("c: \ 2.csv", 0, "1,2,6", "1,3,2", false), "<br>")
app.shell_execute("open", "c: \ 2.csv", "", "c: \", true)
 
# 4
echo("3.Export non-existent table to csv:")
if not table.export_to_csv("c: \ 0.csv", 100500, "", "", false):
echo("no such item <br>")
 
# five
echo("5.Export the entire table with 0 number to csv as html in zero frame:")
echo(table.export_to_csv("c: \ 3.csv", 0, "", "", true, ")", 0), "<br>")
app.shell_execute("open", "c: \ 3.csv", "", "c: \", true)
 
# 6
echo("6.Export nonexistent table to csv in zero frame:")
if not table.export_to_csv("c: \ 0.csv", 100500, "", "", false, ")", 0):
echo("no such item <br>")
 
# 7
echo("7.Export table to csv in a nonexistent frame:")
if not table.export_to_csv("c: \ 0.csv", 0, "", "", false, ")", 5):
echo("no such frame <br>")
 
# end
echo("<hr> <br>")
 
# Quit
app.quit()

C# example:

#region using
 
using System;
using System.Diagnostics;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Text;
using System.Threading;
 
using XHE;
using XHE.XHE_DOM;
using XHE.XHE_System;
using XHE.XHE_Window;
using XHE.XHE_Web;
 
#endregion
 
 class Program: XHEScript
 {
static void Main(string [] args)
{
//init XHE
server = "127.0.0.1:7010";
InitXHE();
 
//Start
echo("<hr> <font color = blue> table.export_to_csv </font> <hr>");
 
//1 step
echo("1.Let's go to the polygon:");
echo(browser.navigate("www.humanemulator.net/poligon/table.html") + "<br>");
 
//step 2
echo("2.Export the entire table with 0 number to csv as html:");
echo(table.export_to_csv("c: \ 1.csv", 0) + "<br>");
app.shell_execute("open", "c: \ 1.csv", "", "c: \", 1);
 
//step 3
echo("3.Export cells(1: 1)(2: 3)(6: 2) table with 0 number in csv as text:");
echo(table.export_to_csv("c: \ 2.csv", 0, "1,2,6", "1,3,2", false) + "<br>");
app.shell_execute("open", "c: \ 2.csv", "", "c: \", 1);
 
 
//step 4
echo("3.Export a nonexistent table to csv:");
if(!table.export_to_csv("c: \ 0.csv", 100500, "", "", true))
echo("no such element <br>");
 
//step 5
echo("5.Export the entire table with 0 number to csv as html in a zero frame:");
echo(table.export_to_csv("c: \ 3.csv", 0, "", "", true, ";", "0") + "<br>");
app.shell_execute("open", "c: \ 3.csv", "", "c: \", 1);
 
//6 step
echo("6.Exporting a nonexistent table to csv in a zero frame:");
if(!table.export_to_csv("c: \ 0.csv", 100500, "", "", false, ",", "0"))
echo("no such element <br>");
 
//step 7
echo("7.Export table to csv in a non-existent frame:");
if(!table.export_to_csv("c: \ 0.csv", 0, "", "", false, ",", "5"))
echo("no such frame <br>");
 
//end
echo("<hr> <br>");
 
app.quit();
}
}

Java Script example:

//connect the object to control the emulator, if not already connected
xhe_host = "127.0.0.1:7010";
echo = require("../../../Templates JS/xweb_human_emulator.js");
 
//Start
echo("<hr> <font color = blue> table.export_to_csv </font> <hr>");
 
//1 step
echo("1.Let's go to the polygon:");
echo(browser.navigate("http://www.humanemulator.net/poligon/table.html") + "<br>");
 
//step 2
echo("2.Export the entire table with 0 number to csv as html:");
echo(table.export_to_csv("c: \ 1.csv", 0) + "<br>");
app.shell_execute("open", "c: \ 1.csv", "", "c: \", true);
 
//step 3
echo("3.Export cells(1: 1)(2: 3)(6: 2) table with 0 number in csv as text:");
echo(table.export_to_csv("c: \ 2.csv", 0, "1,2,6", "1,3,2", false) + "<br>");
app.shell_execute("open", "c: \ 2.csv", "", "c: \", false);
 
//step 4
echo("4.Export non-existent table to csv:");
if(!table.export_to_csv("c: \ 0.csv", 100500, "", "", false))
echo("no such element <br>");
 
//step 5
echo("5.Export the entire table with 0 number to csv as html in a zero frame:");
echo(table.export_to_csv("c: \ 3.csv", 0, "", "", true, ");", 0) + "<br>");
app.shell_execute("open", "c: \ 3.csv", "", "c: \", true);
 
//step 6
echo("6.Exporting a nonexistent table to csv in a zero frame:");
if(!table.export_to_csv("c: \ 0.csv", 100500, "", "", false, ");", 0))
echo("no such element <br>");
 
//step 7
echo("7.Export table to csv in a non-existent frame:");
if(!table.export_to_csv("c: \ 0.csv", 0, "", "", false, ");", 5))
echo("no such frame <br>");
 
//end
echo("<hr> <br>");
 
//Quit
app.quit();

Human Emulator wiki

User Tools

Site Tools

Sidebar

export_to_csv

Page Tools