SharePoint 2013 Excel Services ECMAScript example tomorrow limit Line

Introduction: Recently encountered a "Tomorrow Limit Line" function, Beijing's traffic ah, this is not in the scope of today's discussion, do not spit slot, think about code development, but also write WebPart deployment, very troublesome, and deployment server, need leadership approval, want to bypass this trouble, think of the client, But I did not use the client object model, but the use of Excel Services, of course, is only a small attempt, the effect is OK.

First, the effect of the show, the following figure

Simply explain that you do not need to display the following Excel, you can write down the script to hide, or minimize the WebPart can also, not necessarily have to show. However, as a basis for interacting with ECMA JavaScript scripts, this Excel must be added to the page.

Second, the allocation of ideas

Configure a trusted document library to publish Excel documents that use Excel Services and upload tomorrow's restricted text files;

On the page where you want to add the line limit, add the Excel Web Access part and select the Excel document that we uploaded named "tomorrowlimit.xslt";

Adds a content Editor widget to the page to add ECMA JavaScript scripts that read Excel documents within an Excel Web access part.

Third, the configuration step

1, a new Excel, named "Tomorrowlimit.xslt", the following figure;

2, upload to the configured trust location [1] in the document library, the first page to add "Excel Web access Parts";

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/web/sharepoint/

3, Add Content Editor, add script, choose Edit source can add HTML code directly;