ReadObjects Property (IWorkbookSet)

Gets or sets the property which specifies whether charts, pictures and drawing objects should be read when reading a workbook.

Syntax

Visual Basic
C#

'Declaration
 
Property ReadObjects As System.Boolean

'Usage
 
Dim instance As IWorkbookSet
Dim value As System.Boolean
 
instance.ReadObjects = value
 
value = instance.ReadObjects

System.bool ReadObjects {get; set;}

Remarks

Charts, pictures and drawing objects are read and written by default. Set this property to false to disable reading of charts, pictures and drawing objects when a workbook is read.

Note that setting ReadDrawingObjects to false will not disable reading of chart sheets.

Example

using System;
using SpreadsheetGear;
 
namespace ConsoleApplication
{
    /// <summary>
    /// Demonstrate a custom function which sums the range of cells or values passed to it.
    /// </summary>
    class Program
    {
        static void Main(string[] args)
        {
            // Create a new empty workbook.
            IWorkbookSet workbookSet = Factory.GetWorkbookSet();
 
            // Set to not read VBA or Objects (shapes).
            workbookSet.ReadVBA = false;
            workbookSet.ReadObjects = false;
 
            // Read MyWorkbook.xls without VBA or objects.
            IWorkbook workbook = workbookSet.Workbooks.Open("MyWorkbook.xls");
        }
    }
}

Visual Basic

Imports System
Imports SpreadsheetGear
 
 
Namespace ConsoleApplication
    _
    ' Demonstrate reading a workbook without VBA or objects (shapes).
    Class Program
 
        Public Overloads Shared Sub Main()
            ' Create a new empty workbook.
            Dim workbookSet As IWorkbookSet = Factory.GetWorkbookSet()
 
            ' Set to not read VBA or Objects (shapes).
            workbookSet.ReadVBA = False
            workbookSet.ReadObjects = False
 
            ' Read MyWorkbook.xls without VBA or objects.
            Dim workbook As IWorkbook = workbookSet.Workbooks.Open("MyWorkbook.xls")
        End Sub 'Main
    End Class 'Program
End Namespace 'ConsoleApplication

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IWorkbookSet Interface
IWorkbookSet Members
ReadVBA Property

See our live ASP.NET Excel Reporting, Excel Charting, Dashboards from Charts and Ranges, Excel Calculation and Excel to DataGrid Samples.

Copyright © 2003-2023 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Send Feedback