Book Image

A JavaScript Project to Create a CSV File from Google Spreadsheets [Video]

By : Laurence Svekis
Book Image

A JavaScript Project to Create a CSV File from Google Spreadsheets [Video]

By: Laurence Svekis

Overview of this book

<p>Did you want to create a download file option for your web visitors, downloading content from data and even a Google spreadsheet? </p><p>No libraries, no shortcuts, just learning JavaScript to make a DYNAMIC and INTERACTIVE web application. All are done with JavaScript. </p><p> </p><p>Course Covers </p><p>• Setting up a default data object </p><p>• Generating a downloadable text file on the fly using JavaScript </p><p>• Generating a downloadable CSV file on the fly </p><p>• Element select and style manipulation </p><p>• Adding event listeners to elements </p><p>• Elements as objects in JavaScript </p><p>• createObjectURL method to create file URLs </p><p>• Cleaning and restructuring of data objects for CSV </p><p>• Adding elements and removing elements from the web page </p><p>• Use of regex to search and JavaScript to update strings </p><p>• Use of fetch to get Google Spreadsheet JSON feed </p><p>• Setup of Google Spreadsheet JSON </p><p>• Restructuring JSON to array format for CSV file </p><p>• Source code is included so you can try the code and build your version of the application. </p><p> </p><p>Allow web visitors to download a current copy of the spreadsheet from a link, all front-end and done dynamically with JavaScript. Start building your version of the game today! </p><p> </p><p>All the code files are placed at https://github.com/PacktPublishing/JavaScript-CSV-File-Creator---Google-Sheets-to-CSV-Project</p>
Table of Contents (2 chapters)
Chapter 2
avaScript application to create files - Google Sheet data to CSV file
Content Locked
Section 1
Setup CSV Maker web application using HTML and JavaScript
Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript