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

OfficeWriter Blog

Posted on: May 24th, 2013

Hello! So glad you stopped by. To make searching for articles easier on you, we've combined our OfficeWriter product blog with our SoftArtisans company blog. No longer do you need to search in multiple spots. You can still find the same great content, including OfficeWriter upgrade announcements and troubleshooting how-to's, just now they will be in one easily accessible place. Visit us at the SoftArtisans blog and peruse the different categories to see what's new in the...

Tags: officewriter blog, softartisans blog, new officewriter site

Categories: none



Posted on: May 13th, 2013

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.

Solution

Excel has a function named hyperlink() that, with some special syntax, can create links to other cells in a spreadsheet. Normally, the hyperlink function creates a link to a URL, much like the ...

Tags: excel, excelwriter, officewriter, color palette, Excel application

Categories: OfficeWriter Tutorials



Posted on: May 8th, 2013

Problem

When using ExcelWriter's ExcelApplication object to generate a new workbook, custom colors that are assigned in code to fonts, charts, cell backgrounds, etc., display incorrectly on the client when the workbook is generated. OR When creating an Excel File or an Excel file to use as a template with the ExcelTemplate object using Excel 2007 and above, colors are not colors are not preserved in Excel 2003 or older....

Tags: color palette, excel, excelwriter, excelapplication, officewriter, officewriter tutorials

Categories: OfficeWriter Tutorials



Posted on: May 8th, 2013

Problem

Excel's color palette contains 56 colors, all of which can be accessed and most of which can be replaced using ExcelWriter (v6 or later). This post describes the layout of the palette and enumerate the default palette colors. This content is most pertinent to the Excel 2003 color palette, which only has 56 colors. In Excel 2007 and later, workbooks can support millions of colors, but there is still an underlying workbook palette that has 56 colors. For more information about colors in multiple versions of Excel, we have enough post about ...

Tags: excel, officewriter, excelwriter, color palette

Categories: OfficeWriter Tutorials



Posted on: May 8th, 2013

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?

Solution

For simplicity and ease of reading the code examples and text in this article refer to the ExcelApplication object...

Tags: sql server, Reporting Services, excelwriter, officewriter

Categories: OfficeWriter Tutorials



Pages

Subscribe to OfficeWriter Blog