import * as fs from 'fs' import * as path from 'path'; import { DataType, ExportType, Header, HEAD_ROW_LENGTH, Table } from './parser'; import xlsx from 'node-xlsx' import { boolean, string } from 'yargs'; enum SRType { /** * 字段名 */ Name = 0, /** * 前端、后端或双端 */ COrS, /** * 注释 */ Des, /** * 数组分隔字符 */ SplitChar, /** * 数据类型 */ DataType, /** * 检测条件 */ CheckCondition, Reserve1, reserve2, reserve3, reserve4, } function getDataValue(dataType: DataType, v: any): any { let result; switch (dataType) { case DataType.Bool: result = v == 'true' ? true : false; break; case DataType.Byte: case DataType.Decimal: case DataType.Double: case DataType.float: case DataType.int: case DataType.long: case DataType.sbyte: case DataType.short: case DataType.uint: case DataType.ulong: case DataType.ushort: result = parseInt(v); break; case DataType.Char: case DataType.string: result = v; break; } return result; } export function parseExcel(filePath: string): Table { if (fs.existsSync(filePath)) { let sheets = xlsx.parse(filePath); if (sheets && sheets.length > 0) { let sheet = sheets[0]; if (sheet.data.length > 0) { let table = new Table(sheet.name); let cLeng = 0; for (let i = 0; i < sheet.data.length; i++) { let row = sheet.data[i]; if (i === 0) { cLeng = row.length; } for (let j = 1; j < cLeng; j++) { let column = j >= row.length ? null : row[j]; let header = table.headers[j - 1] ? table.headers[j - 1] : new Header(); if (i < HEAD_ROW_LENGTH) { switch (i) { case SRType.Name: header.name = column as string; break; case SRType.COrS: if (!column) { header.exportType = ExportType.All; } else { header.exportType = (column as number); } break; case SRType.Des: header.description = column as string; break; case SRType.SplitChar: header.split = column as string; break; case SRType.DataType: header.type = (column as string); break; case SRType.CheckCondition: header.verifications = column as string; break; case SRType.Reserve1: break; case SRType.reserve2: break; case SRType.reserve3: break; case SRType.reserve4: break; } table.headers[j - 1] = header; } else { //数据处理; if (!table.data[i - HEAD_ROW_LENGTH]) { table.data[i - HEAD_ROW_LENGTH] = new Array(); } if (header.split) { let values = (column as string).split(header.split); let arr = new Array(); values.forEach(v => { arr.push(getDataValue(header.type, v)); }) table.data[i - HEAD_ROW_LENGTH][j - 1] = arr; } else { table.data[i - HEAD_ROW_LENGTH][j - 1] = getDataValue(header.type, column); } } } } return table; } else { console.error(`${sheet.name} data error:${sheet.data.length}`); } } } return null; };