Test cases

sheet

8 commands, 14 tests. 0 failed.

• sheet convertChange format: --to csv|xlsx|json
  • Chinese table to Excel
  • Large CSV to Excel
  • Read LibreOffice and old Excel files
  • Export one sheet
  • Parse a European CSV
• sheet extractTake a sheet or range: --sheet, --range A1:D20
  • Take part of a table
• sheet infoSheet names, rows, columns
  • Answer a question about a workbook
• sheet mergeStack tables; a shared header is kept once
  • Append tables
• sheet pivotPivot table: --rows city --columns year --values sales
  • Pivot table
• sheet splitSplit up: --sheets, --columns city or --every 1000
  • Export every sheet
  • Split into files of 100 rows
• sheet statsPer-column counts, empties, min, max, mean, sum
  • Profile a table
• sheet to-mdMarkdown table (first row is the header)
  • Turn a workbook into a report
  • Table for a report