Problem

Your application requires cells to contain hyperlinks to other cells in the same spreadsheet, but the Cell.CreateHyperlink function only makes links to URLs on the internet. This article discusses a workaround using Excel's HYPERLINK function.

Problem

Problem

Problem

You want to modify your reports with the WordApplication or ExcelApplication object after they've been populated with data by SQL Server Reporting Services. The ExcelApplication or WordApplication object's Open method can't pull a report from a report server, so how do you open a SSRS report with OfficeWriter?

OfficeWriter 8.1 marks the first maintenance release of OfficeWriter 8 and we focused on adding support of Office 2010 in the OfficeWriter Designer, including a brand new look that integrates with the Office 2007/2010 ribbon:

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.

Introduction

The need to get business data from a SQL Server database (or any other kind of RDBMS for that matter) into Excel for further analysis is universal. I would venture to say that anyone in any business role from marketer to analyst to salesperson to executive to program manager has had the occasion to say: "I need this data in Excel so that I can crunch it!"