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
>
>
>
>