|
using (ExcelEngine excelEngine = new ExcelEngine())
{
//Instantiate the Excel application object
IApplication application = excelEngine.Excel;
//Assigns default application version
application.DefaultVersion = ExcelVersion.Xlsx;
//Load the file into stream
FileStream inputStream = new FileStream("Sample.xlsx", FileMode.Open);
//Loads or open an existing workbook through Open method of IWorkbooks
IWorkbook workbook = application.Workbooks.Open(inputStream);
//Access first worksheet from the workbook
IWorksheet worksheet = workbook.Worksheets[0];
//Copy the cell format
worksheet.Range["A5"].CopyTo(worksheet.Range["A6:A10"]);
FileStream stream = new FileStream("Style.xlsx", FileMode.Create, FileAccess.ReadWrite);
workbook.SaveAs(stream);
stream.Dispose();
} | 
