# "Skip" parameter XLSX package

**URL:** https://discourse.julialang.org/t/skip-parameter-xlsx-package/72239
**Category:** New to Julia
**Tags:** r, xlsx, excel
**Created:** [November 29, 2021, 2:53pm UTC](https://discourse.julialang.org/t/skip-parameter-xlsx-package/72239 "2021-11-29T14:53:12Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![jnewbie](https://avatars.discourse-cdn.com/v4/letter/j/53a042/32.png) [@jnewbie](https://discourse.julialang.org/u/jnewbie)
#### Post date: [November 29, 2021, 2:53pm UTC](https://discourse.julialang.org/t/skip-parameter-xlsx-package/72239/1 "2021-11-29T14:53:12Z")

</div>

Hi everyone,

I am basically “translating” a R code into a Julia code, here is one of the line of the R code :

> read\_excel(‘Results.xlsx’, sheet = ‘x’, col\_names = FALSE, col\_types = “numeric”, na = “”, skip = 0)

To do the same thing in Julia I am using XLSX.readtable, is there a parameter like “skip” with this package ?

Thank you,

---

<div class="post-metadata">

### Author: ![rafael.guerra](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rafael.guerra/32/216610_2.png) [@rafael.guerra](https://discourse.julialang.org/u/rafael.guerra)
#### Post date: [November 29, 2021, 6:37pm UTC](https://discourse.julialang.org/t/skip-parameter-xlsx-package/72239/2 "2021-11-29T18:37:46Z")

</div>

Check the parameter `first_row` in `XLSX.gettable()`. See [syntax here](https://felipenoris.github.io/XLSX.jl/stable/api/#XLSX.gettable).

```julia
using DataFrames, XLSX

df = XLSX.openxlsx("myfile.xlsx") do xf
     DataFrame(XLSX.gettable(xf["mysheet"])...)
end

```

---

<div class="post-metadata">

### Author: ![jnewbie](https://avatars.discourse-cdn.com/v4/letter/j/53a042/32.png) [@jnewbie](https://discourse.julialang.org/u/jnewbie)
#### Post date: [November 30, 2021, 8:04am UTC](https://discourse.julialang.org/t/skip-parameter-xlsx-package/72239/3 "2021-11-30T08:04:26Z")

</div>

Thanks !