-5
$\begingroup$

I have an XL File with data like :

  {{1,2,3},{4,5,6},{7,8,9}}

That XL file name as "MySheet1".

I want to

  1. change {2,2} position value(5 to 11).
  2. change entire Third row.

for that purpose I tryed with Export still not get it.

can anybody help me?

$\endgroup$
  • 5
    $\begingroup$ did you (say) look in the docs at all? $\endgroup$ – acl Nov 30 '12 at 12:41
5
$\begingroup$

You can do it like this:

a = Import["xl.xls"];
a[[1, 2, 2]] = 11;
a[[1, 3]] = {10, 20, 30};
Export["xl.xls",a];
$\endgroup$

Not the answer you're looking for? Browse other questions tagged or ask your own question.