jayzhou316 comments

Repositories
Issues
Comments

Results 2 comments of


                                            jayzhou316

向已有表格模板指定sheet中追加数据，非删除原数据，其他sheet数据结构不变

var tables = MiniExcel.QueryAsDataTable(FilePaths, useHeaderRow: true); tables.Rows.Add("MFG", 14.07, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "Pass"); if (DeleteFile(FilePaths)) { MiniExcel.SaveAsAsync(FilePaths, tables); };

向已有表格模板指定sheet中追加数据，非删除原数据，其他sheet数据结构不变

List rows = MiniExcel.Query(FilePaths).ToList(); if (DeleteFile(FilePaths)) { var value = new Snmodels { SN = "Jack", TIME = 15.3, TEST_TIME = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), TEST_RESULT = "PASS" }; rows.Add(value); MiniExcel.SaveAsAsync(FilePaths, rows,true,sheetName:"Sheet1");...