Archive for 'Tutorials' Category

Working with Streams in ExtremeML

One of the most commonly requested “missing features” of ExtremeML is the ability to read and write streamed data. The recently anncounced premium edition addresses this need through the addition of two new factory method overloads.
To help you get started using streams, here are two new tutorials from the updated user guide:

Creating a Workbook with [...]

New Tutorial: Iterating Over Excel Rows and Cells

I have created a new tutorial showing an alternative method of reading and retrieving data from an existing Excel worksheet.

2 New Tutorials: Adding PivotTables and PivotCharts using ExtremeML

Building on my earlier tutorials, which explained a range of techniques for working with programmatically injecting table data into Excel, I have today published to new lessons that explore ExtremeML’s support for PivotTables and PivotCharts.

Adding a PivotTable
Adding a PivotChart

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 [...]