ExcelProvider

ExcelProvider copied to clipboard

### Description Please provide a succinct description of your issue. ### Repro steps type ef = ExcelFile // ok // but not for .xlsm files - Operating system = windows...

yetanotherlogonfail

Cannot load excel file at runtime

4

### Description I can't find a way to load an excel file at runtime. I can only use the one specified as a constant in the type provider initialization ###...

matteo-mosca

Full CRUD

1

It would be wonderful if this provider could achieve full CRUD (Create, Read, Update, Delete) on an Excel table. Currently I am using this for reading and OpenXML SDK for...

yufan-at-arcadlon

### Description Frequently the column types inferred by the TP are wrong. Implement a schema definition parameter, similar to how CSV TP does. The ability to override only selected columns...

jackfoxy

### Description Enable more flexibility to declaring headers. Currently header can only be the first row in a selected range. Frequently headers will span 2 or more cells in a...

jackfoxy

I'd like the ability to determine the range at runtime. I have several files I need to import that contain "bands" of information on the same worksheet. Thus, the range...

bslatner

No detection of column changes between compile-time and runtime

2

### User Story As a user, I want to compile a project against one excel file at compile time and then run it against another excel file at runtime. The...

AverageHomosapien

Some performance optimizations

2

Faster niceName function and other minor performance and memory usage improvements.

Thorium