The compile is successful and I can download the spreadsheet that I generate.

but when the document which I generate is being open.

it tells me the file is corrupted, but I don't know how and where.

Is there anyway to validate my document including relationship checking and make debugging easier?

Have you tried the built-in Validation-methods in the SDK?

How to: Validate the Contents of a Document Part in an Office Open XML Package by Using the Open XML API
http://msdn.microsoft.com/en-us/library/bb521234.aspx

How to: Validate an Office Open XML Package against a Collection of Schemas by Using the Open XML API
http://msdn.microsoft.com/en-us/library/cc547024.aspx

How to: Validate an Office Open XML Package by Using the Open XML API
http://msdn.microsoft.com/en-us/library/bb497334.aspx

I am not sure it does relation-ship validation, though.

/Jesper

Btw,

I just read up in the Help-files from the SDK and for the method

OpenXmlPackage.Validate()

the text is:

Validates the package. However, it does not validate the XML content in each part.

I would think that it would indeed validate the relations - the question is, though, if it only validates the package relationships or if it also validates e.g. inline relationships from SpreadsheetML-cells to their corresponding sharedStrings-Part.

I think the Validate() is doing the later one which you mention.

I have a PageSetup that reference to a not exsisting .xml and it still passes the Validate() method.

This method is useless to me.

it would be nice to have 1 validate method that can validate the entire package, i'm having an issue with a SpreadsheetDocument that passes validate but throws an error when you open it in Excel.

** plus i think it's a nice double check to run in unit tests for export code

Anyone have a good way to validate the doc before we save a corrupt file?