Describe XLSB files in Excel 2007

In this article i am going to explain about how to use xlsb files in excel 2007.
  • 1823

Xlsb files

This one is for connecting to Excel 2007 files with the Xlsb file extension. That is the Office Open XML format saved in a binary format.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\sam007\myBinaryExcel2007file.xlsb;Extended Properties="Excel 12.0;HDR=YES";

     "HDR=Yes;" indicates that the first row contains column names, not data. "HDR=No;" indicates the opposite.

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here


More Articles

© 2020 DotNetHeaven. All rights reserved.