Changes between Initial Version and Version 1 of UserGuidelines/Importer/Excel


Ignore:
Timestamp:
10/28/15 10:48:03 (9 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UserGuidelines/Importer/Excel

    v1 v1  
     1= Excel Importer =
     2[[TOC]]
     3
     4Excel can be used to build a more complex front-end for importable spreadsheets than is possible with just CSV.
     5
     6The Excel importer currently will import a worksheet called 'SahanaData', or the first worksheet if none with the correct name exist.
     7
     8Normally this is a hidden worksheet with a user-visible UI worksheet where data is entered & 1 or more lookup worksheets.
     9
     10== Examples ==
     11* Malagasy Red Cross
     12
     13== See Also ==
     14* [wiki:BluePrint/Importer/Excel BluePrint for Excel Importer]
     15* [wiki:S3#ExportImport DeveloperGuidelines for Imports]
     16* https://www.ablebits.com/office-addins-blog/2014/09/24/excel-drop-down-list/
     17* https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/
     18* http://www.excelcampus.com/tables/dependent-drop-lists/
     19* [http://www.fontstuff.com/vba/vbatut07.htm Popup Date Picker]