j - npm Package Compare versions

Comparing version 0.3.15 to 0.4.0

j.js

@@ -6,2 +6,3 @@ /* j -- (C) 2013-2014 SheetJS -- http://sheetjs.com */
 var XLS = require('xl'+'sjs');
+var HARB = require('ha'+'rb');
 var UTILS = XLSX.utils;
@@ -11,3 +12,4 @@
 	["XLS", XLS],
-	["XLSX", XLSX]
+	["XLSX", XLSX],
+	["HARB", HARB]
 ];
@@ -26,3 +28,3 @@
 		/* Unknown */
-		default: return [undefined, f];
+		default: return [HARB, HARB.readFile(filename, options)];
 	}
@@ -40,3 +42,3 @@ };
 		/* Unknown */
-		default: return [undefined, data];
+		default: return [HARB, HARB.read(data.toString(), options)];
 	}
@@ -47,2 +49,3 @@ };
 	var XL = w[0], workbook = w[1];
+	if(!XL.utils.get_formulae) XL = XLSX;
 	var result = {};
@@ -58,2 +61,3 @@ workbook.SheetNames.forEach(function(sheetName) {
 	var XL = w[0], workbook = w[1];
+	if(!XL.utils.sheet_to_row_object_array) XL = XLSX;
 	var result = {};
@@ -69,2 +73,3 @@ workbook.SheetNames.forEach(function(sheetName) {
 	var XL = w[0], workbook = w[1];
+	if(!XL.utils.make_csv) XL = XLSX;
 	var result = {};
@@ -80,2 +85,3 @@ workbook.SheetNames.forEach(function(sheetName) {
 	var val, r, hdr, R, C, _XL = XL || XLS;
+	if(!XL.utils.format_cell) XL = XLSX;
 	hdr = [];
@@ -94,2 +100,3 @@ if(!sheet["!ref"]) return hdr;
 	var XL = w[0], wb = w[1];
+	if(!XL.utils.format_cell) XL = XLSX;
 	var tbl = {};
@@ -130,2 +137,3 @@ wb.SheetNames.forEach(function(sheet) {
 	var XL = w[0], wb = w[1];
+	if(!XL.utils.format_cell) XL = XLSX;
 	var tbl = {};
@@ -251,3 +259,3 @@ wb.SheetNames.forEach(function(sheet) {
 
-	var scencode = function(s) { return s.replace(/\\/g, "\\b").replace(/:/g, "\\c").replace(/\n/g,"\\n"); }
+	var scencode = function(s) { return s.replace(/\\/g, "\\b").replace(/:/g, "\\c").replace(/\n/g,"\\n"); };
 
@@ -276,2 +284,14 @@ var scsave = function scsave(ws) {
 						} break;
+					case 'b':
+						if(cell.f) {
+							oo[2] = 'vtf';
+							oo.push('nl');
+							oo.push(cell.v ? 1 : 0);
+							oo.push(scencode(cell.f));
+						} else {
+							oo[2] = 'vtc';
+							oo.push('nl');
+							oo.push(cell.v ? 1 : 0);
+							oo.push(cell.v ? 'TRUE' : 'FALSE');
+						} break;
 				}
@@ -289,3 +309,3 @@ o.push(oo.join(":"));
 		return [header, sep, meta, sep, scsave(ws), end].join("\n");
-		return ["version:1.5", scsave(ws)].join("\n");
+		// return ["version:1.5", scsave(ws)].join("\n"); // clipboard form
 	};
@@ -292,0 +312,0 @@ })();

package.json

 {
   "name": "j",
-  "version": "0.3.15",
+  "version": "0.4.0",
   "author": "sheetjs",
@@ -20,2 +20,3 @@ "description": "CLI tool for working with XLS/XLSX/XLSM/XLSB files",
     "xlsx": "~0.7.10",
+    "harb": "~0.0.2",
     "concat-stream":"",
@@ -22,0 +23,0 @@ "commander":""

README.md

 # J
 
-Simple data wrapper that attempts to wrap [xlsjs](http://npm.im/xlsjs) and [xlsx](http://npm.im/xlsx) to provide a uniform way to access data from Excel files.
+Simple data wrapper that attempts to wrap SheetJS libraries to provide a uniform way to access data from Excel and other spreadsheet files:
 
+- [xlsjs](http://npm.im/xlsjs)
+- [xlsx](http://npm.im/xlsx)
+- [harb](http://npm.im/harb)
+
 Excel files are parsed based on the content (not by filename).  For example, CSV files can be renamed to .XLS and excel will do the right thing.
@@ -17,2 +21,6 @@
 | XML (2003/2004, basic)  | JS-XLS  |
+| DIF (plaintext)         | JS-HARB |
+| UTF-16 Text             | JS-HARB |
+| CSV / TSV               | JS-HARB |
+| SocialCalc              | JS-HARB |
 
@@ -22,6 +30,8 @@ Output formats:
 - XML and HTML work with [Excel Web Query](http://office.microsoft.com/en-us/excel-help/get-and-analyze-data-from-the-web-in-excel-HA001054848.aspx)
-- CSV (and other delimited formats such as TSV)
+- DSV (general delimiters, including CSV and TSV)
 - JSON
 - Formulae list (e.g. `A1=NOW()`, `A2=A1+3`)
 - XLSX / XLSM work with iOS Numbers and Excel
+- Markdown tables (GFM style)
+- SocialCalc output
 
@@ -28,0 +38,0 @@ ## Installation

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Dynamic require

Supply chain risk

Dynamic require can indicate the package is performing dangerous or unsafe dynamic code execution.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

21513

increased by4.62%

Lines of code

324

increased by6.58%

Number of lines in readme file

154

increased by6.94%

Worsened metrics

Dependency count

5

increased by25%

Number of low supply chain risk alerts

4

increased by33.33%

Dependency changes

• + Addedharb@~0.0.2

• + Addedbabyparse@0.2.1(transitive)

• + Addedharb@0.0.7(transitive)