Export an Excel template using Jsexcelxml.js

Let's start with a preview.

Business system display export template diagram

• Function description

The world is always fits together, since our customers are required to export Excel, of course, will also lead to Excel, then the problem comes, how our business system know what the user provides data, then the user needs of the data template came into being, The template generation feature is available in the latest version of Jsexcelxml.

var tmpdlg = $. Exportexceltmp ({options});

Tmpdlg. Exportexceltmp (' open ');

2. Parameter description

{

SheetName: ' User Data template ',

Headinfo: [{field: ' F_state ', title: ' Account Status ', DataSource: [' Effective #1# ', ' Invalid #0# ']}],

Savename: ' User Data import template ',

SWF: '.. /.. /.. /commjs/exportexcel.swf '

}

Property	Role
SheetName	Template sheet Name
Headinfo	Template column Information
Savename	Template Name
Swf	Save File SWF Address

• Headinfo

Property	Role
Field	Column fields
Title	Display Name
DataSource	Data source [' value#key# ', ' value2#key2# ']

Export an Excel template using Jsexcelxml.js