hubmapconsortium/tableschema-to-template

Add VBA functions for regexes?

Opened this issue · 1 comments

This looks like a good source.

Concerns:

  • Excel documents with macros are likely to be flagged as potential security risks.
  • VBA code is a binary blob, and we won't easily be able to maintain it.
  • Excel is proprietary: Shouldn't jump through hoops to work with it.

Other options:

  • Don't even try!
  • Add VBA to provide regex support in Excel.
  • Target Google Sheets, which provides a regex function out of the box.
  • Or target OpenOffice, where regexes can be turned on in the settings.