LogoLogo
FeaturesHelp & ResourcesShowcasePricingLogin
Learn Section
Learn Section
  • Introduction
  • Getting Started
    • Finding your way around
    • Core concepts
      • Data Binding
      • Data Insertion
      • Dynamic Visibility
    • Creating and managing projects
      • Creating a Project
      • Saving a Project
      • Opening a Project
      • Version History
    • Templates
  • Components
    • Overview
    • Layout & Positioning
    • Charts
      • Line Chart
      • Column Chart
      • Bar Chart
      • Pie Chart
      • Combination Chart
      • Area Chart
      • Spline Chart
      • Step Chart
    • DataViz
      • Gauge
      • Word Cloud
      • Chord Diagram
      • Sankey Diagram
      • Schedule (Gantt)
      • Metric Tile
      • Progress Bar
      • Trend Icon
      • Mapbox
      • Loading Animation
    • Tables
      • Scorecard
      • Data Table
    • Controls
      • Push Button
      • Dropdown
      • Multi Select Dropdown
      • Listbox
      • Label Based Menu
      • Checkbox
      • Radio Button
      • Slider
      • Value Input
      • Print Button
      • URL Button
      • Screenshot
      • Hotspot
      • Date Picker
      • Toggle Switch
      • Scenario
    • Text
      • Text Label
      • Text Input
      • Text Area
    • Shapes
      • Rectangle
      • Ellipse
      • Line
    • Media
      • Image
      • Icon
    • Containers
      • Container
      • Web View
      • Repeat Container
      • Row Layout
      • Column Layout
  • Functions
    • Overview
    • Data Mover
    • External Parameters
    • Export to Excel
    • Export to PDF
    • Timer
    • Tableau Parameters
    • Browser Info
    • TextJoin
    • Unique List
  • Connections
    • Overview
    • Excel One Drive
      • Excel One Drive Read
      • Excel One Drive Writeback
    • Google Sheets
      • Google Sheets Read
      • Google Sheets Writeback
    • Ninox Connections
    • Smartsheets
    • CSV Connector
    • SAP Webi Connector
    • XDC Connections
    • Database Connections
    • Zapier Trigger
  • Spreadsheet
    • Overview
    • Spreadsheet functionality
    • Supported Spreadsheet Functions
    • Spreadsheet performance
  • Best practices for the Squirrel spreadsheet
  • Publishing & Sharing
    • Overview
    • Project Settings
    • Publishing to Squirrel Cloud
    • Publishing Locally
    • Using the Project Manager
    • Adding projects to PowerPoint
    • Adding projects to Tableau
    • Progressive Web Apps (PWA)
  • SETTINGS
    • Image Library
    • Custom Fonts
  • Account Management
    • Manage your account Profile
    • Understanding your Squirrel plan usage
    • Changing your Plan
    • Billing
    • How do I delete my account?
  • Frequent Questions
    • What data do you keep and for how long?
  • How-Tos
    • Overview
    • Add-ons
      • Add-on Documentation
      • Window Size – Add responsive behavior to your components
      • Window Size - Getting responsive behavior in the canvas
    • Adding your own Google Fonts
    • Chart title and Checkbox label text case formatting
    • Deleting functions and connections
    • Find & Replace Fonts
    • Getting a Mapbox API access token
    • Renaming a component, function or connection
    • Seeing Data from a Connector at Design time
    • Troubleshooting Projects in the Console
    • Using colors and color values
  • Tutorials
    • Cascading Dropdowns
    • Create a temperature conversion app
    • Create a revenue growth app from an existing spreadsheet
    • Whack-A-Squirrel Game
    • Filtered Rows Insertion: Building a Filtered Selection
Powered by GitBook
LogoLogo

Explore

  • Home
  • Features
  • Pricing
  • Download Squirrel

Help

  • Learn
  • Community
  • Support
  • FAQ's

Updates

  • Blog
  • Events
  • Release Notes

Company

  • Contact Us
  • Privacy Policy
  • Terms of Use

Copyright © 2019 - 2024 InfoSol Ltd. All rights reserved.

On this page
  • Data Table Properties
  • GENERAL
  • TABLE STYLING
  • DATA INSERTION

Was this helpful?

  1. Components
  2. Tables

Data Table

This article describes the Date Table component and its properties.

PreviousScorecardNextControls

Last updated 4 months ago

Was this helpful?

Who can use this feature?

All Squirrel365 plans include the Data Table component.

For more details, see our .

Squirrel 1.12 introduced a “Quick Set-up” tab on many property panels. The properties described on this page are available on the “All Properties” tab of the property panel. For more details on “Quick Set-Up” properties see

The purpose of the Data Table component is to show a graphical representation of some or all of the contents of the Squirrel project spreadsheet on the canvas of the same Squirrel project.

Select Data Table from the Tables category of the component library. Move the mouse cursor over the canvas and click to add a data table to your project:


Data Table Properties


GENERAL

  • Data to Display – Bind the Data to display property to a cell or range of cells in the spreadsheet. The range of cells must be continuous.

  • Fix header row when scrolling – If the cells bound to the Data to Display property include a header row and you want that header to remain visible when the content is scrolled vertically, check the Fix header row when scrolling checkbox.

  • Ignore blank – If you don’t want any empty rows or columns (at the end of the Data to Display range) included in the data table, keep the Ignore blank Rows and Columns checkboxes checked. Suppose the spreadsheet is subsequently updated and data is inserted into those previously empty rows or columns. In that case, the data table component will also update to include those previously ignored rows or columns. The image below illustrates how empty columns have been included in the Data to display range:


TABLE STYLING

  • Update formatting – If you change the format of some of the data in the spreadsheet, for example, you may make the contents of a cell Bold and increase the font size, click the Update formatting button for that new formatting to be applied to the corresponding data in the data table.

  • Show spreadsheet gridlines – Check or uncheck the Show spreadsheet gridlines checkbox to show or hide the gridlines in the data table. Note: this setting does not affect the gridlines that you see in the spreadsheet.


DATA INSERTION

The data table allows for multiple series of data insertion. At present there is only one type, the Position type, but more types will be added to this component in the future.

  • Series – In the Series property field, a default series (Series 1) is already selected. Add multiple series by clicking the plus button above the property field. As only one type of data insertion is currently available, there is no reason to have more than one series at present.

  • Name – Rename the selected series, if you wish, by entering a new name in the Name property field.

  • Type – Select the type of data insertion to use from the dropdown list:

  • Position – Each row of the Data Table component is identified by a position value. The first row (underneath the header) is position 1, the second row is position 2, and so on. Clicking each row will place its position value into the destination cell.

  • Source – Not required for the Position type.

  • Destination – For the Position type, select a single cell for the Position value to be entered into.

There are four property drawers, GENERAL, TABLE STYLING, DATA INSERTION and DYNAMIC VISIBILITY. This guide will not describe the dynamic visibility properties as these are generic to each component, a separate guide and tutorial on Dynamic Visibility can be found .

here
pricing comparison matrix
this article