Revit.SDK.Samples.RoomSchedule.XlsDBConnector.XlsDBConnector C# (CSharp) Method

        public XlsDBConnector(String strXlsFile)
        {
            // Validate the specified
            if (!ValidateFile(strXlsFile)) {
                throw new ArgumentException("The specified file doesn't exists or has readonly attribute.", strXlsFile);
            }

            // establish a connection to the data source.
            m_connectStr = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = \"" + strXlsFile +
                "\"; Extended Properties = \"Excel 8.0;HDR=YES;\"";

            // create the .xls connection
            m_objConn = new System.Data.OleDb.OleDbConnection(m_connectStr);
            m_objConn.Open();
        }