Problem Getting Page Count for office(excel) documents using DSOFile.OleDocumentPropertiesClass

Question

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

Answer 1

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

Answer 2

I have used automation for excel files and dso file for other formats, As i can't fild any solution regarding it.