Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(41)

Unified Diff: util/table2CSV.js

Issue 4123001: Modified chrome pageload extension (Closed) Base URL: http://src.chromium.org/svn/trunk/src/chrome/common/extensions/docs/examples/extensions/benchmark/
Patch Set: '' Created 10 years, 2 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
« no previous file with comments | « util/sorttable.js ('k') | no next file » | no next file with comments »
Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
Index: util/table2CSV.js
===================================================================
--- util/table2CSV.js (revision 0)
+++ util/table2CSV.js (revision 0)
@@ -0,0 +1,90 @@
+/*
+This is a small JQuery utility to export HTML table as CSV file.
+
+The author is Kunal Babre and the original script can be found in
+http://www.kunalbabre.com/projects/table2CSV.php. Permissions are
+granted by the author to make changes and redistribute.
+
+Changes made by jning: To avoid exporting the textbox, radio buttons and etc.
+in the table, the parameters rowNum and index in $().find().each() or
+$().filter().find.each() help to ignore non-data cells.
+*/
+
+jQuery.fn.table2CSV = function(rowNum, options) {
+ var options = jQuery.extend({
+ separator: ',',
+ header: [],
+ delivery: 'popup' // popup, value
+ },
+ options);
+
+ var csvData = [];
+ var headerArr = [];
+ var el = this;
+
+ //header
+ var numCols = options.header.length;
+ var tmpRow = []; // construct header avalible array
+
+ if (numCols > 0) {
+ for (var i = 0; i < numCols; i++) {
+ tmpRow[tmpRow.length] = formatData(options.header[i]);
+ }
+ } else {
+ $(el).filter(':visible').find('th').each(function(index) {
+ if (index > 0 && $(this).css('display') != 'none')
+ tmpRow[tmpRow.length] = formatData($(this).html());
+ });
+ }
+
+ row2CSV(tmpRow);
+
+ // actual data
+ $(el).find('tr').each(function(index) {
+ if (index < rowNum + 1) {
+ var tmpRow = [];
+ $(this).filter(':visible').find('td').each(function(index) {
+ if (index > 0 && $(this).css('display') != 'none')
+ tmpRow[tmpRow.length] = formatData($(this).html());
+ });
+ row2CSV(tmpRow);
+ }
+ });
+ if (options.delivery == 'popup') {
+ var mydata = csvData.join('\n');
+ return popup(mydata);
+ } else {
+ var mydata = csvData.join('\n');
+ return mydata;
+ }
+
+ function row2CSV(tmpRow) {
+ var tmp = tmpRow.join('') // to remove any blank rows
+ // alert(tmp);
+ if (tmpRow.length > 0 && tmp != '') {
+ var mystr = tmpRow.join(options.separator);
+ csvData[csvData.length] = mystr;
+ }
+ }
+ function formatData(input) {
+ // replace " with “
+ var regexp = new RegExp(/["]/g);
+ var output = input.replace(regexp, "“");
+ //HTML
+ var regexp = new RegExp(/\<[^\<]+\>/g);
+ var output = output.replace(regexp, "");
+ if (output == "") return '';
+ return '"' + output + '"';
+ }
+ function popup(data) {
+ var generator = window.open('', 'csv', 'height=400,width=600');
+ generator.document.write('<html><head><title>CSV</title>');
+ generator.document.write('</head><body >');
+ generator.document.write('<textArea cols=70 rows=15 wrap="off" >');
+ generator.document.write(data);
+ generator.document.write('</textArea>');
+ generator.document.write('</body></html>');
+ generator.document.close();
+ return true;
+ }
+};
« no previous file with comments | « util/sorttable.js ('k') | no next file » | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698