Describe XLSM files in Excel 2007
In this article i am going to explain about how to use xlsm files in excel 2007.
Introduction
Xlsm files
It's for connecting to Excel 2007 files with the Xlsm file extension. That is the Office Open XML format with macros enabled.
|
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\sam007\myExcel2007file.xlsm;Extended Properties="Excel 12.0 Macro;HDR=YES";
|
Note-<br/>The quota " in the string needs to be escaped using your language specific escape syntax.<br/> c#, c++ \"<br/> VB6, VBScript ""<br/> xml (web.config etc) &quot;<br/> or maybe use a single quota
"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