透视表数据如果是MultiData的情况下，下载格式化数据格式有问题，想请教下如何能让下载格式化数据 正常？

[warmWarmHeart]

问题描述：

透视表使用Export下载格式化数据 数据展示[object Object], 使用StrategyExport下载格式化数据，数据正常，但是列头错位

场景描述：

期望：

不管通过Export 还是StrategyExport 希望下载到excel后，列头和数据能匹配不错位

代码：

import React, { useRef } from 'react';
import { SheetComponent } from '@antv/s2-react';
import { DataCell, RowCell, ColCell, SpreadSheet, drawCustomContent } from '@antv/s2';
import { HTML } from '@antv/g';
import { StrategyExport, Export } from '@antv/s2-react-components';
import { Button } from 'antd';

export const dataConfig = {
    "fields": {
        "rows": [],
        "columns": [
            "day"
        ],
        "values": [
            "59fb9e09e7"
        ],
        "valueInCols": false
    },
    "meta": [
        {
            "field": "day",
            "name": "日期"
        },
        {
            "field": "59fb9e09e7",
            "name": "自定义指标1"
        },
        {
            "field": "value",
            "name": ""
        }
    ],
    "data": [
        {
            "day": "全部\nVS\n全部",
            
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        null
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        },
        {
            "day": "均值\nVS\n均值",
            
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        null
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        },
        {
            "day": "2025-07-28\nVS\n2025-07-21",
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        null
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        },
        {
            "day": "2025-07-29\nVS\n2025-07-22",
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        "0.00%"
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        },
        {
            "day": "2025-07-30\nVS\n2025-07-23",
          
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        "0.00%"
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        },
        {
            "day": "2025-07-31\nVS\n2025-07-24",
           
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        "0.00%"
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        },
        {
            "day": "2025-08-01\nVS\n2025-07-25",
          
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        "0.00%"
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        },
        {
            "day": "2025-08-02\nVS\n2025-07-26",
            
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        "0.00%"
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        },
        {
            "day": "2025-08-03\nVS\n2025-07-27",
          
            "59fb9e09e7": {
                "values": [
                    [
                        "100.00%",
                        "0.00%",
                        "0.00%"
                    ],
                    [
                        "100.00%"
                    ]
                ]
            }
        }
    ],
    "columns": [
        "day"
    ]
}
export const options = {
    "interaction": {
        "copy": {
            "enable": true,
            "copyWithFormat": true,
            "copyWithHeader": true
        },
        "brushSelection": {
            "dataCell": true,
            "rowCell": true,
            "colCell": true
        }
    },
    "conditions": {
        "text": [
            {
                "field": "value"
            }
        ]
    },
    "tooltip": {},
    "style": {
        "dataCell": {
            "height": 90
        },
        "colCell": {
            "height": 90,
            "widthByField": {}
        }
    }
}
// ============= 自定义Cell组件 =============

/**
 * 自定义数据单元格
 */
class CustomDataCell extends DataCell {
    protected linkFieldShape: any = null;

    drawTextShape(): void {
        const { fieldValue } = this.getMeta();

        // 处理复杂数据类型
        if (this.isComplexData(fieldValue)) {
            drawCustomContent(this as any);
            return;
        }

        // 调用父类方法，此时已经应用了 getTextStyle 的样式
        super.drawTextShape();
    }

    private isComplexData(fieldValue: any): boolean {
        return (
            Object.prototype.toString.call(fieldValue) === '[object Object]' ||
            Object.prototype.toString.call(fieldValue) === '[object Array]'
        );
    }
}

/**
 * 自定义行头单元格
 */
class CustomRowCell extends RowCell {
    // 重写文本形状绘制方法，处理VS文本和换行符
    drawTextShape(): void {
        const text = this.getFieldValue()!;
        const { x, y, width, height } = this.meta;
        const list = String(text).split('\n');
        
        this.appendChild(
            new HTML({
                style: {
                    x,
                    y,
                    width,
                    height,
                    innerHTML: `<div
                        style="background:transparent;
                        text-align: center;
                        width: ${width}px;
                        height: ${height}px;
                        padding: 20px 0;
                        font-size: 12px;
                        font-weight: bold;
                        position: relative;
                    ">
                        <div style="position: absolute; top: 50%; left: 50%; transform: translate(-50%, -50%);">
                            ${list.map((item) => `<div>${item}</div>`).join('')}
                        </div>
                    </div>`
                }
            })
        );
    }
}

/**
 * 自定义列头单元格
 */
class CustomColCell extends ColCell {
    // 重写文本形状绘制方法，处理VS文本和换行符
    drawTextShape(): void {
        const text = this.getFieldValue()!;
        const { x, y, width, height } = this.meta;
        const list = String(text).split('\n');

        this.appendChild(
            new HTML({
                style: {
                    x,
                    y,
                    width,
                    height,
                    innerHTML: `<div
                        style="background:transparent;
                        text-align: center;
                        width: ${width}px;
                        height: ${height}px;
                        padding: 20px 0;
                        font-size: 12px;
                        font-weight: bold;
                        position: relative;
                    ">
                        <div style="position: absolute; top: 50%; left: 50%; transform: translate(-50%, -50%);">
                            ${list.map((item) => `<div>${item}</div>`).join('')}
                        </div>
                    </div>`
                }
            })
        );
    }
}

// ============= 主组件 =============

interface SimpleS2TableProps {
    height?: number;
}

const SimpleS2Table: React.FC<SimpleS2TableProps> = ({ height = 600 }) => {
    const s2Ref = useRef<SpreadSheet>(null);

    // 扩展options配置，添加自定义Cell
    const extendedOptions = {
        ...options,
        dataCell: (viewMeta: any, spreadsheet: any) => {
            return new CustomDataCell(viewMeta, spreadsheet);
        },
        rowCell: (node: any, spreadsheet: any, rowHeaderConfig: any) => {
            return new CustomRowCell(node, spreadsheet, rowHeaderConfig);
        },
        colCell: (node: any, spreadsheet: any, rowHeaderConfig: any) => {
            return new CustomColCell(node, spreadsheet, rowHeaderConfig);
        },
        // 设置表格高度
        style: {
            ...options.style,
            dataCell: {
                ...options.style?.dataCell,
                height: options.style?.dataCell?.height || 90
            },
            colCell: {
                ...options.style?.colCell,
                height: options.style?.colCell?.height || 90
            }
        }
    };

    return (
        <div style={{ width: '100%', height: '100%' }}>
            {/* 操作工具栏 */}
            <StrategyExport
                dropdown={{
                    trigger: ['hover']
                }}
                sheetInstance={s2Ref.current as any}
            >
                <Button type="primary">导出StrategyExport</Button>
            </StrategyExport>
            <Export
                dropdown={{
                    trigger: ['hover']
                }}
                sheetInstance={s2Ref.current as any}
            >
                <Button type="primary">导出Export</Button>
            </Export>
            {/* S2 交叉表 */}
            <SheetComponent
                sheetType="pivot"
                ref={s2Ref}
                dataCfg={dataConfig}
                options={extendedOptions}
                style={{ 
                    width: '100%', 
                    height: height 
                }}
            />
        </div>
    );
};

export default SimpleS2Table;

[Alexzjt]

#3209