Last week, release 20.002 went online including two major new features:
A new data provider for Google Spreadsheets. Similar to our existing provider for Microsoft Excel, we now have a new way to directly connect to Google Spreadsheets data. Google Spreadsheets is a cloud spread sheet service that allows to enter or import data and run calculations on it. The new provider complements the Google Big Query provider we've released in version 20 and allows to easily bind directly to data in the Google cloud. If your file is published on the web (File > Publish to the web" in Google sheets) you can just use:
var provider = new GoogleSpreadsheetsDataProvider("<Table ID>", true); LL.DataSource = provider;
var provider = new GoogleSpreadsheetsDataProvider("<Table ID>", true, "<refreshToken>", "<clientID>", "<clientSecret>"); LL.DataSource = provider;
Supporting PDF as field type. Also in 20.002, we've added a new field type "PDF". This enables easy drag and drop from the Variables-/Fields tree. No more hassle with choosing the correct path, using the correct object etc. Your application can now simply pass all PDFs that are to be available. A sample code would look like this:
using (ListLabel LL = new ListLabel()) { LL.DataSource = <Your Datasource>; LL.Variables.Add("Documents.GTC", @"c:\users\public\gtc.pdf", LlFieldType.PDF); LL.Variables.Add("Documents.Prospectus", @"c:\users\public\prospectus.pdf", LlFieldType.PDF); LL.Design(); }
Jochen Bartlau leads the development at combit as Managing Director. He's a Microsoft .NET enthusiast driving innovation & agile project management. The mobile devices geek who used to be a physicist in his first life loves to spend his spare time with his family.