fsprojects/ExcelProvider

Custom ranges

isaacabraham opened this issue · 2 comments

isaacabraham commented

I'd like to be able to select a range of cells from a fixed top-left and supply the right-most column, but not the number of rows e.g.

Instead of A2:B99 I would like to be able to simply do A2:B and get all cells until the end of the table. Is this possible?

yufan-at-arcadlon commented

I'd like this also. I have existing code that does this with Linq and OpenXML in VB.NET, but wanting to transfer to F#. The problem this solves is skipping the overarching header above the data table.

MicaelMor commented

Would like to add in case anyone comes and reads this, that using say Range = "A2", does make it so that the table is read starting at A2, it isn't exactly the same as the A2:B example, since it would still read data to the right of column B, but it does mean that it reads data starting from A2.

  • 👍1