ExcelProvider

ExcelProvider copied to clipboard

Access to range defined by a Table Name

1

Hi, thank you for the library. It's very useful. I'm using a lot of Structured References (also called "Table Name") in my Excel Sheets for different reasons. In VBA, I...

RolandTLH

Custom ranges

2

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``...

isaacabraham

Feature Request: Parameter to expose textual forms of formulas in sheet.

1

I'm currently in a scenario where I'm trying to read the raw text of a formula and parse out a bit of info from it (which is less than ideal,...

121GWJolt

Feature Request: Support Google Sheets

1

### Supporting google sheets? I think it would be interesting for the provider to support manipulation of online googlesheet data https://www.google.com/sheets/about/ what do you think :)

jkone27

Feature request: read more rows to infer column type

5

### Description I don't know how many rows the TP reads before attempting to infer column types, but it is not enough. Type inference is frequently incorrect because the TP...

jackfoxy

InvalidCastException if some of cells in string column are numeric

1

Occurs if enumerate all rows. As a workaround i have selected the entire column and set format to text System.InvalidCastException: Unable to cast object of type 'System.Double' to type 'System.String'....

vilinski

Culture Info setting

2

Is there any way (or plans) to allow setting Globalization settings when reading sheets? If you use ``ForceString = true``, it *appears* to return the data in the OS culture,...

isaacabraham

Assembly named ExcelProvider.RunTime instead of ExcelProvider

4

### Description The assembly from the nuget package is named `ExcelProvider.Runtime.dll`, which disagrees with the current documentation, and seems accidental/odd. Either the docs need to be updated (see issue #64)...

mathias-brandewinder

Need CI testing on Mono (OSX)

2

A CI build on Mac OSX using Mono 3.4.0 has been set up The main type provider builds but the build is failing when building the tests, see https://travis-ci.org/fsprojects/ExcelProvider/builds/35113927 for...

fsgit

### Description Intellisense for a fsx file shows error after changing column names in excel template file. ### Repro steps Create an Excel template file with columns A and B...

halcwb