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.
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 CreateHyperlink function. Simply passing the name of a cell to the function causes it to form a bad link; Excel will interpret it as a URL.
The solution is to enclose the name of the destination cell in quotes and preface it with a pound sign. For example, a cell with formula =HYPERLINK(“#Sheet2!C3”, “Link to C3”) will contain the text “Link to C3”, and function as a hyperlink to that cell in Sheet2. The formula can be set either by editing an Excel file directly, or through setting the Cell.Formula property in ExcelWriter.
When the user clicks on the link, Excel’s focus will move to Continue reading How to create hyperlinks between cells in an Excel spreadsheet
Spring has sprung, bringing with it our newest release of OfficeWriter: OfficeWriter 8.5! What’s in store for this maintenance release? Scroll down to see the latest additions our development team has been working on.
WordTemplate – Embed DOCX files into templates
In OfficeWriter 8.0, we added the ability to embed RTF or HTML documents in Word files with WordTemplate. The feature uses the document modifier to signify that a RTF or HTML document will be inserted. To learn more about using the document modifier, see our guide on inserting an embedded document under our WordTemplate Tutorials.
We have also extended the feature to include DOCX files. Now you can embed other Word documents into your WordWriter templates. Continue reading What’s new in OfficeWriter 8.5
With data sets tied to different data sources and multiple people handling one report, the process of building a report can get messy. OfficeWriter’s built-in Designer Ribbon makes it easier to interact with SQL Server Reporting Services (SSRS), helping you access reports from your applications on time and with ease. Join us Friday, March 22nd as our Senior Sales Engineer, Chad Evans, shows you how this feature makes using SSRS simpler.
In this webinar you will learn:
- How to build an SSRS report from start to finish using the OfficeWriter designer ribbon
- How to easily open existing reports, create new ones, and view reports in process with SSRS
We will also have a question and answer period at the end of the webinar. Feel free to send in questions prior to the webinar so that we can include them in the presentation.
When: Friday, March 22nd at 1 P.M. EST
Can’t attend, but still want a copy of the recording and slides? Register below and we’ll email it out following the webinar.
**Spots are limited. So please register early to secure your seat.
We partnered with Andrew Brust from Blue Badge Insights to integrate OfficeWriter with Hadoop and Big Data. Taking existing OfficeWriter sample projects, Andrew discusses how he created two demos showing OfficeWriter’s capabilities to work with Big Data. One demo uses C#-based MapReduce code to perform text-mining of Word docs. The other demo focuses on connecting to Hadoop through Hive.
In these demos you will learn:
- How OfficeWriter integrates with Hadoop and Big Data
- How to use ExcelWriter with Hadoop
We’re taking OfficeWriter to the cloud. In these videos you’ll see how OfficeWriter runs on Windows Azure. Taking our exisiting OfficeWriter web sample projects, Andrew Brust from Blue Badge Insights made them run on the Windows Azure cloud platform.
In these videos you will:
- Learn how OfficeWriter web samples were put on the cloud
- Learn how the runtime environment for the Windows Azure samples compares to the ASP.NET samples
- Have access to the OfficeWriter web samples
PIVOT TABLES ARE HERE!
OfficeWriter 8.4 packs a powerful punch with exciting new features, most notable of which is ExcelApplication support for PivotTables in OOXML (XLSX, XLSM) files. ExcelWriter already supports the use of PivotTables in ExcelTemplate and SSRS reports, but now you can programmatically create, manipulate, and remove PivotTables with ExcelApplication.
The new PivotTable API gives you the freedom to:
- Create PivotTables from scratch (see our tutorial on Creating a Basic PivotTable)
- Add and manipulate PivotTable fields – data value fields, column labels, row labels, and report filter page fields
- Access common settings like empty/error values, refresh data when opening a file, and the number of cached items to retain
With the API you also have the ability to change the data source of a PivotTable. Continue reading What’s new in OfficeWriter 8.4
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.
In this powerpoint:
- You’ll learn about OfficeWriter’s object and template models
- Scenerios in which to use OfficeWriter
- How OfficeWriter plays into Microsoft Dynamics, SharePoint, and Azure
SQL Server Reporting Services subscriptions are an easy way to automatically run and deliver SSRS reports. You can schedule reports to run at a regular interval and deliver to file share, e-mail, or a SharePoint document library (if you’re using SharePoint integration mode).
How it’s done:
Here is my SSRS 2008 R2 instance, with a couple of prepared reports:
I’m going to create a subscription for SSRS_example_multivalue, which has a parameter with multiple values to select from. Continue reading Automating Reports with SSRS Subscriptions
In the latest version of SQL Server, SQL Server 2012, Reporting Services now supports the Office 2007\2010 XLSX file format (aka Office Open XML file format) in its Excel renderer. In fact that is the default format for the Excel renderer. The old renderer for the legacy Excel 2003 XLS format has been named to “Excel 2003” but it has been deprecated and is not visible in the available export options list by default. For reference see the related section in the MSDN documentation. Although SSRS 2012 has now the ability to export an RDL report into an Excel XLSX workbook, the Excel renderer still has certain limitations. In this blog post, we will discuss some of these limitations and compare them to the OfficeWriter renderer in SSRS.
Probably one of the major limitations is that charts will be exported as pictures. In the related section in the MSDN documentation it states:
“Charts, sparklines, data bars, maps, gauges, and indicators are exported as pictures. The data they depict, such as the value and member labels for a chart, is not exported with them and is not available in the Excel workbook unless it is included in a column or row in a data region within a report.”
With the OfficeWriter renderer on the other hand, the charts will be native Excel charts with live data. Let’s see the difference in the following screenshots:
“Product Sales Report.xlsx” generated using the SSRS 2012 Excel renderer (note that the chart is a picture)
Continue reading Comparing Excel Export Functionality in SSRS 2012 to OfficeWriter