MakerLabs ACM
spreadsheet_helpers.dart File Reference

Utility functions for spreadsheet columns<->index, string helpers, and Google Visualization DataTable parsing. More...

Detailed Description

Utility functions for spreadsheet columns<->index, string helpers, and Google Visualization DataTable parsing.

Functions

String toColumnName (int colNum)
 Get column letter from column index. More...
 
int toColumnNum (String colName)
 Get column number from column letter. More...
 
bool isYesLike (String s)
 Check whether a given string represents "yes" ("☑", "t", "y", etc) More...
 
bool isNoLike (String s)
 Check whether a given string represents "no" ("☐", "f", "n", etc) More...
 
String nthColumnLabel (Map datatable, int i)
 Get the label string of the Nth column from a DataTable. More...
 
String labelToColumnId (Map datatable, String prefix, String label)
 Get the column letter for a specific label (with optional prefix) More...