-
Notifications
You must be signed in to change notification settings - Fork 137
/
Copy pathPrintingXLSSample.js
205 lines (187 loc) · 10.2 KB
/
PrintingXLSSample.js
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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
class PrintingXLSSample extends React.Component {
constructor(props) {
super(props);
this.state = {
xlsFile: null,
installedPrinters: [],
printerName: "",
pageFrom: 0,
pageTo: 0
};
}
setXlsFile(event) {
if (event.target.name == "input-local-xls-file") this.state.xlsFile = Array.from(event.target.files);
else this.state.xlsFile = [event.target.value];
}
setInstalledPrinters(printersList) {
this.setState({ installedPrinters: printersList });
this.state.printerName = printersList[0];
}
setData(event) {
this.state[event.target.name] = event.target.checked ? event.target.checked : event.target.value;
}
createPrintJob() {
let cpj = new JSPM.ClientPrintJob();
cpj.clientPrinter = new JSPM.InstalledPrinter(this.state.printerName, false, null, null);
if (this.state.xlsFile) {
let myXlsFile;
if (this.state.xlsFile[0].name) myXlsFile = new JSPM.PrintFileXLS(this.state.xlsFile[0], JSPM.FileSourceType.BLOB, this.state.xlsFile[0].name, 1);
else myXlsFile = new JSPM.PrintFileXLS(this.state.xlsFile[0], JSPM.FileSourceType.ExternalURL, "myFileToPrint.xls", 1);
myXlsFile.pageFrom = parseInt(this.state.pageFrom);
myXlsFile.pageTo = parseInt(this.state.pageTo);
cpj.files.push(myXlsFile);
}
return cpj;
}
doPrinting() {
let cpj = this.createPrintJob();
if (cpj) {
cpj.sendToClient();
}
}
componentDidMount() {
JSPM.JSPrintManager.Caller = this;
//get client installed printers
JSPM.JSPrintManager.getPrinters().then(function(printersList) {
JSPM.JSPrintManager.Caller.setInstalledPrinters(printersList);
});
}
render() {
let demoContent;
if (this.props.os == "win") {
if (this.state.installedPrinters.length == 0) {
demoContent = (
<div className="row">
<div className="col-md-12">
<div className="text-center">
<img src="loading.gif" id="loadingPrintersInfo" />
<br />
<strong>Getting printers...</strong>
</div>
</div>
</div>
);
} else {
demoContent = (
<div className="row">
<div className="col-md-12">
<div className="form-group">
<div className="row">
<div className="col-md-12">
<strong>XLS File to print</strong>
<ul className="nav nav-tabs" id="myTabXls" role="tablist">
<li className="nav-item">
<a className="nav-link active" id="local-xls-file-tab" data-toggle="tab" href="#local-xls-file" role="tab" aria-controls="local-xls-file" aria-selected="true">
Local XLS File
</a>
</li>
<li className="nav-item">
<a className="nav-link" id="remote-xls-file-tab" data-toggle="tab" href="#remote-xls-file" role="tab" aria-controls="remote-xls-file" aria-selected="false">
XLS File from URL
</a>
</li>
</ul>
<div className="tab-content" id="myTabXlsContent">
<div className="tab-pane fade show active" id="local-xls-file" role="tabpanel" aria-labelledby="local-xls-file">
<br />
<input name="input-local-xls-file" type="file" className="form-control-file" onChange={this.setXlsFile.bind(this)} />
</div>
<div className="tab-pane fade" id="remote-xls-file" role="tabpanel" aria-labelledby="remote-xls-file">
<br />
URL for XLS File{" "}
<small>
(e.g.{" "}
<a href="https://neodynamic.com/temp/Project-Scheduling-Monitoring-Tool.xls" target="_blank">
https://neodynamic.com/temp/Project-Scheduling-Monitoring-Tool.xls
</a>)
</small>
<input name="input-file-url" className="form-control form-control-sm" onChange={this.setXlsFile.bind(this)} />
</div>
<br />
</div>
</div>
</div>
<div className="row">
<div className="col-md-12">
<br />
<div className="alert alert-info">
<strong>Target Printer</strong>
</div>
</div>
</div>
<div className="row">
<div className="col-md-4">
<label>Printer:</label>
<select name="printerName" className="form-control form-control-sm" onChange={this.setData.bind(this)}>
{this.state.installedPrinters.map(function(i) {
let opt = (
<option key={i} value={i}>
{i}
</option>
);
return opt;
})}
</select>
</div>
<div className="col-md-4">
<label>Page From:</label>
<input type="text" className="form-control form-control-sm" name="pageFrom" onChange={this.setData.bind(this)} />
</div>
<div className="col-md-4">
<label>Page To:</label>
<input type="text" className="form-control form-control-sm" name="pageTo" onChange={this.setData.bind(this)} />
</div>
</div>
<div className="row">
<div className="col-md-12">
<br />
<div className="text-center">
<button className="btn btn-success btn-lg" onClick={this.doPrinting.bind(this)}>
<i className="fa fa-print" /> Print XLS Now...
</button>
</div>
</div>
</div>
</div>
</div>
</div>
);
}
}
return (
<div>
<div className="row">
<div className="col-md-1">
<button className="btn btn-dark btn-lg" onClick={() => this.props.setSample(0)}>
<i className="fa fa-arrow-left" />
</button>
</div>
<div className="col-md-11">
<h2 className="text-center">
<i className="fa fa-file-excel-o" /> Advanced XLS Printing
</h2>
<hr />
<div className="alert alert-warning">
<small>
<strong>Requirements:</strong>
<ul>
<li>
Available for <strong>Windows clients only</strong>
</li>
<li>
<strong>Microsoft Excel 97+</strong> must be installed at the client machine
</li>
<li>
XLS files can be any of these file formats: <strong>*.xl, *.xlsx, *.xlsm, *.xlsb, *.xlam, *.xltx, *.xltm, *.xls, *.xla, *.xlt, *.xlm, *.xlw and *.ods</strong>
</li>
</ul>
</small>
</div>
</div>
</div>
{demoContent}
</div>
);
}
}
window.PrintingXLSSample = PrintingXLSSample;