search

fsprojects / ExcelProvider

This library is for the .NET platform implementing a Excel type provider.
http://fsprojects.github.io/ExcelProvider/
The Unlicense
141 stars 51 forks source link

Custom ranges #34

Open isaacabraham opened 7 years ago

isaacabraham commented 7 years ago

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 7 years ago

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 4 years ago

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.