To read data from HMIS files - https://nrhm-mis.nic.in/hmisreports/frmstandard_reports.aspx

hmis_read_file.r

library(rvest)
library(readr)

# This file needs to be read as text. 
x <- readr::read_file("~/Downloads/Chandigarh.xls")

# Every file will have a table, the way it is structured in this sample. We just want to extract this table and convert it to a data frame
# Check and clean the file as per the structure of the original one. Headers and Rows need to be adjusted.
y <- x %>% read_html() %>% html_table(fill = TRUE)
z <- y[[1]]
View(z)

# To get all headers
y <- x %>% read_html() %>% html_nodes(css = '.header') %>% html_text()