DEV Community

Cover image for How to Add an Excel-like Table to Your Astro Site (the Easy Way)
Camdyn Rasque
Camdyn Rasque

Posted on

How to Add an Excel-like Table to Your Astro Site (the Easy Way)

Cross post from my article on the Zing blog.

The philosophy of Astro is one of performance, flexibility, and customization. A web framework that prides itself on rendering as much as it can on the server first, allowing you to choose where your content lives, and giving you as many handles as possible to customize it how you like. The datagrid library you go with should be the same.

A beautifully rendered ZingGrid data table featuring custom row colors, emoji formatting, and column templates

Initial Setup - Installing Astro

First things first, we have to setup a basic app—we'll do that by following the prompts in the following command

npm create astro@latest

Gif showing the result of executing npm create astro@latest

Initial Setup - Including ZingGrid Library

The library itself should be included as a script in the front-end (preferably deferred using defer) for a few reasons:

  • It needs to be included exactly once
  • While the library itself is small for the sheet volume of features it packs (~259kb compressed), it is too big to be inlined in the HTML and maintain RAIL
    • Quick side note: the is:inline directive in Astro really means to opt the script out of any bundling and processing, not that the script will actually be fetched and swapped in place during the build process
  • A direct integration is not needed as ZingGrid was already build with similar philosophy to Astro in mind

src/layouts/Layout.astro

<!-- ... --->
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="description" content="Astro description">
  <meta name="viewport" content="width=device-width">
  <link rel="icon" type="image/svg+xml" href="/favicon.svg" />
  <meta name="generator" content={Astro.generator} />
  <title>{title}</title>
  <!-- ZingGrid Library -->
  <script is:inline defer src="/zinggrid.min.js"></script>
</head>
<body></body>
</html>
Enter fullscreen mode Exit fullscreen mode

Creating the Activity Tracker Grid

We'll start with the simplest grid we can make and build up from there. First things first, we create a ActivityGrid.astro component in our src/components directory and add the following code.

We'll be passing our data to this component, so we create a prop for that, and we hand it to <zing-grid> using the data attribute.

src/components/ActivityGrid.astro

---
const { data } = Astro.props;
---

<zing-grid data={data}></zing-grid>
Enter fullscreen mode Exit fullscreen mode

Over in our index.astro page in src/pages, we need to add our grid to the page. To do this we'll first need to import the component in our frontmatter (fenced off by ---), and we'll need to pull in our sample JSON as well. Now the only thing we have to be careful of is that we stringify the JSON as it will be passed into <zing-grid> as an attribute.

src/pages/index.astro

---
import Layout from '../layouts/Layout.astro';
import ActivityGrid from '../components/ActivityGrid.astro';

import activityData from '../data/activities.json';
const activityDataStr = JSON.stringify(currencyData);
---

<Layout title="ZingGrid + Astro">
  <header> <!-- ... --> </header>
  <main>
    <ActivityGrid data={activityDataStr} />
  </main>
</Layout>
Enter fullscreen mode Exit fullscreen mode

When we load up the page, we'll see a grid that looks like this. Nothing fancy yet, but surprisingly easy to get something going.

A plain basic chart with no caption, no color, no anything.

Adding User Controls and a Caption

To enhance our grid we'll start by configuring our element. With 100+ attributes to choose from the element has a ton of configuration available to it, but I'll pick out a few I think will be useful to us here:

  • layout : Determines whether or not the grid is shown in row or card mode
  • layout-controls : Allow / prevent users from changing the layout mode
  • sort : Add controls to sort each column
  • pager : Paginates the grid instead of leaving it as one long list
  • page-sizer : The number of rows for each page

We'll also add a <zg-caption> inside of our <zing-grid> so we can give our grid a title

---
const { data } = Astro.props;
---

<zing-grid
  data={data}
  layout="row"
  layout-controls="disabled"
  sort
  pager
  page-size="6"
>
  <zg-caption>💃🏼 Activity Tracker</zg-caption>
</zing-grid>
Enter fullscreen mode Exit fullscreen mode

The plain basic chart now has a caption and some pagination.

Formatting the Columns

Having a Distance column without any units makes it a bit hard to read. Luckily ZingGrid allows us to create templates for our columns. We can access the values from our row entry using the index object inside of [[double bracket]] notation. Below is a sample of what our data looks like for reference, the "distance" key is what we're pulling in when we write [[index.distance]] in the template.

src/data/activities.json

