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

MathGroup Archive 2009

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

Search the Archive

Re: how to specify sheet names in xls export?

  • To: mathgroup at smc.vnet.net
  • Subject: [mg96901] Re: how to specify sheet names in xls export?
  • From: "Hans Michel" <hmichel at cox.net>
  • Date: Fri, 27 Feb 2009 06:09:42 -0500 (EST)
  • References: <go63v8$q4j$1@smc.vnet.net>

Mitch:

Mathematica v7
Clear[data];
data = Table[100 i + 10 j + k, {i, 2}, {j, 3}, {k, 4}];
Export["C:\\test_sheet_name.xls", {"sheet1 name here" -> data[[1]],
"sheet2 name here" -> data[[2]]}]

Please note that there is a tutorial in document center serach 
"howto/ExportASpreadsheet"

or

\!\(\*
TagBox[
ButtonBox[
PaneSelectorBox[{
False->"\<\"http://reference.wolfram.com/mathematica/howto/\
ExportASpreadsheet.html\"\>", True->
StyleBox["\<\"http://reference.wolfram.com/mathematica/howto/\
ExportASpreadsheet.html\"\>", "HyperlinkActive"]}, Dynamic[
CurrentValue["MouseOver"]],
BaseStyle->{"Hyperlink"},
BaselinePosition->Baseline,
FrameMargins->0,
ImageSize->Automatic],
BaseStyle->"Hyperlink",
ButtonData->{
URL["http://reference.wolfram.com/mathematica/howto/ExportASpreadsheet.html";],
None},
ButtonNote->
"http://reference.wolfram.com/mathematica/howto/ExportASpreadsheet.html";],
Annotation[#,
"http://reference.wolfram.com/mathematica/howto/ExportASpreadsheet.html";,
"Hyperlink"]& ]\)

simply 
http://reference.wolfram.com/mathematica/howto/ExportASpreadsheet.html



"Mitch Murphy" <mitch at lemma.ca> wrote in message 
news:go63v8$q4j$1 at smc.vnet.net...
>
> is there a way to specify the sheet names when exporting excel xls
> spreadsheets? i couldn't find much details in the documentation. my
> best attempt so far is:
>
> Export["test_sheet_name.xls", Table[100 i + 10 j + k, {i, 2}, {j, 3},
> {k, 4}], "Sheets" -> {"a", "b"}]
>
> but that doesn't work...
>
> any help/suggestions please?
>
> thanks,
> Mitch
>
>
>
> 



  • Prev by Date: Re: Need some help with monitoring evaluation
  • Next by Date: Re: Map and functional constructs to replace iterative statements
  • Previous by thread: Re: how to specify sheet names in xls export?
  • Next by thread: lock image size in a cell