excel.getSingle.md

Excel.getSingle

The getSingle function is established to get several fields as an object from one sheet.

Sample

	var excel = new Excel("test.xlsx");
	var ary = excel.getSingle("Sheet1", 
		{	"data1":"A1", 
			"data2":["B2","#,##0.0","HALF_EVEN"], 
			"data3":["C3","yyyy/MM/dd"], 
			"data4":
			function(){
				return excel.getValue("Sheet1","D4")+excel.getValue("Sheet1","E5");
			}
		}
	);

API

Calling	Returning
Excel . getSingle ( sheetName , positionMap )	Object

Parameters	Type	Description
sheetName	String	The sheet name.
positionRowMap	Object	The map for getting data from a row. { data1:position, data2:[position, formatter, rounder], data3:function(){ return String|Number|Date|Boolean;} }