-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathREADME
187 lines (110 loc) · 5.02 KB
/
README
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
Cellect
Helps you select data in tables the same way you select cells in a
spreadsheet.
It's:
o [A JavaScript][1] you can install in your web page,
o [A bookmarklet][2] you can run on any page,
o A Greasemonkey [user script][3] and a [Chrome extension][4].
1. Script
There are two versions of the script, one that depends on jQuery
and the other that doesn't:
o [jQuery version][1].
o [Non-jQuery version][3].
The jQuery version supports more browsers, whereas the non-jQuery
version adds less code to each page and is easier to distribute as
a Chrome extension. The non-jQuery version invokes web standards
directly and supports Firefox and Chrome. It works well as a
bookmarklet or a user script where, once installed, cross-browser
support isn't an issue.
It's also available as a [a jQuery plugin].
2. Bookmarklet
Bookmark one of these two versions, or drag it to your bookmarks
toolbar:
o jQuery version: [Select tables][2]
o Non-jQuery version: [Select tables][5]
3. Greasemonkey
Here is [a user script][3] for [Greasemonkey][6] or Chrome.
Install the Greasemonkey [Firefox extension][6], then [install the
script][3].
Chrome supports user scripts out of the box, but recent versions
will [only allow you] to install them from [the Chrome Web
Store][4] by default.
You can also [get the script] from Userscripts.org.
4. GitHub
Fork me [on GitHub].
5. Features
o Shift click to extend the selection.
o Double click to select rows, columns, or a whole table.
Currently this is a [minimum product], hopefully it's viable. No
work has been done on interaction with colspans or rowspans, or
interaction with nested tables.
It doesn't work with PDF documents, but here is a [very cool
project] that does.
In future it might:
o Support using arrow keys to extend the selection, the way you
might expect.
o Support control click to select irregular regions.
o Enable other scripts to add behavior when cells in specialized
tables are selected.
6. Why?
[CRUD] webapps are frequently built for jobs that users previously
addressed with spreadsheets. Despite the advantages of webapps,
venerable spreadsheets still deliver great features and user
experience. Hopefully this script improves integration between web
pages and spreadsheets. With it you should be able to scrape or
export any table on the web.
There are also a lot of other great tools to integrate spreadsheet
features with webapps:
o [DataTables]
o [Handsontable]
o [jTable]
o [jqGrid]
o [jui_datagrid]
o [ParamQuery]
o [SlickGrid]
o [table2csv]
And there is at least one Firefox extension to enhance tables on
any web page: [TableTools2]. And Firefox lets you select tables
out of the box, by holding down the control key.
There are also web-based spreadsheets like [Google Spreadsheet] and
[SocialCalc].
Hopefully even more data will get shared in the form of tables.
[1] https://raw.github.com/jablko/cellect/master/cellect.js
[2] javascript:(function(){document.body.appendChild(document.createElement('script')).src='http://code.jquery.com/jquery.min.js';document.body.appendChild(document.createElement('script')).src='https://raw.github.com/jablko/cellect/master/cellect.js'})()
[3] https://raw.github.com/jablko/cellect/master/greasemonkey/cellect.user.js
[4] https://chrome.google.com/webstore/detail/cellect/nbcoeiihmfepcagkdeoodgnegkddcpop
[a jQuery plugin]
http://plugins.jquery.com/cellect/
[5] javascript:(function(){document.body.appendChild(document.createElement('script')).src='https://raw.github.com/jablko/cellect/master/greasemonkey/cellect.user.js'})()
[6] https://addons.mozilla.org/en-US/firefox/addon/greasemonkey/
[only allow you]
http://support.google.com/chrome_webstore/answer/2664769
[get the script]
http://userscripts.org/scripts/show/165121
[on GitHub]
https://github.com/jablko/cellect
[minimum product]
http://en.wikipedia.org/wiki/Minimum_viable_product
[very cool project]
http://tabula.nerdpower.org/
[CRUD] http://en.wikipedia.org/wiki/Create,_read,_update_and_delete
[DataTables]
http://datatables.net/
[Handsontable]
http://handsontable.com/
[jTable] http://jtable.org/
[jqGrid] http://www.trirand.com/blog/
[jui_datagrid]
http://www.pontikis.net/labs/jui_datagrid/
[ParamQuery]
http://paramquery.com/
[SlickGrid]
https://github.com/mleibman/SlickGrid
[table2csv]
http://table2csv.com/
[TableTools2]
http://mingyi.org/TableTools2/
[Google Spreadsheet]
http://docs.google.com/spreadsheet
[SocialCalc]
https://github.com/DanBricklin/socialcalc