SheetAPI.insertFloatingItem

insertFloatingItem( hd, sheetTabId, config, callback, scope )

SheetAPI.insertFloatingItem method is used to insert floating item to the existing sheet tab. Currently, enterpriseSheet supports the following floating items: wedgit, chart, and image.

• hd : object

• sheetTabId : Integer

• config : object

The configuration object defines the parameters to be implemented for the floating items. See the following example for more details.

• callback : Function

• scope : Object

Example code to insert wedgit

var wedgitJson = {
    ftype: 'wedgit',
    url: 'http://www.cubedrive.com'
};
var store = SHEET_API_HD.store;
SHEET_API.insertFloatingItem(SHEET_API_HD, store.getActivedSheetId(), wedgitJson);
    

The above example will insert a wedgit into the current active sheet tab. The config item only include those two parameters.

Example code to insert image

var imageJson = {
    ftype: 'picture',
    url: 'http://www.enterprisesheet.com/resources/images/enterpriseLogo.png'
};
var store = SHEET_API_HD.store;
SHEET_API.insertFloatingItem(SHEET_API_HD, store.getActivedSheetId(), imageJson);
    

The above example will insert an image into the current active sheet tab. The config item only include those two parameters.

Example code to insert chart

var chartJson = {
	ftype: 'chart',
	seriesPosition:'row',
	legendPosition:'right',
	chartType:'column',
	source:{
	    series:[['',8,5,8,7],['',9,5,9,7],['',10,5,10,7],['',11,5,11,7]],
	    usAbs:false
	},
	x:370,
	y:272,
	width:400,
	height:300
};
var store = SHEET_API_HD.store;
SHEET_API.insertFloatingItem(SHEET_API_HD, store.getActivedSheetId(), chartJson);
    

The above example will insert a chart into the current active sheet tab. The config item include those parameters.