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