Syntactic Confectionery Delight | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Hi, I can't get some values from some cells containing formulas, I get #NAME! or #VALUE! instead. Now, this wouldn't be a problem if I knew that those formulas don't work, but they do! I know that because I can read values representing formula results from other cells just fine (some of them containing more complicated formulas than the ones in question). Also, if I open Excel manually and look into those cells, I see "normal" values (numbers). I'm using Win32::OLE, and the code goes something like this:
or
This excel is linked to another file, and I get that by setting (both excel files are opened anyway) Am I missing something? In reply to Reading from Excel by Hrvoje
|
|