Intro to Excel XML Part 2: Displaying your data

Intro to Word XML Part 2: Simple Formatting

Brian Jones: Open XML Formats — Mon, 12 Mar 2007 20:02:13 GMT

If you read Part 1 of the Word XML Introduction, you saw the basics behind a Word document, as well as

re: Intro to Excel XML Part 2: Displaying your data

I'm Brian Jones — Mon, 08 May 2006 17:57:12 GMT

Glad to help Paul. I want to make some posts on the new SpreadsheetML that's coming with Office 2007 too...

-Brian

re: Intro to Excel XML Part 2: Displaying your data

Paul Goldman — Mon, 08 May 2006 17:48:22 GMT

Brian,

Just wanted to say thank you for the MS Excel XML info. In one place I finally found clear, concise, understandable explanations with simple but informative examples.

When you publish it in book form, let me know.

Thanks,
Paul

re: Intro to Excel XML Part 2: Displaying your data

Ivan — Tue, 18 Apr 2006 21:33:19 GMT

Would you be able to cover different data types which are supported by ExcelML? It seems that you are using only type String, I wonder what other types supported to create a strong typed ExcelML file.

Thank you.

re: Intro to Excel XML Part 2: Displaying your data

C-W Stenberg — Fri, 03 Mar 2006 13:29:18 GMT

Hi again!

Tnx for the answer.

The xslt file is the one in your example above so it should be fine. I have tried different locations for it, when it could be a problem with my domain connected workstation.
Anyway, I have move the transformation into my app to make this feature transparent to my users.

I have some other questions. Is there any documentation for this excel/office feature?

Is there a way to make the columns in the excelML file auto sized?

Tnx

re: Intro to Excel XML Part 2: Displaying your data

I'm Brian Jones — Fri, 24 Feb 2006 18:37:11 GMT

I'm not sure why that is /C-W

Where is the XSLT located? The only times we block an XSLT in that security mode should be if it's not in a trusted location, or if it has any script in it. If it has script, than the XSLT also needs to be signed.

I could be wrong though (it's been a few years since we designed all that), so if you're still having problems let me know.

-Brian

re: Intro to Excel XML Part 2: Displaying your data

C-W Stenberg — Fri, 24 Feb 2006 11:13:07 GMT

Good article!

Question: How to handle the excels macro security with xslt files. Excel will give a error message on the example above when the highest security level is set.

Tnx for the help

/C-W

re: Intro to Excel XML Part 2: Displaying your data

I'm Brian Jones — Wed, 05 Oct 2005 03:14:41 GMT

No problem! :-)

Let me know if there are other topics you'd like to see covered.

-Brian

re: Intro to Excel XML Part 2: Displaying your data

Sathi — Wed, 05 Oct 2005 02:32:11 GMT

Hi Brian,

This was very useful, especially for complex formatting. Thanks.

Sathi

Intro to Word XML Part 2: Simple Formatting

Brian Jones: Office XML Formats — Tue, 19 Jul 2005 03:09:59 GMT

If you read Part 1 of the Word XML Introduction, you saw the basics behind a Word document, as well as...