thanks LZ for your kindness

thanks a lot for sharing the code, but could not call library(xlsx), got this error message

Error: package or namespace load failed for ‘xlsx’:
.onLoad failed in loadNamespace() for 'rJava', details:
  call: fun(libname, pkgname)
  error: No CurrentVersion entry in Software/JavaSoft registry! Try re-installing Java and make sure R and Java have matching architectures.

any idea??

装个java的jdk还是什么的就好了，没有java环境

家庭人口数—孩子数量  为什么等于2就是已婚，等于1就是其他呢？  不应该孩子数量不为0 就是已婚吗  孩子都有了啊，还有等于1也有可能是已婚丧偶啊。这样处理感觉不是太好啊...

tried it and it still did not work, same error. I'll just use other way to read the xlsx file. thanks for your help.