excel.getArray.md

Excel.getArray

The getArray function is established to get several fields as an array from one sheet.

Sample

	var excel = new Excel("test.xlsx");
	var ary1 = excel.getArray("Sheet1", 1, 3, 
		{
			"data1":"A", 
			"data2":"B", 
			"data3":"C"
		});
	var ary2 = excel.getArray("Sheet1", 1, 
		function(row){
			if (excel.getValue("Sheet1","A"+row)!=""){
				return true;
			}else{
				return false;
			}
		}
	, {
		"data1":"A", 
		"data2":["B","#,##0.0","HALF_EVEN"], 
		"data3":["C","yyyy/MM/dd"], 
		"data4":
			function(row){
				return excel.getValue("Sheet1","D"+row)+excel.getValue("Sheet1","E"+row);
			}
	});
	var ary3 = excel.getArray{"Sheet1", 1, 4,[{"data1":"A"},{"data2":"A"}]};

API

Calling	Returning
Excel . getArray ( sheetName , startRow , endCondition , positionRowMaps )	Array

Parameters	Type	Description
sheetName	String	The sheet name.
startRow	Number	The start row for looping at the sheet. Indexed from 1.
endCondition	Number | Function	The end condition for looping at the sheet. It is a number or a function. Indexed from 1. function ( row ) {return true;}
positionRowMaps	Object | Array	Object: The map for getting data from a row. Array: The maps for getting data from several rows. { data1:col, data2:[col, formatter, rounder], data3:function(row){ return String|Number|Date|Boolean;} } [ { data1:col, data2:[col, <a href="formatter&rounder.md">formatter</a>, <a href="formatter&rounder.md">rounder</a>], data3:function(row){ return String|Number|Date|Boolean;} }, {...} ]