Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2009

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Export Mathematica->Excel [specific sheet]

  • To: mathgroup at smc.vnet.net
  • Subject: [mg99278] Re: Export Mathematica->Excel [specific sheet]
  • From: "Hans Michel" <hmichel at cox.net>
  • Date: Fri, 1 May 2009 05:52:54 -0400 (EDT)
  • References: <gtbtte$278$1@smc.vnet.net>

Export to an Excel Format if I recall over writes the previous file.

But if you want to export to a specific location as in your request B2:C3 
whatever their RC equivalent is

Try the following
n = Table[i - j, {i, 2}, {j, 2}]
Export["c:\\tfile.xls",
ArrayPad[SparseArray[Transpose[n], Dimensions[Transpose[n]], ""], {1, 2},
""]]

Look at using PadLeft also

This will place 2x2 matrix in position you asked as far as sheet name since 
the file name is going to be over written no sense naming it.

If you wish to edit or append to a preexisting excel file then you will have 
to treat that excel file like a database an connect to it. And select or 
update the row,column in question.

Hans

<soskha at gmail.com> wrote in message news:gtbtte$278$1 at smc.vnet.net...
> Hi,
> Does anybody know how to set the location for the data when exporting
> (for example) a 2x2 data matrix from Mathematica to Excel? - say I
> want the matrix to cover cells B2:C3 in "Sheet2"...
> I've been looking around on the internet for a solution, but I can't
> seem to find anything.
> 



  • Prev by Date: Question about Tally on a list of lists
  • Next by Date: mathematica newbie trouble
  • Previous by thread: Re: Export Mathematica->Excel [specific sheet]
  • Next by thread: Re: How do I send the palette behind other windows?