-
Notifications
You must be signed in to change notification settings - Fork 10
/
Copy pathxlsx2csv.1.html
101 lines (99 loc) · 2.95 KB
/
xlsx2csv.1.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
<!DOCTYPE html>
<html>
<head>
<title>Caltech Library's Digital Library Development Sandbox</title>
<link href='https://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="/css/site.css">
</head>
<body>
<header>
<a href="http://library.caltech.edu"><img src="/assets/liblogo.gif" alt="Caltech Library logo"></a>
</header>
<nav>
<ul>
<li><a href="/">Home</a></li>
<li><a href="./">README</a></li>
<li><a href="LICENSE">LICENSE</a></li>
<li><a href="INSTALL.html">INSTALL</a></li>
<li><a href="user-manual.html">User Manual</a></li>
<li><a href="how-to/">Tutorials</a></li>
<li><a href="search.html">Search Docs</a></li>
<li><a href="about.html">About</a></li>
<li><a href="https://github.com/caltechlibrary/datatools">GitHub</a></li>
</ul>
</nav>
<section>
<h1 id="name">NAME</h1>
<p>xlsx2csv</p>
<h1 id="synopsis">SYNOPSIS</h1>
<p>xlsx2csv <a href="#options">OPTIONS</a> EXCEL_WORKBOOK_NAME
[SHEET_NAME]</p>
<h1 id="description">DESCRIPTION</h1>
<p>xlsx2csv is a tool that converts individual Excel Sheets to CSV
output.</p>
<h1 id="options">OPTIONS</h1>
<dl>
<dt>-help</dt>
<dd>
display help
</dd>
<dt>-license</dt>
<dd>
display license
</dd>
<dt>-version</dt>
<dd>
display version
</dd>
<dt>-N, -sheets</dt>
<dd>
display the Workbook sheet names
</dd>
<dt>-c, -count</dt>
<dd>
display number of Workbook sheets
</dd>
<dt>-nl, -newline</dt>
<dd>
add a trailing newline to the end of file (EOF)
</dd>
<dt>-crlf</dt>
<dd>
use CRLF for end of line (EOL). On Windows this option is the default.
Set to false to use a LF on Windows. On other OS LF is the default.
</dd>
<dt>-o, -output</dt>
<dd>
output filename
</dd>
<dt>-quiet</dt>
<dd>
suppress error messages
</dd>
</dl>
<h1 id="examples">EXAMPLES</h1>
<p>Extract a workbook sheet as a CSV file</p>
<pre><code> xlsx2csv MyWorkbook.xlsx "My worksheet 1" > sheet1.csv</code></pre>
<p>This would get the first sheet from the workbook and save it as a CSV
file.</p>
<pre><code> xlsx2csv -count MyWorkbook.xlsx</code></pre>
<p>This will output the number of sheets in the Workbook.</p>
<pre><code> xlsx2csv -sheets MyWorkbook.xlsx</code></pre>
<p>This will display a list of sheet names, one per line. Putting it all
together in a shell script.</p>
<pre><code> xlsx2csv -N MyWorkbook.xlsx | while read SHEET_NAME; do
CSV_NAME="${SHEET_NAME// /-}.csv"
xlsx2csv -o "${CSV_NAME}" MyWorkbook.xlsx "${SHEET_NAME}"
done</code></pre>
<p>xlsx2csv 1.3.1</p>
</section>
<footer>
<span><h1><A href="http://caltech.edu">Caltech</a></h1></span>
<span>© 2023 <a href="https://www.library.caltech.edu/copyright">Caltech library</a></span>
<address>1200 E California Blvd, Mail Code 1-32, Pasadena, CA 91125-3200</address>
<span>Phone: <a href="tel:+1-626-395-3405">(626)395-3405</a></span>
<span><a href="mailto:[email protected]">Email Us</a></span>
<a class="cl-hide" href="sitemap.xml">Site Map</a>
</footer>
</body>
</html>