Free Support Forum - aspose.com

Applying style to a range of cells

Hello,

I'm using Aspose.Cells to generate an Excel spreadsheet, and I'm having problems finding a way to apply a style to a wide range of cells at once using vb.net. I am not using Grid Desktop, so the ways that it's show being done in your support documentation are not working for me.

What is the best way using Aspose.Cells to apply a single style to a wide range of cells?

Hi,

Thanks for using Aspose.Cells for .NET.

Please see the following article. It also explains how to use the ApplyStyle() method for your needs. It applies a single style to range of cells.

http://www.aspose.com/docs/display/cellsnet/Copy+Range+Data+with+Style