Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
The Excel_XML class constructor has an optional parameter for converting "variables to field specification". This means that the Excel will automatically interpret the field as a number which can save a lot of time.
This field can be exposed by providing an administration page for the module.
Comment | File | Size | Author |
---|---|---|---|
#2 | views_export_xls-convert_numbers-1971008-2.patch | 2.5 KB | kevin.mcnamee@mailbox.org |
#1 | views_export_xls-convert_numbers-1971008-1.patch | 3.09 KB | kevin.mcnamee@mailbox.org |
Comments
Comment #1
kevin.mcnamee@mailbox.org CreditAttribution: kevin.mcnamee@mailbox.org commentedAttached a patch to make the parameter configurable from the admin pages. Excel will now recognize numbers automatically when the document is opened.
Comment #2
kevin.mcnamee@mailbox.org CreditAttribution: kevin.mcnamee@mailbox.org commentedI realised that this should of course be implemented as a style option in Views. New patch attached.