Probably the most underrated & underused Component of Xcelsius is the Spreadsheet Table component. Spreadsheet Table component is the “what-you-see-is-what-you-get” component, meaning the look of your Excel sheet will be replicated exactly on your Spreadsheet table component. So all the number formats, shading, fonts etc everything gets duplicated in this component.In the Dashboard below Spread sheet table acts as both a Picture (Grey Table) and as a selector (Blue Table)


Lets first discuss some good things about this; Spreadsheet table can be used both as a picture and as a filter or a selector.
Spreadsheet table can act as a simple snapshot of a Table present in the Excel sheet and the values of the cells in the component of your dashboard will change with the change in values of the table in Excel sheet. The best thing is that you can use all the formatting skills that you have learnt over the years and replicate them in your dashboard through this component.
One important point when you use this Component as a Picture of the Excel Table is that you need to disable its selection ability. This is because, otherwise one of your Spreadsheet table rows will always be highlighted, and if the user unknowingly clicks on any other row, that row will get highlighted. This can be avoided by going to
PROPERTIES>BEHAVIOUR>COMMON>ROW SELECTABILITY and unchecking the Checkbox next to “ROW” as shown in the picture.

Selector: Unlike other selectors Spreadsheet table does not have a host of selecting options. We have only two here 1.Value & 2. Row. One important thing is that both depend on the row value of the Spreadsheet table i.e. the selection will be based on the Row number of the cell that is clicked and in no way is related to the Column of that cell. So when I have insertion type as ‘Value’, the Row number of the Row will get pasted in your destination and when ‘Row’ is your insertion type, the row matching the row number of the Selected (or clicked row) from your source data will be pasted in your destination.
One important thing to keep in mind when using Spreadsheet table as a selector is that generally the first row of the table is of labels or Metric Names, we generally do not want this first row to be a part of our selection. So to do this we uncheck just the check box next to ROW1 as shown in the image.

Now coming to ‘Not So Good’ things about the Spreadsheet table component;
1.    Sometimes you might have to realign your component to the Excel table to let your formatting changes take effect in your component.
2.   The data being displayed should not be too large as it might affect your dashboard’s performance

  1. gravatar

    # by Jim - August 28, 2009 at 11:57 AM

    So we cannot filter rows using this component..?


  2. gravatar

    # by Analyst - November 10, 2009 at 11:19 PM

    No, as of now there are only two options
    1. Position
    2. Row
    May be in future they might include it

  3. gravatar

    # by Nodoubt's Library - April 27, 2010 at 11:25 PM

    Hi, i'm working hard to link the spreadsheet component with Excel dynamic data, but actually, each time i run preview the file hangs, and open with no display, i don't know whay this is happening, do you have any idea... and the imp thing.. can the spreadsheet comp be linked to a dynamic data or it only shows a static excel inof. also appreciate if you can send me the above example source file, my email is m_f_a_g@hotmail.com ... thanks a lot

  4. gravatar

    # by Analyst - April 30, 2010 at 10:20 PM

    Hi Nodoubt,
    I have mailed you the source files.
    Yes, spreadsheet table can be used with dynamic data, I guess there is some other issue that you are facing. Let me know the details of your dashboard and I can get back to you with a solution

  5. gravatar

    # by Anonymous - September 16, 2011 at 8:35 PM

    Very nice article, I have used excel spread sheet component with heading as a merged cell but when I import the data it is loosing its merging capability, did you ever get a chance to resolve this issue??

Blog Widget by LinkWithin

Search this blog..