使用 DSOFile.OleDocumentPropertiesClass 获取 Office(excel) 文档的页数时出现问题

发布于 2024-08-10 14:21:41 字数 542 浏览 4 评论 0原文

我正在使用 DSOFile.OleDocumentPropertiesClass 来获取 Office 文档的页数，而无需自动化。这对于 docx 和 pptx 文件效果很好，但对于 xlsx 文件总是返回 0。

DSOFile.OleDocumentPropertiesClass oleDocument = new DSOFile.OleDocumentPropertiesClass();
oleDocument.Open(documentFilePath, true, DSOFile.dsoFileOpenOptions.dsoOptionOpenReadOnlyIfNoWriteAccess);

//WORKS FOR DOCX
int pageCount = oleDocument.SummaryProperties.PageCount;


//WORKS FOR PPTS
int pageCount = oleDocument.SummaryProperties.SheetCount;

//NONE OF ABOVE WORKS FOR XLSX, IT ALWAYS RETURNS 0

原文

I am using DSOFile.OleDocumentPropertiesClass for getting the page count for office documents without automation. This works fine for docx and pptx files but returns always 0 for xlsx files.

DSOFile.OleDocumentPropertiesClass oleDocument = new DSOFile.OleDocumentPropertiesClass();
oleDocument.Open(documentFilePath, true, DSOFile.dsoFileOpenOptions.dsoOptionOpenReadOnlyIfNoWriteAccess);

//WORKS FOR DOCX
int pageCount = oleDocument.SummaryProperties.PageCount;


//WORKS FOR PPTS
int pageCount = oleDocument.SummaryProperties.SheetCount;

//NONE OF ABOVE WORKS FOR XLSX, IT ALWAYS RETURNS 0

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

-小熊_ 2024-08-17 14:21:41

好吧，DSOFile 也不适合我，作为替代方案，您可以使用 OleDB 连接到 xls(x) 文件并获取其内容详细信息。下面是一个示例：

OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\1.xlsx;Extended Properties=Excel 8.0");
connection.Open();
DataTable dataTable = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

if (dataTable == null) return;

foreach (DataColumn column in dataTable.Columns)
  Console.Write(column.ColumnName + '\t');
Console.Write('\n');
foreach (DataRow row in dataTable.Rows)
{
  foreach (DataColumn column in dataTable.Columns)
    Console.Write(row[column].ToString() + '\t');
  Console.Write('\n');
}

只需确保安装了 Office 2007 系统驱动程序（Microsoft.ACE.OLEDB.12.0 oledb 提供程序），

如果您仅处理 Excel 2007 电子表格，则可以考虑使用 ExcelPackage (http://excelpackage.codeplex .com/）工具，它应该能够从 Excel 电子表格中读取数据，而无需自动化

well, DSOFile doesn't work for me either, as an alternative you can use OleDB to connect to an xls(x) file and get its content details. Below is an example:

OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\1.xlsx;Extended Properties=Excel 8.0");
connection.Open();
DataTable dataTable = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

if (dataTable == null) return;

foreach (DataColumn column in dataTable.Columns)
  Console.Write(column.ColumnName + '\t');
Console.Write('\n');
foreach (DataRow row in dataTable.Rows)
{
  foreach (DataColumn column in dataTable.Columns)
    Console.Write(row[column].ToString() + '\t');
  Console.Write('\n');
}

just make sure you have the Office 2007 system driver (Microsoft.ACE.OLEDB.12.0 oledb provider) installed

if you're dealing only with Excel 2007 spreadsheets you can consider using ExcelPackage (http://excelpackage.codeplex.com/) tool, it should be able to read data from the excel spreadsheet without automation

回复收藏 0 原文