Brian Jones: Office Solutions

I'm Brian Jones, the group program manager of the Office Solutions Framework team.

Browse by Tags

Tagged Content List
  • Blog Post: Writing Large Excel Files with the Open XML SDK

    In my last post, I showed you guys how to use the Open XML SDK to read and parse large Excel files . Today, I am going to show you how to write large Excel files with the Open XML SDK . Like in the case of reading, the Open XML SDK provides two approaches for writing Open XML files: 1. using the DOM...
  • Blog Post: Parsing and Reading Large Excel Files with the Open XML SDK

    I want to thank you guys for leaving blog post requests. Today's post will focus on one of your requests: parsing and reading large Excel files with the Open XML SDK. The Open XML SDK provides two approaches for parsing Open XML files: 1. using the SDK DOM , 2. using the SAX-like reading/writing capabilities...
  • Blog Post: Open XML SDK + Office Services: Better Together

    I am probably starting to sound like a broken record, but I am really excited about the different types of solutions that are possible when combining the Open XML SDK with Office Services. In the past, I showed you how to leverage the Open XML SDK to accomplish three main scenarios: Push data into Open...
  • Blog Post: Leveraging the Power of Word Automation Services and the Open XML SDK

    Have you ever wanted to update page number fields or a table of contents within Word documents on the server? The Open XML SDK provides functionality that allows you to easily add or remove content within a Word document. However, as mentioned in the announcement of the Open XML SDK 2.0 , the SDK does...
  • Blog Post: Open XML SDK Code behind the Custom XML Markup Detection Tool

    Recently on Gray's blog he posted about a scanning tool that can be used to detect custom XML markup in Word Open XML files (*.docx, *.docm, *.dotm, and *.dotx). The tool is built using the Open XML SDK and we wanted to take the opportunity to show you how the solution works in this blog. Solution The...
  • Blog Post: Document Assembly: Merging Excel, PowerPoint, and Word Content Together

    Document assembly seems to be a hot topic these days especially when combined with the power of SharePoint. Today, I want to show you a pretty rich document assembly solution that is able to take multiple Word, Excel and PowerPoint documents and merge them all together to form a final Word document....
  • Blog Post: Extending the Reach of Excel Services with the Open XML SDK

    Note: Updated post to point to a YouTube video that is shorter than 10 minutes In Brian's last blog he talked about Open XML and Office Services as a one-two punch to complete many types of solutions. I am going to start writing some posts that showcase these two technologies working together. Excel...
  • Blog Post: Open XML SDK + Word Automation Services Presentation at PDC

    I just got back from PDC and am excited to share with you guys the presentation, deck, and code samples I showed at my session . I also want to thank everyone who attended my session. Here is my recorded session: You can find my session deck here: http://ecn.channel9.msdn.com/o9/pdc09/ppt/PR09.pptx You...
  • Blog Post: Open XML SDK Demos Shown at the SharePoint Conference (SPC)

    First off, I want to thank everyone who attended my two sessions at SPC on developing solutions on top of the Open XML SDK. The sessions were recorded, so as soon as they are published to the web I will send you guys some links. In the meantime, I want to share with you guys some really cool demos and...
  • Blog Post: Finding Open XML Errors with Open XML SDK Validation

    In a previous post, I gave you an overview of the functionality added to the Open XML SDK 2.0 August 2009 CTP . Today, I want to deep dive into the schema and semantic level validation support within the SDK. Specifically, I am going to show you guys the Open XML SDK code needed to actually validate...
  • Blog Post: Open XML SDK Code Snippets

    In my previous post , I announced the release of the Open XML SDK August 2009 CTP . Today, I want to announce the release of the Open XML SDK code snippets . This package of code snippets provides over fifty reusable code samples, in both C# and VB.NET, which accomplish many common tasks involving Excel...
  • Blog Post: Adding Repeating Data to PowerPoint

    In a previous post, I showed you how to create a product catalog in a Word document using the Open XML SDK . I also showed you how to make PowerPoint a reporting application based on data within a database . Today, I am going to show you how to create a product catalog in a PowerPoint deck using the...
  • Blog Post: The Open XML SDK and Fluent UI Extensibility

    Fluent UI, or the Ribbon, was introduced as part of Office 2007 as a replacement of the previous system of toolbars and menus. The Fluent UI technology, like the Open XML formats, is based on xml, which allows for a much richer extensibility story for developers. In Erika Ehril's blog post she described...
  • Blog Post: Embedding Any File Type, Like PDF, in an Open XML File

    In my last post, I showed you guys how to embed an Excel spreadsheet within a Word document without the need to invoke an OLE Server. In today's post I am going to show you how to embed any file in an Open XML file. Specifically, I am going to show you how to embed a PDF file into a Word document. Note...
  • Blog Post: Embedding an Open XML File in another Open XML File

    A couple of weeks ago I gave a presentation on the Open XML SDK to a few customers, where I was asked questions on how to embed files within Open XML documents. I thought it would be a good opportunity to devote a couple of posts around this topic. In today's post I am going to show you how to embed...
  • Blog Post: Removing Page and Section Breaks from a Word Document

    In today's post I am going to show you how to remove page and section breaks within a Word document using the Open XML SDK. Removing these two types of breaks is similar, but requires two different approaches. Let's start off by jumping into removing page breaks. My post will talk about using version...
  • Blog Post: Importing SmartArt from PowerPoint to Word

    In previous posts, I showed you how to import charts from spreadsheets to a Wordprocessing document and how to import tables from Word documents to spreadsheets . Today, I am going to show you how to import SmartArt from a PowerPoint deck into a Word document. Solution To import a SmartArt...
  • Blog Post: Retrieving Word Content Based on Styles

    In previous posts, like Importing a Table from Word to Excel , I showed you how to retrieve content within specific content controls. In these posts, content controls were used to add semantic structure to a document, where this structure aided in retrieving and inserting content. What about other types...
  • Blog Post: Removing Comments from Excel and PowerPoint Files

    In a previous post, I showed you how to remove comments from a Word file . In today's post, I am going to show you how to accomplish the same scenario, but this time with Excel and PowerPoint files. Excel and PowerPoint have a Document Inspector feature, which is able to remove multiple types of data...
  • Blog Post: Importing a Table from WordprocessingML to SpreadsheetML

    In a previous post, I showed you how to import charts from spreadsheets to a Wordprocessing document . Today, as promised in my last post , I am going to show you how to import a table from a Wordprocessing document into a spreadsheet. Solution To import a table from a Wordprocessing document to...
  • Blog Post: Importing Charts from Spreadsheets to Wordprocessing Documents

    There have been several requests made by people asking how to import a chart from one document type to another document type. In a previous post, I showed you how to push data into a spreadsheet to create a chart . Today, I am going to show you how to import a chart from a spreadsheet to a Word document...
  • Blog Post: How to Assemble Multiple PowerPoint Decks

    I just want to let you guys know we are working on some server issues here, which is why some of the previous posts are not showing images or links to source code. This issue will hopefully be resolved soon. In my previous post, I showed you the easy way to assemble multiple Word documents . Today...
  • Blog Post: How to Copy a Worksheet within a Workbook

    As promised in my previous post about reusable methods for manipulating WordprocessingML , I mentioned I would write a post on how to copy a worksheet within a workbook. Note that this blog post talks about copying a worksheet within the same package. Perhaps sometime in the future I will write a post...
  • Blog Post: Removing Comments from a Wordprocessing Document Programmatically

    One of the more common scenarios related to a Wordprocessing document is the need to sanitize a document in order to remove personally identifiable information. What do I mean by personally identifiable information? Well, I am talking about, among other things, comments, revisions, personal information...
  • Blog Post: Pushing Data from a Database into a Word Document

    First off I want to thank everyone for leaving comments suggesting future posts about the Open XML SDK. Looking at some of the comments from previous posts , I noticed there were several requests around generating a Wordprocessing document from external data. I have showed you how to accomplish this...
Page 1 of 2 (39 items) 12