How to programatically set the some rows in a table as table.header?

Questions
1

Hi, I have a large table (in .xlsx format) that I am importing into typst using pandoc.
I would like to set some of the rows as subheaders. I tried the following (for the third row) but none of them work:

#show table.cell:it=>{
if it.y==2{
table.header(level:1, it)
}else{
it
}
} // doesn't work

#show table.cell.where(y: 2): it => table.header(level:1, it) //doesn't work

#show table.cell.where(y: 2): set table.header(level:2) //doesn't work

What am i doing wrong?

2

I think a show rule on table.cell is run too late to change the structure of the table. You could do something like this with a #show table: it => ..., to transform the table into a new one. Here’s an example that converts the first row to a header:

#show table: it => {
  let (children, ..rest) = it.fields()
  if it.at("label", default: none) == <processed> {
    // Already processed, avoid recursion
    return it
  }
  let n = rest.columns
  if type(n) == array {
    n = n.len()
  }
  let tbl = table(
    ..rest,
    table.header(..children.slice(0, n)),
    ..children.slice(n),
  )
  [#tbl<processed>]
}

#set page("a10", flipped: true)

#table(
  columns: 2,
  [A], [B],
  ..range(6).map(str),
)

image
image149×207 3.25 KB

3

Hi. You can use rexllent – Typst Universe or spreet – Typst Universe for parsing and then just process the cell matrix with conditional table.header insertion/wrapping. You are overcomplicating this.

#let data = {
  data
    .enumerate(start: 1)
    .map(((n, row)) => if n <= 2 { table.header(row) } else { row })
}

#table(
  columns: data.first().len(),
  ..data.flatten(),
)