Free Support Forum - aspose.com

Column selecting

Is there a programmatic way to select a column so it will be highlighted?

In Excel, it's Columns("E:E").Select, but I didn't see anything in Worksheet.Columns that would allow me to accomplish this.

Aspose.Grid.Desktop 1.9.4.4

Currently this feature is not available. We will look into it and get back to you next week. Thank you.

Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached fix. The new added method Worksheet.AddSelectedRange() enables user to add selection range to worksheet.

Kindly consult the following method that select column E:

Aspose.Grid.Desktop.Worksheet sheet = gridDesktop1.Worksheets[0];

CellRange cr = sheet.CreateRange(0, 5, sheet.RowsCount, 5);

sheet.AddSelectedRange(cr);

Thank you.