Blogging Dot Net (and jQuery too!): October 2009

Tuesday, 6 October 2009

Simple OOXML 2.1.3565 Released

Create .xlsx and .docx documents from templates or from new without Microsoft Excel or Microsoft Word. This release fixes previously reported issues and adds the following functionality

Works with August 2009 CTP of the Open XML SDK.
DeleteRow and DeleteRows from a Worksheet
Use FindColumn to retrieve a column from a Worksheet e.g. to set a column width.

The following issues have been fixed

id# 2227 - PasteDataTable results in a corrupt .xlsx file when pasting a DataTable that contains typeof(float) columns with a CultureInfo other than "en-US"
id# 2291 - PasteDataTable fails with adjacent existing data

Note: Download the source code to view examples and unit tests with lots of sample code.

http://simpleooxml.codeplex.com

Announcing the release of the jQuery databind plug-in

The databind plug-in allows you to automatically bind the contents of an object in JavaScript (usually retrieved using AJAX/JSON).

Each key in the object is used as an id (.example) selector within the selector provided e.g.

var data = { title: 'Lorem ipsum', text: 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.' };
$(document).binddata(data);

Provides the output visible at http://www.opencomponents.net/databind/example1.htm

More complicated examples include the ability to bind arrays of data and objects to tables and unbind forms into json.

More examples and code can be downloaded from: http://www.opencomponents.net/databind/