forked from xkdcc/RemoteExcelMgt
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathRemoteExcelMgt.html
128 lines (79 loc) · 3.46 KB
/
RemoteExcelMgt.html
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
116
117
118
119
120
121
122
123
124
125
126
<?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">
<ul id="index">
<li><a href="#RemoteExcelMgt.pl">RemoteExcelMgt.pl</a>
<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="#SEE-ALSO">SEE ALSO</a></li>
<li><a href="#VERSION_INFOR">VERSION_INFOR</a></li>
<li><a href="#Comments-in-Code">Comments in Code</a>
<ul>
<li><a href="#A-proper-way-of-using-Perl-custom-modules-inside-of-other-Perl-modules">A proper way of using Perl custom modules inside of other Perl modules</a></li>
</ul>
</li>
</ul>
</li>
</ul>
<h1 id="RemoteExcelMgt.pl">RemoteExcelMgt.pl</h1>
<h2 id="COPYRIGHT">COPYRIGHT</h2>
<p>Copyright 2012 - 2013 Brant Chen ([email protected]), All Rights Reserved</p>
<h2 id="SYNOPSIS">SYNOPSIS</h2>
<p>Update team's ml.xls on ftp server remotely.</p>
<h2 id="DESCRIPTION">DESCRIPTION</h2>
1. FTP to remote system, write down modified date/time.</br>
2. Download the specified Excel.</br>
3. Modify it by specified line.</br>
4. Export this Excel file to a local html copy.</br>
5. Check remote Excel file's modfied date/time:</br>
<1> If remote one's time is older, update local copy (Excel
and html) to overwrite the remote ones.</br>
<2> If remote one's time is newer, give warning and choice.</br>
<h2 id="USAGE">USAGE</h2>
<pre>This perl script will provide a CMD MENU.</pre>
<h2 id="REQUIREMENTS">REQUIREMENTS</h2>
<p>Need Spreadsheet::ParseExcel, Spreadsheet::WriteExcel</p>
<h2 id="BUGS">BUGS</h2>
<B>N/A</B>
<h2 id="NOTES">NOTES</h2>
<table border=0>
<tr> <td width=626 valign=top style='width:469.8pt;border:solid #FFD966 1.0pt;background:#FFF2CC;'> <p>
<pre>
Notes here.
Q1: Why we seperate "Download files by FTP" and "Upload files to FTP" to two menu items?
A1: Because this script is used to download Excel files at first, then you make your modifications locally, then
upload your local modified copy to overwrite the ones on FTP servers. So we don't have need to bundle "Downlaod"
and "upload" in a menu item.
</pre>
</p> </td> </tr>
</table>
<h2 id="AUTHOR">AUTHOR</h2>
<B>Author:</B>         Brant Chen ([email protected]) </br>
<B>Organization: </B>  </br>
<h2 id="SEE-ALSO">SEE ALSO</h2>
<h2 id="VERSION_INFOR">VERSION_INFOR</h2>
<B>Version:</B>   1.0 </br>
<B>Created:</B>   2013-4-27 13:17:27 </br>
<B>Revision:</B>  1.0 </br>
<h2 id="Comments-in-Code">Comments in Code</h2>
<h3 id="A-proper-way-of-using-Perl-custom-modules-inside-of-other-Perl-modules">A proper way of using Perl custom modules inside of other Perl modules</h3>
<p>
Refer to <a href=http://stackoverflow.com/questions/11687018/a-proper-way-of-using-perl-custom-modules-inside-of-other-perl-modules>here</href>.
</p>
</br>
</br>
</body>
</html>