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

3

### 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

If you want to build on both VS2022 (.NET Framework compatible, using .NET Standard 2.0) and dotnet.exe (e.g. VSCode) with latest .NET 8.0 (or 9.0, whatever), the TP has to...

Thorium