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

OfficeWriter Blog

Posted on: Sep 11th, 2011

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.

 

Introduction

If you have hierarchical data in an Excel report, grouping the data is a good way to make it easier to read. ExcelTemplate now features grouping a nesting options that make it easy to group...

Tags: excelwriter, exceltemplate, excel, office, grouping and nesting

Categories: OfficeWriter Tutorials



Posted on: Sep 10th, 2011

The ExcelTemplate method of creating Excel files is to design a template in Excel that contains data markers. Data markers are cell values that begin with %%= or %%=$ that specifies a database column, variable, or array to insert into the spreadsheet column. ExcelWriter does this by inserting a new row into the worksheet for each row of data being imported. This means that anything below the data marker in the template will be pushed down as the new rows of data are imported. Data markers from the same data set can be placed next to each other, but placing data markers from different...

Tags: excel, data markers, excelwriter

Categories: OfficeWriter Tutorials



Posted on: Sep 9th, 2011

Recently I had a customer who was trying to use OfficeWriter with .NET 4.0 and kept receiving the error:

Warning MSB3253: The referenced assembly "assembly name" could not be resolved because it has a dependency on "System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" which is not in the currently targeted framework ".NETFramework,Version=v4.0,Profile=Client". Please remove references to assemblies not in the targeted framework or consider...

Tags: .net, officewriter, .net 4.0

Categories: OfficeWriter Tutorials



Posted on: Sep 7th, 2011

Pivot tables can be tricky by nature and a significant portion of my support work has been dedicated to helping customers incorporate pivot tables with ExcelWriter. One customer wrote in with the following issue: his client had recently imposed a constraint that all reports had to be in the .xls format, so he needed to convert several OfficeWriter reports designed in Excel 2007 to the 2003 format, but he was having trouble switching the pivot tables. When he tried to save the 2007 format report as a 2003 format report, the pivot tables were locked in a read-only state,...

Tags: pivot tables, excelwriter, officewriter, excel

Categories: OfficeWriter Tutorials



Posted on: Sep 6th, 2011

In this demo, we'll walk you through exporting a SharePoint list to Excel using OfficeWriter. This is accomplished by creating a custom action that pulls data from the SharePoint list and combines it with an Excel template stored in a document library.

Further Resources:

Tags: officewriter, officewriter sharepoint, sharepoint, sharepoint list export

Categories: OfficeWriter Videos



Pages

Subscribe to OfficeWriter Blog