验证Excel电子表格？ [英] Validate Excel Spreadsheet?

问题描述

您好

OpenXML SDK是否提供了验证Excel电子表格.xslx在语法上是否正确且格式正确的方法？

如果有，那么它是如何完成的？

好奇，是否有用于验证OpenXML Excel文件的标准XML Schema文件？

解决方案

OpenXmlPackage 类（ SpreadsheetDocument 的基类）具有执行验证的Validate方法。

当使用null参数调用时，它只会在遇到第一次违规时抛出 OpenXmlPackageException 。
或者可以使用 OpenXmlPackageValidationSettings ，用于配置验证失败事件的事件处理程序。

可以下载完整的OpenXML模式集此处。

Hi

Does OpenXML SDK provide a way to validate if an Excel spreadsheet .xslx is syntactically correct and well-formed?

If so, then how is it done?

Curious, is there a standard XML Schema file used to validate OpenXML Excel files?

解决方案

The OpenXmlPackage class (the base class of SpreadsheetDocument) has a Validate method that performs validation.

When called with a null argument it simply throws an OpenXmlPackageException when it encounters the first violation.

Alternatively it may be called with an OpenXmlPackageValidationSettings which configures an event handler for validation failure events.

The full set of OpenXML schemas can be downloaded here.

这篇关于验证Excel电子表格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！