Takes in a .xlsx file and returns the formatted data into a new .xlsx and .txt file according to the format of the U.S. Copyright Office SR Audit Data online database.
Usage
clean_format_all(excelfile)
Arguments
excelfile
Input the original raw SR Audit Data spreadsheet
Value
Returns an excel sheet and text file that includes the cleaned and formatted data that are congruent to the format of the U.S. Copyright Office SR Audit Data online database.
# NOT RUN {#This is the main function. Users should be only using this function for data cleaning.# }# NOT RUN {filename = "data.xlsx"clean_format_all(excelfile)
# }