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: Open XML and Office Services

    If you didn't see the news up on the Word team blog announcing Word Automation Services, and you have any interest in server side conversion of .docx files into .pdf or .xps, you should definitely go take a look: http://blogs.msdn.com/microsoft_office_word/archive/2009/10/26/introducing-word-automation...
  • 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: 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 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: Importing your XML into a spreadsheet

    I'm going to try to get back on top of all the e-mails folks have been sending me. If you've e-mailed me over the past 6 months the odds are that I didn't reply yet, and I'm sorry about that. I'll start reading through the e-mails again and rather than just replying directly I'll actually try to post...
  • Blog Post: Examples of programming with SpreadsheetML

    Erika is working on pulling together more coding examples for the OpenXML formats. We've seen a bunch of stuff around WordprocessingML, and now they are starting to work on some good examples with SpreadsheetML and PresentationML. So if you've ever wanted to build processes that consumed or generated...
  • Blog Post: Datawatch builds reports using SpreadsheetML

    Datawatch just announced the availability of Monarch V.9.0 which has the ability to output rich spreadsheet reports on data leveraging SpreadsheetML: http://www.datawatch.com/datawatch/news.asp?display=detail&id=128 This is pretty cool because they take advantage of the 300 pages of spreadsheet...
  • Blog Post: Using SpreadsheetML to generate rich reports of timesheet data

    Happy New Year everyone. I hope everyone was able to enjoy the holiday season. I took a couple weeks off in case you were wondering why there weren't any new blog posts. While I took some time off, I did still get a chance to play around with the file formats (I think I have a serious problem with...
  • Blog Post: Simple SpreadsheetML file (part 2 of 3)

    This is a continuation on the " Simple SpreadsheetML file Part 1 " post I made a couple weeks ago. In that post we created a SpreadsheetML file that consisted of a simple table with 3 columns and 3 rows of data (plus a header row). The table looked like this: Sub Total...
  • Blog Post: Simple SpreadsheetML file Part 1 of 3

    I posted a bunch of "Intro to SpreadsheetML" posts about a year or so ago, but those were all based on the Office XP spreadsheetML format. I think an updated series based on the Open XML standard is long overdue. I'll start off just building a simple table, and in future posts show more about formatting...
  • Blog Post: Friday thoughts (Oct 27, 2006)

    I'd been meaning to post a write-up on how to create a simple SpreadsheetML document from scratch, but just haven't had the time this week to pull it all together. Hopefully I'll get that out early next week. I had already done a similar post for WordprocessingML (both for Beta 1 as well as RTM ). Here...
  • Blog Post: Performance of an XML file format for spreadsheets

    I've blogged in the past about some of the things we did with the SpreadsheetML format to help improve the performance of opening and saving those files. While a file format most likely won't affect the performance of an application once the file is loaded, it can significantly impact the performance...
  • Blog Post: SpreadsheetML Dates

    Recently a couple people have questioned the decision to leave the legacy Excel date behavior in the Open XML formats. This was primarily triggered by a post from IBM's Rob Wier . While those folks have referred to it as an Excel bug, it's actually something that was purposely designed into Excel since...
  • Blog Post: Sample code for generating a SpreadsheetML file

    Doug Mahugh has another post on programmatically generating a basic Office Open XML file. This latest post shows how to create a simple SpreadsheetML file : This post covers the code for a CreateXlsx program that creates a simple Open XML spreadsheet from scratch using the .NET Framework 3.0 packaging...
  • Blog Post: Spreadsheet performance - Shared Formulas

    I wanted to follow up on the thread I started a couple weeks ago discussing the design goals behind spreadsheetML. There's a whole host of things we've done to make sure that the move to XML formats is a huge benefit to developers, without it actually having a significant negative impact on our end users...
  • Blog Post: Does tag size matter?

    Surprisingly, I haven't seen much information out there discussing the performance impacts of XML tag name lengths (ie using "<c>" instead of "<table-cell>"). My last post about some of the design goals behind SpreadsheetML raised some questions from folks about where the time is actually...
  • Blog Post: Design Goals Behind SpreadsheetML

    It's been awhile since I've talked in detail about the SpreadsheetML schema and I apologize. I had a number of posts back in the summer which talked through Office XP's SpreadsheetML format that we built about 6 years ago, but obviously a lot has changed since then. The new SpreadsheetML that is part...
  • Blog Post: Updated draft of the Open XML spec coming this month

    I'm in New York right now, and I was talking to some folks yesterday about the work that we've been doing in Ecma. It reminded me that I hadn't posted very much information on by blog though about how the meeting in London went last month. Adam Farquhar of the British Library posted a great summary of...
  • Blog Post: Comments from Tim Bray on OpenDocument

    I'm sorry to post about this subject with all the other stuff I've been promosing to cover but I just read this and wanted to share my thoughts. I was reading Tim Bray's post the other day about the OpenOffice conference ( http://tbray.org/ongoing/When/200x/2005/10/01/Open-Office-Conference ). He brought...
  • Blog Post: New blog on Excel '12'

    David Gainer has started a blog discussing the next version of Excel. David is the GPM of the Excel team, and this should be a great blog for those of you interested in Excel. http://blogs.msdn.com/excel In David's first post, he talks about an old limitation in Excel that is being increased. Because...
Page 1 of 2 (29 items) 12