开发者

Problem with reading excel cell value to a VARIANT

I'm reading a excel cell value to a VARIANT data type from VBA code. When I enter a integer value to the cell, the VARIANT always takes the argument as type double. Please help me 开发者_JS百科to rectify this problem.

Thank you


Excel Cells do not have an integer type: Excel numbers are always doubles. So there is no way of getting an integer/long variant subtype except by doing an implicit or explicit conversion.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