Spreadsheets

Spreadsheets: Spreadsheets as Objects: Import-Csv, Saving Data: Export-Csv and Cleaning a CSV.

Updated

  1. Spreadsheets as Objects: Import-Csv (Apprentice): Import-Csv reads a CSV file, the plain-text kind of spreadsheet that shops, banks and apps export, and turns each row into an object with one property for each column, so you can filter, sort, group and add up the rows with the commands from Module 3.
  2. Saving Data: Export-Csv and Cleaning a CSV (Journeyman): Export-Csv saves objects as a CSV file that Excel and other programs open as a table, and on the way there a pipeline can clean an untidy export, dropping its blank rows, renaming its columns and turning text such as $36.00 into numbers with [decimal] and [int].