Feature Request: Designate worksheet(s) for loading

2 views
Skip to first unread message

Marshall Feldman

unread,
Jun 4, 2018, 12:44:59 AM6/4/18
to ProjectTemplate
It is common for data to be packaged in a spreadsheet (typically Excel) with several worksheets. For example, the Penn World Table of economic data comes in an xlsx file with three worksheets, two of which are solely documentation: Info and Legend. Only the third, Data, contains data.

I would like some way to configure a project and to tell it what worksheet(s) in individual spreadsheet files should be read and loaded. For example, the configuration entry might look like:

       workbooks:                             # Designates a section of the configuration file devoted to specifying how spreadsheet workbooks should be handled
             workbook: pwt90.xlsx       # First workbook is the Penn World Table version 9.0 as an xlsx file
                  sheets: Data                # Only read the Data sheet and use it to create a data frame. This entry could be a comma-delimited list of worksheets (e.g. Data, Demographics, etc.)
                                                      # If more than one workbook will be processed, start another workbook entry here.

Kenton White

unread,
Jun 19, 2018, 1:12:04 PM6/19/18
to project...@googlegroups.com
Hi Marshall,

Sorry for my delay in responding — the google groups is deprecated in favour of GitHub.

Would you mind opening this as a request on the github repository please:  https://github.com/KentonWhite/ProjectTemplate

Kenton White

--
You received this message because you are subscribed to the Google Groups "ProjectTemplate" group.
To unsubscribe from this group and stop receiving emails from it, send an email to projecttempla...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages