aspose.cells

Class QueryTable

Represents QueryTable information.

Property Getters/Setters Summary
functiongetAdjustColumnWidth()
function
           Returns or sets the AdjustColumnWidth of the object.
functiongetConnectionId()
Gets the connection id of the query table.
functiongetExternalConnection()
Gets the relate external connection.
functiongetName()
Gets the name of querytable.
functiongetPreserveFormatting()
function
           Returns or sets the PreserveFormatting of the object.
functiongetResultRange()
Gets the range of the result.
 

    • Property Getters/Setters Detail

      • getConnectionId : Number 

        function getConnectionId()
        
        Gets the connection id of the query table.
      • getExternalConnection : ExternalConnection 

        function getExternalConnection()
        
        Gets the relate external connection.
      • getName : String 

        function getName()
        
        Gets the name of querytable.
      • getResultRange : Range 

        function getResultRange()
        
        Gets the range of the result.
        Returns:
      • getPreserveFormatting/setPreserveFormatting : boolean 

        function getPreserveFormatting() / function setPreserveFormatting(value)
        
        Returns or sets the PreserveFormatting of the object.
      • getAdjustColumnWidth/setAdjustColumnWidth : boolean 

        function getAdjustColumnWidth() / function setAdjustColumnWidth(value)
        
        Returns or sets the AdjustColumnWidth of the object.