ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to read workbook (not worksheet) properties with OLEDB (https://www.excelbanter.com/excel-programming/406912-how-read-workbook-not-worksheet-properties-oledb.html)

ForeverDad

How to read workbook (not worksheet) properties with OLEDB
 
I am attempting to read a workbook's properties such as Date1904. I
have confirmed that property is not in the individual worksheets.
Using brute force I discovered the flag in byte 765 of some .XLS
files, but I presume that the location is undocumented and unreliable
across all current and future versions of Excel. I need to verify
that 4 year offset (1462 days) but have no idea how to view workBOOK
properties with OLEDB.

I know I could open the Excel Workbook Object as an Application, but I
am running this on a web server and opening an instance of Excel isn't
scalable - it takes a couple seconds each time to open. Is there
another way to get the workbook properties using OLEDB such as the
flag for Date1904? Thanks!


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com