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(),
)
1 Like
4

Thank you. How would one do it for an array of header rows?

5

Same way, but just without the condition.

#set page(width: 10cm, height: 5cm)

#let data = (
  ("Column 1", "Column 2", "Column 3"),
  ("sub column", "sub column", "sub column"),
  ..range(8).map(row => range(3).map(col => {
    "some data " + str(col + 1) + " " + str(row + 1)
  })),
)

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

#let header-rows = data.slice(0, 2)
#let data = data.slice(2)

#let header-rows = {
  header-rows
    .enumerate(start: 1)
    .map(((n, row)) => table.header(level: n, ..row))
}

#table(
  columns: columns,
  ..header-rows.flatten(),
  ..data.flatten(),
)

image
image540×277 27.5 KB

6

Hmm… Is this assuming that the first n rows are headers?

I actually have subheaders at multiple noncontiguous rows.

7

Non-contin/guous headers aren’t supported and aren’t common, if even exist. But there are some metadata stuff for something similar.

8

But haven’t noncontiguous subheaders been implemented already?

I am able to use them in Typst 0.14, but just that I need to manually declare the headers which I want to avoid given that the table has 3000+ rows.

9 
#set page(height: 4cm)
#table(
  table.header[a],
  [b],
  table.header[c],
  [d],
  [e],
  [f],
)

does work, but adjacent header row groups are repeated separately, instead of all at once. The documentation doesn’t make it clear that you can have non-header rows in between.

This is the same logic that you’ve used in the OP. You have to be able to identify the header rows in order to mark them as such. The identification process wasn’t provided, other than “3rd row is header level 1 or 2.”