Product Company Support Purchase Blog Reviews
   
  Download Eval Now
divider
 
OfficeWriter Blogs
 

Andrew Brust on OfficeWriter: "Enhanced Integration for Microsoft Business Intelligence"

[Click here to read the full review!]


 

Download SoftArtisans OfficeWriter: Enhanced Integration for Microsoft BI

You can download Andrew Brust's full whitepaper on how OfficeWriter provides needed functionality to Microsoft's BI stack on the Blue Badge website.

Thoughts or questions? Let us know in the comments!


 

Adding Headers to a Grouped Spreadsheet

Introduction

In previous blog posts, I showed how José and Jillian, salespersons with PostOne Bicycles, used the new %%group marker to group and nest hierarchical data from a flat data set. In this tutorial, they will expand upon the concept by introducing headers to help separate each group, using the %%value() marker to show data values in headers and the (hide) modifier to hide data that is already shown in a header.


 

Using Side-by-Side Data Markers in ExcelWriter, Part 3


 

Using ExcelTemplate: Grouping and Nesting on Multiple Columns

Starting in version 7.1 of ExcelWriter, you can use grouping and nesting markers to display flat data in a grouped and nested format using the ExcelTemplate object and a OOXML (.xlsx) template.

 


 

Using ExcelTemplate: Grouping

Starting in version 7.1 of ExcelWriter, you can use grouping and nesting markers to display flat data in a grouped and nested format using the ExcelTemplate object and a OOXML (.xlsx) template.


 

Using Side-by-Side Data Markers in ExcelWriter, Part 2


 

Pivot Tables Version Nightmare


 

Using Side-by-Side Data Markers in ExcelWriter, Part 1


 

OfficeWriter for Excel Video Walkthrough

In this video, we show you how to create a dynamic Excel report quickly and easily with ExcelWriter EE.

 

Further resources:


Pages