Copy Range Data with Style

[ ]

Aspose.Cells provides a range of classes and methods for working with ranges, for example, CreateRange(), StyleFlag and ApplyStyle().

This example:

  1. Creates a workbook.
  2. Fills a number of cells in the first worksheet with data.
  3. Creates a Range.
  4. Creates a Style object with specified formatting attributes.
  5. Applies the style to the data range.
  6. Creates a second range of cells.
  7. Copies data with the formatting from the first range to the second range.