Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SpreadsheetML   (RSS)
Thursday, September 24, 2009 2:36 PM

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
Posted by BrianJones | 2 Comments
Thursday, September 17, 2009 12:44 PM

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,
Posted by BrianJones | 8 Comments
Monday, April 20, 2009 3:42 PM

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,
Posted by BrianJones | 8 Comments
Wednesday, April 01, 2009 5:45 PM

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
Posted by BrianJones | 4 Comments
Friday, March 13, 2009 10:25 AM

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
Posted by BrianJones | 6 Comments
Thursday, February 19, 2009 10:54 AM

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.
Posted by BrianJones | 5 Comments
Monday, November 10, 2008 7:00 PM

Reading Data from SpreadsheetML

In my last post , I showed you how to create a spreadsheet based on data from a database using the Open XML SDK. Today I am going to show you how to do the reverse, specifically, how to read data from a spreadsheet and insert it into some data source,
Posted by BrianJones | 6 Comments
Wednesday, August 15, 2007 1:32 PM

Why there’s no “Microsoft” in Open XML

Here are a couple cool screenshots from Stephen McGibbon where he shows an OpenXML spreadsheet file created with Gnumeric (runs on Linux & Windows), and the file is then opened up in Numbers (Apple's new spreadsheet app for the Mac). Gnumeric Numbers
Posted by BrianJones | 100 Comments
Friday, July 20, 2007 4:22 PM

Going offline for a week

I'll be offline for the next week or so. Sorry if I don't answer your e-mails or comments during that time. I'll try to get caught up early August. In the mean time though, check out this article up on eweek: Setting a New Standard As a user of OpenOffice.org
Posted by BrianJones | 5 Comments
Tuesday, July 17, 2007 12:54 PM

Open XML news

Here are a few interesting links related to the Open XML formats US technical committee reaches deadlock – Doug talks about how the discussions went in the US technical committee tasked with reviewing the Open XML formats. It sounds like they were just
Posted by BrianJones | 1 Comments
Monday, July 16, 2007 2:35 PM

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
Posted by BrianJones | 4 Comments
Thursday, July 12, 2007 7:21 PM

Spreadsheet formula bugs

I saw this blog post from Rob Wier the other day, and I thought it would be worth drilling into a bit more. While Rob tends to have a flare for the dramatics he does point out a couple of good bugs in the formulas piece of the Open XML spec. Rob's actually
Posted by BrianJones | 61 Comments
Tuesday, May 29, 2007 11:57 AM

Simple SpreadsheetML file Part 3 - Formatting

Over 5 months later, I've finally had some free time to pull together part 3 of my "Intro to SpreadsheetML" posts. I'll pick up where I left off in Part 2, so if you need a little refresher, please head back to the first 2 posts: Simple SpreadsheetML
Posted by BrianJones | 3 Comments
Wednesday, March 14, 2007 10:12 AM

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
Posted by BrianJones | 2 Comments
Tuesday, February 27, 2007 10:23 AM

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
Posted by BrianJones | 5 Comments
More Posts Next page »
 
Page view tracker