Convert Table To Range (or some other way)

Nov 8, 2011 at 8:44 PM

Using a datatable to add a worksheet, a table is created within the worksheet.  In Excel, it is possible to convert that table to a range (Convert To Range on the Design->Tools ribbon).  Is this functionality possible with ClosedXML?  I can't seem to find any methods that provide this, but I may just be overlooking it.

Alternatively, any suggestions for outputting a PowerShell PSObject to a worksheet via ClosedXML quickly and efficiently (converting that PSObject to a DataTable is ok, but is another quick step I'd like to avoid)?  Thanks!

Coordinator
Nov 8, 2011 at 8:54 PM

I don't think there's a way to turn off a table like you can with auto filters but I'll add it. Either way, you don't have to create a table if you don't want to. You can insert the data in your datatable without creating a table. See the section "Inserting Data/Tables" on the documentation.

Coordinator
Nov 8, 2011 at 8:54 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Feb 13, 2014 at 5:51 PM
3 years later and this is exactly the same issue I am having?
Did you ever add this feature?