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.

‎

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

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.

[cross-posted from blog.softartisans.com]

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

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

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 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 (http://xserv.dell.com/services/assetservice.asmx) 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 resources.zip 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 http://www.officewriter.com/officewriter-free-evaluation.aspx.