主页

react handsontable nestedHeaders 保存表头的数据

2024-08-09 06:47PM

保存“动态排放活动数据页面”表格中表头的数据:

import { HotTable } from '@handsontable/react';
import HandsonTable from "@/compontens/HandsonTable";
import { registerAllModules } from 'handsontable/registry';
import 'handsontable/dist/handsontable.full.min.css';

registerAllModules();

class CalculationForDemo extends Component {

  constructor(props) {
    super(props);

    // 初始化了一个空的对象属性 tableRefs

    this.tableRefs = {};
    this.state = {
      planId: props.location.state.planID,
      name: props.location.state.name,
      startYear: props.location.state.startYear,
      endYear: props.location.state.endYear,
      materialNames: props.location.state.materialNames,
      selectedAlgorithmNames: props.location.state.selectedAlgorithmNames,
      industryNames: props.location.state.industryNames,
      industryMaterialMapping: props.location.state.industryMaterialMapping,
      calculationTemplates: props.location.state.calculationTemplates,
      life: props.location.state.life,
    }
  }

  handleNext = async() => {
    const {
      planId, name, materialNames, startYear, endYear, selectedAlgorithmNames, industryNames, industryMaterialMapping,
      selectedRegion, algorithmAndColumnMapping, calculationTemplates, life
    } = this.state;

    // 从 Handsontable 实例中提取表格数据并存储在 bigTableData 变量中
    const bigTable = this.tableRefs['bigTable'].hotInstance.getData();
    // 将bigTable这个二维数组中所有单元格的值转换为字符串
    const bigTableData = bigTable.map(row => row.map(cell => String(cell)))
    console.info("================ this.tableRefs['bigTable']: ", bigTableData)

    const nestedHeaders = this.state.tableHeaders;
    console.info("================ nestedHeaders: ", nestedHeaders)

    const requestData = {
      planId,
      name,
      startYear,
      endYear,
      materialNames,
      selectedAlgorithmNames, // 使用 selectedAlgorithmNames
      bigTable: bigTableData,
      industryNames,
      calculationTemplates,
      industryMaterialMapping,
      life,
      selectedRegion,
      algorithmAndColumnMapping,
      nestedHeaders
    };
    console.info("=======requestData:", requestData)
    console.info("===calculationTemplates:", calculationTemplates)

    this.props.history.push('/calculation_for_parameter', requestData);
  }

  render() {

    const { data, name, templateId, startYear, endYear, algorithmName, selectedAlgorithmNames } = this.state;

    return (       
      <HotTable
          id="bigTable"
          data={this.tableBody()}
          nestedHeaders={this.state.tableHeaders}
          ref={(ref) => { this.tableRefs['bigTable'] = ref; }}  // 当 HotTable 组件被渲染时,React 会自动调用这个箭头函数,并将该组件的实例作为参数 ref 传入
          colHeaders={true}
          rowHeaders={false}
          autoWrapRow={true}
          autoWrapCol={true}
          licenseKey="non-commercial-and-evaluation"
          width="auto"
          height="auto"
        />
    )
  }
}

export default CalculationForDemo;

 

点击下一步,在日志中就可以看到保存情况:

返回>>

登录

请登录后再发表评论。

评论列表:

目前还没有人发表评论