On 3/2/06, Anssi Seppälä <[EMAIL PROTECTED]> wrote: > Reading numeric data from Excel the decimal separator is here comma " > , ". Since in J the text-to-num-conversion function ". does not > understand comma as decimal separator I must change the commas in the > boxed matrix DATA to dots.
Not a solution, but maybe a work-around: change your regional settings. This should impact Excel immediately without the need to close and reopen the application. It should be possible to write a small script that changes the regional settings, presses Ctrl-C and changes the settings back with a tool such as Auto-It or one of the several macro creators out there. (I have solved similiar problems that way, but then J wasn't involved.) /Micke ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
