Switch to the store?

JavaScript Project - Create CSV file from Google Spreadsheets [Video]

More Information
Learn
  • How to use JavaScript
  • How to create elements dynamically
About

Did you want to create a download file option for your web visitors - downloading content from data and even a Google Spreadsheet?

No libraries, no shortcuts just learning JavaScript making it DYNAMIC and INTERACTIVE Web Application. All are done with JavaScript.

Course Covers

  • Setting up a default data object
  • Generating a downloadable text file on the fly using JavaScript
  • Generating a downloadable CSV file on the fly
  • Element select and style manipulation
  • Adding event listeners to elements
  • Elements as objects in JavaScript
  • createObjectURL method to create file URLs
  • Cleaning and restructuring of data objects for CSV
  • Adding elements and removing elements from the web page
  • Use of regex to search and JavaScript to update strings
  • Use of fetch to get Google Spreadsheet JSON feed
  • Setup of Google Spreadsheet JSON
  • Restructuring JSON to array format for CSV file
  • Source Code is included so you can try the code and build your own version of the application.

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 own version of the game today!!!!

All the code files are placed at https://github.com/PacktPublishing/JavaScript-CSV-File-Creator---Google-Sheets-to-CSV-Project

Style and Approach

This course is designed to get you started quickly with step-by-step training. The source code is included so you can try it for yourself.

Features
  • Manipulate elements using JavaScript
  • Explore JavaScript Document Object Model
Course Length 50 minutes
ISBN 9781838825348
Date Of Publication 25 Apr 2019

Authors

Laurence Svekis

Laurence Svekis is an instructor. He has 18+ years' work experience in web development, providing smart digital solutions online for both small and enterprise level businesses. An experienced web application developer, he has worked on multiple enterprise-level applications, hundreds of websites and business solutions, and many unique and innovative web applications. His web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP, and MySQL—in short, anything to do with web creation and digital experience. He is passionate about everything to do with web application development and programming to online marketing with a strong focus on social media and SEO.