Ole properties when handling Excel NumberFormatLocal error-CodePudding

Such as title, with ole export Excel under the XE8 time attributes NumberFormatLocal report "is not the correct variable type";

 
WideString range=C4: "T" + IntToStr (r); 
VRange=vSheet. OlePropertyGet (" Range ", the Range c_bstr ());//to get correct 
VRange. OleProcedure (" Select "); 
VRange. OlePropertySet (" NumberFormatLocal ", "0.00");//the error "is not the correct variable type"

Code in the program execution to the fourth row error, also try to press the cell set, submitted to the same fault, please give directions;

CodePudding user response:

Try in excel operation record macro code, according to the macro code translated into c + +,

CodePudding user response:

reference 1st floor ooolinux response:

try in excel operation record macro code, according to the macro code translated into c + +,

can help me with it? [face] monkey2:019 PNG [/face]

CodePudding user response:

Baidu recorded macro code