umx (version 1.2.7)

umx_sql_from_excel: umx_sql_from_excel

Description

Unlikely to be of use to anyone but the package author :-) Read an xlsx file and convert into SQL insert statements (placed on the clipboard) On OS X, the function can access the current frontmost Finder window.

Usage

umx_sql_from_excel(theFile = "Finder")

Arguments

theFile

The xlsx file to read. If set to "Finder" (and you are on OS X) it will use the current frontmost Finder window. If it is blank, a choose file dialog will be thrown.

Value

-

Details

The file name should be the name of the test. Columns should be headed: itemText direction scale type then whatever you need for response options

The SQL fields expected are: itemID, test, native_item_number, item_text, direction, scale, format, author

References

- http://www.github.com/tbates/umx

See Also

Other File Functions: dl_from_dropbox, umx_move_file, umx_open, umx_rename_file, umx

Examples

## Not run: 
# umx_sql_from_excel() # Using file selected in front-most Finder window
# umx_sql_from_excel("~/Desktop/test.xlsx") # provide a path
# ## End(Not run)