Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Excel

The team blog for Microsoft Excel and Excel Services.
Working With Excel's XML-Based File Formats

Some readers have expressed interest in working with and better understanding SpreadsheetML, part of the Open XML Formats recently standardized by Ecma International (I received a string of about a dozen emails in the last week or two asking how to do this or that with SpreadsheetML). I wanted to highlight a good resource that covers that specific ground: www.openxmldeveloper.org. The site has news content related to the Open XML Formats, a library of ‘how-to’ articles written up, and a forums section with various discussion topics & categories. Here’s a copy of their mission statement, to give you their view on why the site exists:

"The Open XML Formats Developer Group is being formed as a community for developers to exchange information with each other regarding the usage of the Ecma-developed Office Open XML file formats. The community will serve as a technical resource for Open XML developers to submit and answer technical questions and to share tools and ideas around Open XML Formats-based solutions. The Open XML Formats Developer Group is open to anyone free of charge to enable broad participation and development of solutions using the Open XML Formats on any platform. The Open XML Formats Developer Group will support the wide adoption of the specifications being created by Ecma Technical Committee 45.  More information is available at www.OpenXmlDeveloper.org.”

The site also points to the official Ecma specification as well.

Posted: Tuesday, August 21, 2007 1:29 PM by David Gainer
Filed under:

Comments

Mangesh123 said:

I would like to customize Excel 2007,

Please tell me how to remove office button appearing on top left corner of Excel 2007.

With regards

-Mangesh

# August 22, 2007 2:21 AM

David Gainer said:

Hi Mangesh - there is no way to remove the button.

# August 22, 2007 2:25 AM

Mangesh said:

Thanks David.

So can we disable drop down Pop-up from office button appearing in top left corner of Excel 2007 also what is control id and control type of Excel options button and Exit excel button.

With regards

-Mangesh

# August 22, 2007 4:44 AM

David Gainer said:

Hi again

There are a bunch of materials on Ribbon extensibility here - hopefully that answers your questions.

http://msdn2.microsoft.com/en-us/library/aa942866(VS.80).aspx

# August 22, 2007 12:23 PM

Walter Stiers - Academic Relations Team (BeLux) said:

Microsoft Excel blog has 2 recent post I would like to refer to: Working With Excel's XML-Based File

# August 22, 2007 2:55 PM

Noticias externas said:

Microsoft Excel blog has 2 recent post I would like to refer to: Working With Excel's XML-Based File

# August 22, 2007 3:57 PM

Steve Dillinger said:

All these new features are great- but there are still MANY bugs working with VBA.  I cannot make a remotely complex sheet w/ data connections and forms without excel 'losing' the form:

Run-Time error -2147352573 (800020003)

Could not find the specified object.

THATS IT!  My sheet is now toast forever.  I have to rip out that object (not easy because it can't be 'found' anymore) and reinsert it.  Easily several days worth of work to redo.  This has happens **frequently**.  I can send an example sheet if anyone cares.  - sdillinger@cornerstonetg dot com

# August 23, 2007 2:41 PM

Jessica said:

i need to know how to underline the current row that i am editing. it will just highlight or underline the specific row until i am finished editing that row.

Can you tell me how to do that??

# August 23, 2007 4:07 PM

Jessica said:

i need to know how to underline the current row that i am editing. it will just highlight or underline the specific row until i am finished editing that row.

Can you tell me how to do that??

# August 23, 2007 4:07 PM

Harlan Grove said:

Yes you can remove the Office button, but only as part of removing the entire UI. Not necessarily a bad idea.

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

XLM to the rescue!!!

# August 24, 2007 2:05 PM
New Comments to this post are disabled
Page view tracker