How to extract value of a cell using spsheet crate

I am using "spsheet" carate to read contenst of a spreadsheet document. I have two questions:

  1. How I read the contents of a particular cell and print the contents to the screen
  2. We can get the number of rows with "Sheet::get_rows()" how can we get the colums as there is not Sheet::get_colums() methode available.

The get_rows method https://docs.rs/spsheet/0.1.0/spsheet/struct.Sheet.html#method.get_rows returns a set of cells.

Each Cell has a method called get_value https://docs.rs/spsheet/0.1.0/spsheet/struct.Cell.html#method.get_value

I'm not sure exactly what you need, but if you have a fixed format, that should be enough to locate the cells you need.

1 Like