import_hmrc_excel: Import an excel file of hmrc tax credit data and convert to a...

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

Import an excel file of hmrc tax credit data and convert to a dataframe

Description

import_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

import_hmrc_excel(excelname, sheet, skip, cols, date)

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.

Value

A dataframe of the extracted tax credits data.

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