Welcome to MSDN Blogs Sign in | Join | Help

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.

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

Comments

# Excel 2007

Wednesday, August 22, 2007 2:21 AM by Mangesh123

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

# re: Working With Excel's XML-Based File Formats

Wednesday, August 22, 2007 2:25 AM by David Gainer

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

# re: Working With Excel's XML-Based File Formats

Wednesday, August 22, 2007 4:44 AM by Mangesh

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

# re: Working With Excel's XML-Based File Formats

Wednesday, August 22, 2007 12:23 PM by David Gainer

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

# Microsoft Excel blog posts

Wednesday, August 22, 2007 2:55 PM by Walter Stiers - Academic Relations Team (BeLux)

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

# Microsoft Excel blog posts

Wednesday, August 22, 2007 3:57 PM by Noticias externas

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

# re: Working With Excel's XML-Based File Formats

Thursday, August 23, 2007 2:41 PM by Steve Dillinger

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

# re: Working With Excel's XML-Based File Formats

Thursday, August 23, 2007 4:07 PM by Jessica

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??

# re: Working With Excel's XML-Based File Formats

Thursday, August 23, 2007 4:07 PM by Jessica

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??

# re: Working With Excel's XML-Based File Formats

Friday, August 24, 2007 2:05 PM by Harlan Grove

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!!!

New Comments to this post are disabled
 
Page view tracker