开发者

Translate a Excel Range to a row/col

开发者 https://www.devze.com 2022-12-31 02:38 出处:网络
I have looked all over but开发者_如何学JAVA can\'t find an answer to this... Quite simply put I have a VSTO Excel 2007 project that I want to be able to translate a cell (e.g. \"A1\") to integers row

I have looked all over but开发者_如何学JAVA can't find an answer to this...

Quite simply put I have a VSTO Excel 2007 project that I want to be able to translate a cell (e.g. "A1") to integers row 1, column 1.

Does anybody know of a built in method for this or do I have to write my own parser?


You could;

r = Range("AP100")

then r.row and r.column will return their numeric index.

0

精彩评论

暂无评论...
验证码 换一张
取 消