| | |
|---|
| | | private void button1_Click(object sender, EventArgs e) |
|---|
| | | { |
|---|
| | | SaveExcel(); |
|---|
| | | SaveTxt(); |
|---|
| | | //SaveTxt(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public async void SaveExcel() |
|---|
| | |
|---|
| | | measurementUnitResult.MeasurementName = "测试" + i; |
|---|
| | | measurementUnitResult.MeasurementType = "Slant"; |
|---|
| | | measurementUnitResult.MeasurementValue = (i + 10).ToString(); |
|---|
| | | measurementUnitResult.MeasurementResult = "OK"; |
|---|
| | | measurementUnitResult.MeasurementResult = (i % 2) == 1? "OK":"NG"; |
|---|
| | | |
|---|
| | | measurementUnitResultAndKeyUnitDataSet.MeasurementUnitResultList.Add(measurementUnitResult); |
|---|
| | | } |
|---|
| | |
|---|
| | | excelExportDto.WorksheetDataTable[excelExportDto.Worksheets[0]] = ExcelExportHelper.ListToDataTable(measurementUnitResultAndKeyUnitDataSet.KeyUnitDataList, keyUnitColumns); |
|---|
| | | excelExportDto.WorksheetDataTable[excelExportDto.Worksheets[1]] = ExcelExportHelper.ListToDataTable(measurementUnitResultAndKeyUnitDataSet.MeasurementUnitResultList, measurementUnitResultColumns); ; |
|---|
| | | |
|---|
| | | byte[] filecontent = ExcelExportHelper.ExportExcel(excelExportDto, false); |
|---|
| | | |
|---|
| | | string dir = Path.Combine(@"D:\PROJECTS\M071", DateTime.Now.ToString("yyyyMMdd")); |
|---|
| | | if (!Directory.Exists(dir)) |
|---|
| | | { |
|---|
| | | Directory.CreateDirectory(dir); |
|---|
| | | } |
|---|
| | | |
|---|
| | | FileStream fs = new FileStream(Path.Combine(dir, $"test_133535.xlsx"), FileMode.Append, FileAccess.Write); |
|---|
| | | var fileName = Path.Combine(dir, $"test_133536.xlsx"); |
|---|
| | | byte[] filecontent = ExcelExportHelper.CreateOrAppendExcel(excelExportDto, fileName); |
|---|
| | | FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.Write); |
|---|
| | | fs.Write(filecontent, 0, filecontent.Length); |
|---|
| | | fs.Flush(); |
|---|
| | | fs.Close(); |
|---|
