The invention discloses a method and
system utilizing Excel format data to process
welding performance data. The method comprises the following steps: acquiring original
welding data; utilizing the Excel format to define a fatigue test workbook and a
residual stress workbook, and utilizing the Excel format to define the mapping relations of performance parameters in a fatigue worksheet, a
residual stress worksheet,
welding test worksheets, sample worksheets and process worksheets in the workbooks; examining whether the parameter format in each worksheet is correct or not; analyzing the contents of each worksheet, and saving item by item the data from each worksheet in a data array through the circular
processing method; and according to the obtained data array, saving in batches fatigue performance parameter information,
residual stress parameter information, welding test parameter information, sample parameter information and process parameter information in a
database. The method and
system provided by the invention have the advantages that the Excel format data is utilized to integrate and describe welding performances, so that the
data complexity is greatly reduced, and the data is clearer and more intuitive to be conveniently read and processed for use.