Range address when selecting a column

[JanGunawan]

Hi there,

I am currently evaluating your product Spire.XLS.

I noticed that you can get a CellRange object by refering the range using "A1:B2" format from the Worksheet object.
However, is it possible to also get a whole columns range when you pass in "A:B" into the Range[address] value, as VBA does?

See the following link for some examples:
https://msdn.microsoft.com/en-us/librar ... 12%29.aspx

Thanks and Regards
Jan

[burning.liu]

Hello JanGunawan,

Thanks for your inquiry.

I'm sorry that Spire.Xls doesn't support the range format like "A:B" or "A:A".

You must set row number before get the cell range like "A1:B5".