Archive for November, 2009

ExtremeML Excel Table Tutorial Series is Complete

Continuing the tutorials on working with Excel Tables using ExtremeML, I have now uplodaded the final three parts. Here is the complete series:

Populating a Table from an Array
Populating a Table from a Data Source
Sorting and Filtering Injected Table Data
Populating a Table Using a Linq Query
Appending Data to an Existing Table
Using Explicit Table Column Mappings

Although this [...]

New Tutorial Series: Working with Excel Tables in ExtremeML

After a gentle start to the tutorial series, this post will crank things up a notch by introducing one of the foundation stones of effective ExtremeML programming: Excel Tables. If you’re not already sold on the benefits of Excel tables, it’s worth spending a few minutes to discover what all the fuss is about. To [...]

3 New Tutorials: Editing Excel Cell Values and Formulas with ExtremeML

Continuing the ExtremeML introductory tutorial series, I have just added three new topics, which examine how to set and read Excel worksheet cell values and formulas from your .NET code:

Directly Populating Worksheet Cells
Working with Strongly-Typed Cell Values
Using Formulas in Cells

In the next installment we will examine a slightly more advanced (and altogether more useful) topic: [...]

5 New Tutorials: Manipulating Excel Worksheets using ExtremeML

As promised, I have now published the first group of an ongoing series of tutorials that will explain how programmatically create and edit rich and highly-functional Excel spreadsheets using ExtremeML.
These introductory lessons cover the basics of working with worksheets:

Adding a New Worksheet
Inserting Columns into a Worksheet
Inserting Rows into a Worksheet
Deleting Columns from a Worksheet
Deleting Rows [...]

Announcing ExtremeML: The Simple Way to Create Excel Spreadsheets in .NET Applications

From 2007, Word, Excel and PowerPoint have adopted a new open and accessible file format, known as OpenXML.
An OpenXML document is a zip file containing a hierarchy of folders, each of which holds a number of Xml (or other) documents. You can see this for yourself just by assigning a zip extension to any standard [...]