Skip to contents

Combine the xlsform in single table for pretty printing

Usage

fct_tabulate_form(xlsformpath, label_language = NULL, logic = TRUE)

Arguments

xlsformpath

path to the file with xlsform

label_language

Language to be used in case you have more than one. If not specified, the 'default_language' in the 'settings' worksheet is used. If that is not specified and more than one language is in the XlsForm, the language that comes first within column order will be used.

logic

TRUE per default put to FALSE to take out the printing of constraints.

Value

a single data frame

Examples

# fct_tabulate_form()

prettyform <- fct_tabulate_form( xlsformpath = system.file("demo.xlsx", 
                                              package = "XlsFormUtil") )

knitr::kable(utils::head(prettyform, 10))
#> 
#> 
#> |Questions                                                                     |Choices                                                                                                                                                                                                                                                                                   |Variables        |Logic                                                                 |
#> |:-----------------------------------------------------------------------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------------|:---------------------------------------------------------------------|
#> |                                                                              |( type: start)                                                                                                                                                                                                                                                                            |start            |                                                                      |
#> |                                                                              |( type: end)                                                                                                                                                                                                                                                                              |end              |                                                                      |
#> |                                                                              |( type: simserial)                                                                                                                                                                                                                                                                        |simserial        |                                                                      |
#> |                                                                              |( type: deviceid)                                                                                                                                                                                                                                                                         |deviceid         |                                                                      |
#> |                                                                              |( type: phonenumber)                                                                                                                                                                                                                                                                      |phonenumber      |                                                                      |
#> |001b. Enter your name below. bla bla bla bla
#>  *(hint: Please record your name) |( type: text)                                                                                                                                                                                                                                                                             |your_name        |                                                                      |
#> |Whoa - does this question sync? 2                                             |( type: select_one) 
#> -[never] Never attended
#> -[primary] Primary
#> -[secondary] Secondary
#> -[tertiary] Tertiary
#> -[-99] No response
#> -[never] Never Attended
#> -[primary] Primary (1-8)
#> -[secondary] Secondary (9-12)
#> -[technical] Technical/Vocational
#> -[higher] Higher
#> -[-88] Don’t know
#> -[-99] No response |school_level_001 |school_level_001 is relevant if begin_interview=yes and available=yes |
#> |001b. Enter your name below.
#>  *(hint: Please record your name)                 |( type: text)                                                                                                                                                                                                                                                                             |name_typed       |                                                                      |
#> |003a. Region                                                                  |( type: note)                                                                                                                                                                                                                                                                             |level1           |                                                                      |
#> |003b. Zone                                                                    |( type: note)                                                                                                                                                                                                                                                                             |level2           |                                                                      |