convert_hmrc_excel: Convert an excel file of hmrc tax credit data to a csv

In olihawkins/clbenefits: Download and Process a Range of Benefits Data

Convert an excel file of hmrc tax credit data to a csv

Description

convert_hmrc_excel takes the path to an excel file of hmrc tax credits data and attempts to convert it to a csv. You must provide the function with the information it needs to extract the correct data.

Usage

convert_hmrc_excel(excelname, sheet, skip, cols, date, csvname)

Arguments

excelname	A filepath for an excel file of hmrc tax credits data.
sheet	A string specifying the name of the worrksheet that contains data on Parliamentary constituencies.
skip	An integer specifying the number of rows to skip before the lowest header row.
cols	A vector of integers specifying the numbers of the columns that contain the expected data, in the expected sequence.
date	A date representing the date of the dataset. This is typically the first of the month for which the dataset is published.
csvname	A filepath for the output csv file.

Value

A dataframe of the extracted tax credits data.

olihawkins/clbenefits documentation built on May 19, 2023, 5:09 p.m.