Posts Tagged ‘excel’

Excel File Viewer 2.2

Monday, January 21st, 2013

Just now I published the new version for Excel File Viewer: http://www.scalabium.com/xls

Also today I changed the parser for .wb3 files (QuattroPro) and now the multisheet files (workbook) supported too.

Excel file validation

Friday, November 4th, 2011

http://support.microsoft.com/kb/2501584

Excel: check if a workbook has been changed

Friday, January 15th, 2010

The Wokbook interface have the boolean Saved property:

if xls.Workbooks.Item[i].Saved then 
    ...

ADO connection string and Excel 12

Monday, October 6th, 2008

xlsx:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties=“Excel 12.0 Xml;HDR=YES;IMEX=1″;

xlsb:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;Extended Properties=“Excel 12.0;HDR=YES”;

xlsm:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;Extended Properties=“Excel 12.0 Macro;HDR=YES”;

See also my prev. post about driver download: http://blog.abadev.com/?p=1030