Welcome to MSDN Blogs Sign in | Join | Help

Excel (RSS)

Information specifically about Excel
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, 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
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
Tuesday, January 02, 2007 2:28 PM

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
Posted by BrianJones | 0 Comments
Wednesday, November 15, 2006 5:29 PM

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
Posted by BrianJones | 4 Comments
Thursday, November 02, 2006 10:50 AM

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
Posted by BrianJones | 7 Comments
Friday, October 27, 2006 2:29 PM

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
Posted by BrianJones | 10 Comments
Thursday, October 26, 2006 3:24 AM

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,
Posted by BrianJones | 22 Comments
Wednesday, October 25, 2006 2:34 AM

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
Posted by BrianJones | 31 Comments
Tuesday, July 18, 2006 10:57 AM

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
Posted by BrianJones | 0 Comments
Monday, May 29, 2006 4:05 AM

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