Skip to content

githubocto/flat-demo-xlsx

Repository files navigation

Flat Data Demo: XLSX to CSV

This demo is part of a larger Flat Data project created by GitHub OCTO. Read more about the project here.

What this demo does

This repository uses a Flat Data Action to fetch a XLSX file from an http endpoint every 15 minutes. Using a postprocessing script, Flat converts the XLSX file to a CSV file.

Inside .github/workflows/flat.yaml:

- name: Fetch data
        uses: githubocto/flat@v3
        with:
          http_url: https://www.mobileconnectivityindex.com/widgets/connectivityIndex/excel/MCI_Data_2020.xlsx
          downloaded_filename: mobile-connectivity.xlsx # The http_url gets saved and renamed in our repository as this file
          postprocess: ./postprocess.ts # A postprocessing javascript or typescript file written in Deno

diagram

Postprocessing

Refer to the Flat postprocessing library for more helper functions and examples for writing postprocessing scripts.

License

MIT

Releases

No releases published

Packages

No packages published