Skip to contents

Import questions from an Excel sheet.

Source: R/xlsx2rmd.R
xlsx2rmd.Rd

Convert an xlsx spreadsheet of questions into r/exams-style Rmd files.

Usage

xlsx2rmd(x, output_dir, ..., sheet = 1, log_file = NA, url = NA)

Arguments

x

Filepath to xlsx file.

output_dir

Directory to write Rmd files to.

...

Additional arguments for openxlsx::loadWorkbook.

sheet

Index or name of sheet that contains questions.

log_file

Directory to write log files to.

url

For internal use only.

Details

The image is imported from the xlsx file and saved in the 'img' directory with the same name as the question's generated ID.

xlsx format

The xlsx file should have the following columns:

  • Question: the question text

  • Image: the image file

  • Type: "schoice", "mchoice", or "string"

  • Ans1: the answer text for the first answer

  • Ans2: the answer text for the second answer

  • Ans3: the answer text for the third answer

  • Ans4: the answer text for the fourth answer

  • Ans5: the answer text for the fifth answer

  • Correct: the correct answer number (1-5)

  • Category: the category of the question

  • SubCat: the subcategory of the question

Credits

Brighton Pauli, 2022.

See also

csv2rmd