MiniExcel icon indicating copy to clipboard operation
MiniExcel copied to clipboard

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

Open SHUNCSHARP opened this issue 3 years ago • 2 comments

Excel Type

  • [x] XLSX
  • [x] XLSM
  • [x] CSV
  • [ ] OTHER

Upload Excel File

将DataTable中的数据追加到已有模板Excel的某个sheet中,而不是新建sheet?关于MINIExcel中的SaveAsByTemplate方法和SaveAs方法,经测试,是新建sheet了,因此使用这2种方法时,把已有的模板sheet替换了,这点有点糟糕。期望有乐意回答的developer,当然,肯定会有这样好的方法,可在MINIExcel来实现该追加功能,即如同MINIExcel.dataappend(string path, string templatePath, object value)新功能的出现。

SHUNCSHARP avatar Mar 26 '22 04:03 SHUNCSHARP

               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);
                };

jayzhou316 avatar Apr 02 '22 08:04 jayzhou316

                 List<Snmodels> rows = MiniExcel.Query<Snmodels>(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");
                };

jayzhou316 avatar Apr 02 '22 08:04 jayzhou316