/// <summary> /// /// </summary> /// <param name="writeData"></param> public static void ReadMyExcel(WriteDataOnsheet writeData) { var xlsSheet = (Excel.Worksheet)MyBook.Sheets[writeData.SheetName]; foreach (var cell in writeData.CellsData) { cell.data = xlsSheet.Cells[cell.row, cell.column].Value; } MyBook.Save(); }
/// <summary> /// WriteToExcel /// </summary> /// <param name="writeData"></param> public static void WriteToExcel(WriteDataOnsheet writeData) { var xlsSheet = (Excel.Worksheet)MyBook.Sheets[writeData.SheetName]; foreach (var cell in writeData.CellsData) { xlsSheet.Cells[cell.row, cell.column] = cell.data; } MyBook.Save(); }