From df back into excel data tables?

[ewswlw]

i have a df that i output as "excel value", but when i try to convert it to a table it says ...

"Formulas or rich data types in header row will be removed and converted to static text"

Even if i hit Yes, it just gives me a spill error.

How do i avoid getting this message and behavior i want? aka df into excel table?

[keyur32]

Thanks for the report. This is an existing Excel limitation with spilled arrays, and we don't have an ETA at the moment to provide table support on top of spilled arrays.

Are you trying to use this for filtering purposes? IYou can try to apply sort and filter to the output as a workaround. The limitation is you will only be able to do that 1 per sheet so will need to layout our workbook accordingly.