Named Tables to DataTable?

[sanzoghenzo]

Named Tables to DataTable?

[smartquant]

Hi @sanzoghenzo ,

This functionality is already included in the extension method ExcelReferenceEx.ToDataTable
Just do the following:

        var ws = Worksheet.ActiveSheet();
        var dt1 = ws.Range("table1").ToDataTable(header: false);
        var dt2 = ws.Range("table1[#All]").ToDataTable(header: true);

[sanzoghenzo]

thanks @smartquant, I found the real problem: I'm an italian user and I need to use the localized keyword "#Tutti" instead of "#All".
In VBA I had to use the english version, so I (wrongly) took granted the same behavior in exceldna.
This will cause portability problems, since I'm developing some plugins for an international company :(
Thanks again!