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

MathGroup Archive 2009

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

Search the Archive

Re: Re: How to modify an Excel file

  • To: mathgroup at smc.vnet.net
  • Subject: [mg95434] Re: Re: How to modify an Excel file
  • From: "Tugrul Temel" <temelt at xs4all.nl>
  • Date: Sun, 18 Jan 2009 05:33:22 -0500 (EST)
  • References: <gkkf19$gn9$1@smc.vnet.net> <200901171032.FAA14533@smc.vnet.net>

Dear Norbert Marxer

I tried to work out the example you have given in your earlier e-mail. It
works fine until the following point... but then I am not able to get the
Charts properly as I receive "$Failed" commands and it seems that I face
with "exceptions" but I do not know how to deal with these exceptions. Could
you tell me if you know..

Tugrul
 

*************************************************

You can even create a chart:

chartCastSep =
 CastNETObject[workbook[Charts[][Add[]]],
  "Microsoft.Office.Interop.Excel.ChartClass"]
chartCastSep@ChartWizard[srcRange];

If you prefer a XY scatter plot then:

LoadNETType["Microsoft.Office.Interop.Excel.XlChartType"]
chartCastSep[
 ChartWizard[srcRange, XlChartType`xlXYScatter, format = 1,
  plotBy = 2, catLab = 1, serLab = 0, hasLegend = True, "Title",
  "CategoryTitle", "ValueTitle", "ExtraTitle"]]

*************************************************











  • Prev by Date: Re: Which editor do you use for math articles
  • Next by Date: Re: Re: Mathematica 7 on an Asus Eee PC Laptop?
  • Previous by thread: Re: How to modify an Excel file
  • Next by thread: Maximizing function which defines a routine