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

OfficeWriter Blog

OfficeWriter 8.0: Getting Started with XLSX in C#

Posted on: Jan 5th, 2012

XLSX in OfficeWriter 8.0

SoftArtisans released OfficeWriter 8.0 recently, and the biggest feature in this release is full support for Excel 2007/2010 files with the OfficeWriter API.  So, if you've written OfficeWriter applications that process XLS files, what do you need to do to get started with using XLSX files?  In short, nothing!

We took special care to keep compatibility in mind, so you can largely use the same code to process your XLSX files that you use with XLS.  There are a couple scenarios in which you'll need to be specific...

Read more...

Tags: officewriter

Categories: none



OfficeWriter for the IT Pro: Automated Dell Warranty Lookup using Powershell and ExcelTemplate

Posted on: Dec 22nd, 2011

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...

Read more...

Tags: powershell, officewriter, exceltemplate, dell warrenty web services

Categories: OfficeWriter Tutorials



Post-Processing SSRS Reports using OfficeWriter in .NET

Posted on: Nov 22nd, 2011

Using OfficeWriter's integration with SSRS in conjunction with the Designer is typically a straightforward process with no programmatic manipulation of the reports. A developer designs the report in Visual Studio BIDS, opens the .rdl using the Designer, designs the template in Word/Excel, and publishes the report. The report is then rendered inside the Report Manager using the custom OfficeWriter export option. However, there are times that situations call for post-processing the report programmatically and that's where...

Read more...

Tags: ssrs, officewriter, c#

Categories: OfficeWriter Tutorials



No more row limitations: Exporting XLSX with SQL Server 2008 R2 Reporting Services

Posted on: Oct 27th, 2011

Introduction

The hard-at-work folks on the SQL Server Reporting Services team recently announced that SQL Sever 2012 (formerly codenamed "Denali") will feature the ability to export reports to XLSX and DOCX.  These new OpenXML-based file formats were introduced in Microsoft Office 2007, and they contain a number of interesting features and capabilities beyond the older, binary XLS and DOC files.

But, if you can't wait for the SQL Server 2012 release (expected to be released in the first quarter of 2012) to get XLSX and DOCX from Reporting...

Read more...

Tags: none

Categories: none



OfficeWriter and Excel Services: When to Use Which

Posted on: Sep 25th, 2011

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.

Note that the title of this article is "OfficeWriter and Excel Services", not "...

Read more...

Tags: excel services, excelwriter, ssrs, sql server, officewriter

Categories: OfficeWriter Tutorials, OfficeWriter Comparison



Pages

Subscribe to OfficeWriter Blog

footer
Follow SoftArtisans on Facebook! Follow SoftArtisans OfficeWriteron Twitter! Follow SoftArtisans on LinkedIn! Follow SoftArtisans Blogs! Follow SoftArtisans on YouTube! Follow Us on Google Plus! Have a Question? Go to StackOverflow!
divider
Copyright 2023 © SoftArtisans All Rights Reserved.
 +1.617.607.8800 | PO Box 590684, Newton, MA 02459 USA| E: contact@softartisans.com | Contact Us