Create Excel Data Table in ClosedXML C# from existing Data

Question

I am trying to convert the data I already have in a Worksheet in to a DataTable using ClosedXML but I cannot find an overload method for what I need.

This is the code that I am trying:

NewWorksheet.Cell(1, 1).InsertTable();

The closest overload method is the single with an IEnumerable or DataTable but what would I put in there? There is no overload method that takes a range.

Here is the documentation page but nothing meets my need.

score 0 · Answer 1 · answered Feb 15 '17 at 09:41

0

InsertTable inserts an existing DataTable into the spreadsheet. You want to do the reverse. That's not possible in ClosedXML.

answered Feb 15 '17 at 09:41

Francois Botha

4,520
1
34
46

So I cannot convert a range in to a Data Table? That is sad :( – djblois Feb 15 '17 at 17:30
It's possible, but you will have to write your own code. – Francois Botha Feb 16 '17 at 14:31

Create Excel Data Table in ClosedXML C# from existing Data

1 Answers1