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

Scott Hillier Reviews OfficeWriter

Using SoftArtisans OfficeWriter with the Business Data Catalog


 

How to create hyperlinks between cells in an Excel spreadsheet

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.


 

Workbook colors are not displayed as expected in older versions of Excel

Problem


 

Excel's color palette explained

Problem


 

How to open a report from SQL Server Reporting Services with the Application object

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?


 

Big Data and OfficeWriter

 


 

PivotTables Now Available within OfficeWriter 8.4

 


 

What's New in OfficeWriter 8.4

 


 

OfficeWriter and Excel Services: When to Use Which

Current and potential customers often ask our sales team: "what is the difference between OfficeWriter and Excel Services?" The high level answer is that that they are very different products designed to address very distinct scenarios. In brief, OfficeWriter is a tool that developers can use to generate, read, and manipulate Excel and Word documents in .NET code. Excel Services is a SharePoint-based server product for sharing, managing, and securing Excel workbooks.


 

Exporting SQL Server Database Data to Excel

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!"


Pages