Product Company Support Purchase Blog Reviews
  Download Eval Now
OfficeWriter Blogs

Watch What's New in OfficeWriter 8.4's PivotTable API

Take a walk through of the new PivotTable functionality in the release of OfficeWriter 8.4. To access the new API download a free trial of OfficeWriter 8.4.  To see a complete list of features and fixes in this release, see What's New in OfficeWriter 8.4.


What's New in OfficeWriter 8.4



Enhancing your Word Document with Images Using OfficeWriter

One of the questions that comes up frequently when talking with customers is how can they get their images into their Word document with OfficeWriter? Depending on how you are using OfficeWriter and making your Word documents, there are a few ways to do this. The following outline several of these methods and cases in which to use them.

1. Design your document in Word with images

This is the easiest way to get images into your document. Since OfficeWriter can use the Word file you have already created and allow you to enhance it with data from a database, you can get all of the design functionality of Word with the enhanced capabilities of OfficeWriter. This method is commonly used when designing a document that uses your company logo, for example.

2. Dynamically insert images into a document

Another option is to design your document in Word, but leave a place holder for a dynamically loaded image. (A quick overview on how to do this can be found here.) This method is great when the document is structured the same each time it is run and you want to keep your company logo static, but use different department logos.

3. Design your report with images stored in a database

You can use one of two methods


OfficeWriter & the Microsoft Application Platform

Curious to know more about how OfficeWriter fits in with the Microsoft Application Platform? We've partnered with Andrew Brust from Blue Badge Insights to bring you an overview of the additive value OfficeWriter provides to the Microsoft stack.


New in OfficeWriter 8.3: Autofilters and More!

[cross-posted from]

OfficeWriter 8.3 is filled with exciting new features. Here are some of our favorites:


OfficeWriter Whitepaper

Looking for a comprehensive overview of OfficeWriter? You've come to the right place. We've partnered with Andrew Brust of Blue Badge Insights to give you an inside look at how OfficeWriter can benefit your business intelligence.

Microsoft Office and Data: A Love Story


How to display all selected values for an SSRS multi-select parameter in an Excel report

It is very common when designing reports that you may need to define a multi-select report parameter in order to give the users some filter options and generate the report based on the user-selected values. You may also want to display those selected values on the Excel report.


What's new in OfficeWriter 8.0?

What's New

OfficeWriter 8.0 was just recently released!  So, what's new in this most significant release of OfficeWriter in a number of years?  Here's the breakdown:



OfficeWriter 8.0: Getting Started with XLSX in C#

XLSX in OfficeWriter 8.0

SoftArtisans released OfficeWriter 8.0 recently, and the biggest feature in this release is full support for Excel 2007/2010 files with the OfficeWriter API.  So, if you've written OfficeWriter applications that process XLS files, what do you need to do to get started with using XLSX files?  In short, nothing!


OfficeWriter for the IT Pro: Automated Dell Warranty Lookup using Powershell and ExcelTemplate

OfficeWriter for the IT Pro posts are aimed at exploring ways to extend the use of OfficeWriter to the IT work space.

This script will dynamically query Dell's Warranty web-service ( via PowerShell and export the results to an Excel (xlsx) file using OfficeWriter's ExcelTemplate object. I've added colored conditional formatting depending on how many days are left before the warranty expires.

In the script, we leverage two external community provided PowerShell functions, Out-DataTable and Get-DellWarranty. Get-DellWarranty accepts a computer name then returns the results as a PowerShell object. The ExcelTemplate object will not bind a PowerShell object so we use Out-DataTable to convert the object into a .NET DataTable.

You will need proper permissions and PowerShell access to run the script against remote servers. You will need to modify the $myComputerList variable to include the computers that you want to query. You will need to download the file attached to this post. It contains the required PowerShell modules, DellWarrantyExporttoExcel script, DellWarrantyLook.xlsx excel template, and a sample excel output file (output.xlsx). The final requirement to run the script is a copy of OfficeWriter Standard. You can download an evaluation from