Hi everyone,
I had a problem when I tried to modify Excel Sheet with Microsoft.Offic e.Interop.Excel l.dll. Everything seem ok until I changed the regions of computer to another(Germany ) which was different with English state.
when executing this line
cellitem.Format Conditions[1].Modify(XlFormatCondit ionType.xlExpre ssion, XlFormatConditi onOperator.xlEq ual, "=AND($X$" + position + ">2,MOD($X$ " + position + ",2)=0)", "");
I had error exception:
{"The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) "}
The reason is some functions of that dll can not work with the formats(currenc y, datetime, number...) doesn't like English format.
I think that all the problems would be solve if i found the correct dll using in Germany location but i still not finding it.
Have anyone ever done with this situation and solved it! Please help.
Thanks,
I had a problem when I tried to modify Excel Sheet with Microsoft.Offic e.Interop.Excel l.dll. Everything seem ok until I changed the regions of computer to another(Germany ) which was different with English state.
when executing this line
cellitem.Format Conditions[1].Modify(XlFormatCondit ionType.xlExpre ssion, XlFormatConditi onOperator.xlEq ual, "=AND($X$" + position + ">2,MOD($X$ " + position + ",2)=0)", "");
I had error exception:
{"The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) "}
The reason is some functions of that dll can not work with the formats(currenc y, datetime, number...) doesn't like English format.
I think that all the problems would be solve if i found the correct dll using in Germany location but i still not finding it.
Have anyone ever done with this situation and solved it! Please help.
Thanks,