Excel Document Formatting
Tonight, a quick demo around some requested functionality in regards to formatting cells within Excel Documents.
The Column, Row, and CellRange objects now expose a “style” property that allows for the setting of a number of style-related items.Read More
Top 10 Barista Improvements This Week
The top 10 recent changes in Barista:
- Barista has reached 1,000 checkins!! Now, granted, some of those were Drop checkins, but still, it’s a milestone.
- NetworkCredential is now exposed as a top-level object
- You can create a new NetworkCredential object and pass it to common objects. Right now the bundles that utilize the NetworkCredential are Proxy, Sql, Raven (Web/MVC Barista), TFS (SharePoint/Web/MVC) (More on this below)
- On improvements in the NetworkCredential front, SharePoint Barista now can interact with the SharePoint Secure Store Service to retrieve pre-defined credentials:
- There is a new property on the sp instance retrieved from requiring the SharePoint bundle: secureStore. This object has behavior to perform the following operations:
- Keep in mind that SharePoint exposes a whole permissions model around granting users rights to access to the secure store. This functionality in barista is not bypassing the SharePoint mechanisms in any way.
- Updated TFS Bundle.
- TFS can now be used to connect to a remote TFS Instance (Up to TFS 2012 Update 1) and retrieve work item data.
- In this end-to-end example which shows some of the above capabilities, we connect to the RDA TFS2012 instance and perform a WIQL-based query to retrieve work items.
- I’ve set up an application in my secure store named “RDATFS” 2.And set the user permission to be my RDA account:
- Now, I’m able to access these credentials through Barista – since I’m the owner I get access immediately, but if I wanted to grant access others, I can do that within the Secure Store Service.
- Let’s now use those credentials and pass them to RDA’s TFS – allowing me to enumerate all work items. In this example, I’m just getting the title, the state and the last changed date, but all information is available.
- More work to come in this area, some changes in the object model will occur, some work to be done to retrieve the existing queries, some work to be done to work with TFS Version Control.
- The intent here is to facilitate a way of external parties to be able to have a read view into work item statuses stored on the TFS server through a web page, without knowing an credential. A second goal is to be able to synchronize files and folders in a document library with those stored within TFS. (E.g. TFS-Based Content Deployment.)
- Within Web/MVC Barista, Barista Fiddle now uses AngularJS – so I can add features/functionality in a faster, more maintainable way – this work will roll back to SharePoint Barista soon.
- Within Web/MVC Barista, A new bundle that facilitates interaction with RavenDB is now available:
- A new Unit Testing bundle is now available to SharePoint and Web/MVC Barista.
- This bundle exposes the top-level object “chance” which generates random data, and “assert”
- Behind-the-scenes, assert uses the same unit-testing framework as is in Visual Studio, so that unit test code coverage metrics can be obtained.
- Unit Tests are now maintained under the WebHost example impl.
- Minor Code Quality changes within the Jurassic import, and a pull of the latest two fixes by Paul Bartrum on codeplex – one can only hope that he’ll continue to make changes that I’ll pull into Barista.
- The Latest Kendo UI has now been included with SharePoint Barista under /_layouts/BaristaJS/kendoui.complete.2013.2.716/
- For what’s new, visit http://www.kendoui.com/blogs/teamblog/posts/13-07-17/what’s-new-in-kendo-ui-q2-2013-.aspx
Excel Document Generation
This will be a slightly abridged post as my eyelids are drooping – but I just checked in some improvements to Barista in relation to the ability to read/write to Excel Documents.
This functionality is centered around various enterprise-y use cases around Excel Documents – Creating Excel-based rep rts on the fly, manipulating existing spreadsheets, and so forth.
After including the “Documents” bundle, there is a top-level object called “ExcelDocument” … an empty constructor can be passed, a Base64ByteArray instance (From web.request, or various other sources), Url to a SPFile or a SPFile Previously retrieved.
I recently made available a couple of Prezis on Barista, check them out:Read More
New Administration Functionality
We recently had some problems working with those who manage the farm in identifying which web applications they were exactly seeing. As such, I’ve added new functionality to the SharePoint bundle and a new bundle to help with troubleshooting IIS and Managed Accounts.Read More