RemoteExcelMgt/pod.html at master · xkdcc/RemoteExcelMgt · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>RemoteExcelMgt</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rev="made" href="mailto:" />
</head>

<body style="background-color: white">


<!-- INDEX BEGIN -->
<div name="index">
<p><a name="__index__"></a></p>

<ul>

	<li><a href="#remoteexcelmgt_pl">RemoteExcelMgt.pl</a></li>
	<ul>

		<li><a href="#copyright">COPYRIGHT</a></li>
		<li><a href="#synopsis">SYNOPSIS</a></li>
		<li><a href="#description">DESCRIPTION</a></li>
		<li><a href="#usage">USAGE</a></li>
		<li><a href="#requirements">REQUIREMENTS</a></li>
		<li><a href="#bugs">BUGS</a></li>
		<li><a href="#notes">NOTES</a></li>
		<li><a href="#author">AUTHOR</a></li>
		<li><a href="#version_infor">VERSION_INFOR</a></li>
	</ul>

</ul>

<hr name="index" />
</div>
<!-- INDEX END -->

<p>
</p>
<hr />
<h1><a name="remoteexcelmgt_pl">RemoteExcelMgt.pl</a></h1>
<p>
</p>
<h2><a name="copyright">COPYRIGHT</a></h2>
<p>Copyright 2012 - 2013 Brant Chen (<a href="mailto:xkdcc@163.com">xkdcc@163.com</a>), All Rights Reserved</p>
<p>
</p>
<h2><a name="synopsis">SYNOPSIS</a></h2>
<p>To remote update NBU G11N team's LOC_Machines_List.xls.</p>
<p>
</p>
<h2><a name="description">DESCRIPTION</a></h2>
<pre>
1. Telnet to remote system, write down modified date/time.
2. Download the specified Excel.
3. Modify it by specified line.
4. Export this Excel file to a html.
5. Check remote Excel file's modfied date/time:
   <1> If remote one's time is older, update local copy (Excel
       and html) to overwrite the remote ones.
   <2> If remote one's time is newer, give warning and choice.
</pre><p>
</p>
<h2><a name="usage">USAGE</a></h2>
<pre>
USAGE:        ~ -re <Excel file remote path>  -t <sheet name> -n <line number, line number, ...> -o [output file]
              ~ -le <local Excel file path>   -i [input file]
              ~ -u -u1 <Excel file remote path> -u2 <Html file remote path>

OPTIONS:      -o: Output the specified line by only two cols to output txt file.
              -i: Update the input file to the local Excle file by specified line;
                  then generate html of this Excel file.
              -u: Sync up local html and Excle file to remote.
</pre><p>
</p>
<h2><a name="requirements">REQUIREMENTS</a></h2>
N/A<p>
</p>
<h2><a name="bugs">BUGS</a></h2>
<B>N/A</B><p>
</p>
<h2><a name="notes">NOTES</a></h2>
<table border=0>
 <tr>  <td width=626 valign=top style='width:469.8pt;border:solid #FFD966 1.0pt;background:#FFF2CC;'>   <p>
<pre>
1. Input File Format:
              [tab name]
              [line 1]
              [col 1]
              Content Content
              [col 2]
              Content Content
              ...
              [tab name]
              [line 1]
              [col 1]
              Content Content
              [col 2]
              Content Content
</pre>
 </p>  </td> </tr>
</table><p>
</p>
<h2><a name="author">AUTHOR</a></h2>
<B>Author:</B>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp Brant Chen (xkdcc@163.com) </br>
<B>Organization: </B>&nbsp     </br><p>
</p>
<h2><a name="version_infor">VERSION_INFOR</a></h2>
<B>Version:</B>&nbsp&nbsp 1.0                     </br>
<B>Created:</B>&nbsp&nbsp 2013-4-27 13:17:27 </br>
<B>Revision:</B>&nbsp 1.0                         </br>
</body>

</html>