CODEWITHSUNDEEP
rxlsx
QMan5
QMan5

Reputation: 779

How to remove the first row in every sheet in r?

I have an excel document with multiple sheets. I was curious if there was a way to remove the first row of every sheet as there is a header file on the sheet that isn't necessary but this automatically appears on each sheet. I would rather not open the file and remove the first row as this can cause possible data errors.

Upvotes: 1

Views: 2433

Answers (1)

QMan5
QMan5

Reputation: 779

"Many functions that read-in data will have a "skip" argument (under some name). E.g., for readxl::read_excel() you can use skip = 1 to skip one line. If you check out the documentation for the function you are using it should help clarify things." - Andrew

Upvotes: 1

Related Questions