[
  {
    "activityType": "Outdoor Bike",
    "city": "Tempe",
    "date": "10/17/24",
    "distance": "48.27",
    "elapsedTime": "03:26:35",
    "movingTime": "01:53:15",
    "state": "Arizona"
  },
  /* ... */
]
Enter fullscreen mode Exit fullscreen mode

src/data/ActivityGrid.astro

<zing-grid
  data={data}
  layout="row"
  layout-controls="disabled"
  sort
  pager
  page-size="6"
>
  <zg-caption>💃🏼 Activity Tracker</zg-caption>
  <zg-colgroup>
    <zg-column index='date'></zg-column>
    <zg-column index='activityType'></zg-column>
    <zg-column index='city'></zg-column>
    <zg-column index='state'></zg-column>
    <zg-column index='distance'>[[index.distance]] mi</zg-column>
    <zg-column index='elapsedTime'></zg-column>
    <zg-column index='movingTime'></zg-column>
  </zg-colgroup>
</zing-grid>
Enter fullscreen mode Exit fullscreen mode

And the result is the mi unit being added to each Distance value just as in our template

The same chart from before now has

Styling the Grid with CSS Vars and Open Props

ZingGrid is built with modern native web components for performance and resiliency, but as a side effect of that a lot of the components exist inside Shadow DOMs. Still wanting to allow users to style any part they desire, hundreds of CSS Variables were created to pierce these shadows. Below we show how they can be used in conjunction Open Props for added flexibility.

<style>
  zing-grid {
    --zg-body-color: var(--gray-8);
    --zg-caption-background: white;
    --zg-caption-border-bottom: 1px solid var(--gray-3);
    --zg-caption-color: var(--gray-8);
  }
</style>
Enter fullscreen mode Exit fullscreen mode

Custom Cell Render Functions

To add some extra life to our grid it would be nice to be able to dynamically add an emoji in front of each activity. To do this, we'll create a function called activityRender on the window object (so it's accessible to ZingGrid) and add specify the function name the renderer attribute for the <zg-column> we want to apply it to. Inside this function we'll have the record text passed into us that we can then modify before it gets inserted into the cell.

<zing-grid>
  <!-- ... -->
  <zg-colgroup>
    <!-- ... -->
    <zg-column index='activityType' renderer='activityRender'></zg-column>
    <!-- ... -->
</zing-grid>

<script>
  window.activityRender = function (record) {
    let sportEmoji = '';
    if (record === 'Outdoor Bike') sportEmoji = '🚴‍♂️';
    else if (record === 'Sport') sportEmoji = '⛳️';
    else if (record === 'Run') sportEmoji = '🏃‍♂️';
    return `${sportEmoji} <strong>${record}</strong>`;
  };
</script>
Enter fullscreen mode Exit fullscreen mode

The same chart from before now has emojis next to each corresponding activity type.

Dynamically Adding Classes to Rows

And then finally to color each row based on the activity type, we can use the row-class attribute to pass a function that will dynamically add a class to each row.

<zing-grid
  row-class="activityClassRender"  
>
  <!-- ... -->
</zing-grid>

<script>
  // ...
  window.activityClassRender = function(record, rowIndex, rowDOMRef) {
    let rowCQlass = '';
    let activity = record.activityType;
    if (activity === 'Outdoor Bike') rowClass = 'outdoor-bike';
    else if (activity === 'Sport') rowClass = 'sport';
    else if (activity === 'Run') rowClass = 'run';
    return rowClass;
  }
</script>
Enter fullscreen mode Exit fullscreen mode

We'll then need to create those classes in a global CSS style block as the <zg-row>s are created dynamically on the front-end and thus do not get tagged with the usual style scoping attributes that Astro adds at build time.

<style is:global>
  zing-grid zg-row.outdoor-bike {
    --zg-row-color: var(--blue-8);
  }

  zing-grid zg-row.sport {
    --zg-row-color: var(--teal-8);
  }

  zing-grid zg-row.run {
    --zg-row-color: var(--red-8);
  }
</style>
Enter fullscreen mode Exit fullscreen mode

Et Voilà! 😄 We have a dynamically styled and formatted ZingGrid inside of Astro

The same chart from before now has color coordinated rows based on activity type.

Final Thoughts

With just a little configuration and very little code we were able to construct a robust and dynamic datagrid that fit with our Astro site. We've only scratched the surface of what ZingGrid can do in this article, so there will be a part 2 later on to show what the library can truly do, so watch out for that here if you're interested.

Top comments (1)

Collapse
 
discord-tools profile image
Jenny C

Sick thanks helpful tips!