From df back into excel data tables?

microsoft / python-in-excel

Python in Microsoft Excel

MIT License

490 stars 31 forks source link

From df back into excel data tables? #36

Open ewswlw opened 9 months ago

ewswlw commented 9 months ago

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 commented 9 months ago

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.