Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Jan 29, 2015 2:21 am

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

JanGunawan
 
Posts: 1
Joined: Thu Jan 29, 2015 12:43 am

Thu Jan 29, 2015 3:22 am

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".
Best Regards,
Burning
E-iceblue Support Team
User avatar

burning.liu
 
Posts: 406
Joined: Mon Aug 04, 2014 6:47 am

Return to Spire.XLS