xspreadsheet 预览

安装

• npm install xspreadsheet-preview

示例

import Preview from "xspreadsheet-preview";
export default {
  components: {
    Preview,
  },
  data() {
    return {
      // 预览的数据，是对象不是数组
      xspreadsheetData: {},
      // 高度，默认自适应，设置 1000px 超出会有滚动条
      height: "auto",
      // 设置需要隐藏的列，默认为 []
      hiddenColumn: ["A", "C"],
    };
  },
  methods: {
    init() {
      this.$refs.preview.init();
    },
  },
};

<Preview
  :data="xspreadsheetData"
  :height="height"
  :hiddenColumn="hiddenColumn"
  ref="preview"
/>

环境

• vue
• big.js 【实现 SUM 函数用到此依赖】
• xspreadsheet

<link rel="stylesheet" href="js/xspreadsheet/xspreadsheet.css" />
<script src="js/xspreadsheet/xspreadsheet.js"></script>

<script src="js/excel/js/shim.min.js"></script>
<script src="js/excel/js/xlsx.full.min.js"></script>
<script src="js/excel/js/xlsxspread.min.js"></script>
<script src="js/xspreadsheet/locale/zh-cn.js"></script>

<script>
  x_spreadsheet.locale("zh-cn");
</script>

打赏

• 您有任何意见或建议，请联系 [email protected]