asp.net and excel

asp.net Portugal
  • 13 years ago

    i'm using vs2003 to develop an asp.net solution and i'm using excel to export some data to charts, but i'm having some problems with changing the the values of the series

    count of the series

    Dim

    ser As Excel.Series 

    Dim sc As Excel.SeriesCollection = CType(oChart.Chart.SeriesCollection, Excel.SeriesCollection)

    ser = sc.Item(sc.Count)

    then for selecting the chart

    oChart = oExcell.Worksheets("sheetname").ChartObjects("chartnumber")

    and for defining the series

    sc.Item(1).XValues = "=sheetname!R3C7:R" & maxdpos & "C7"

    sc.Item(1).Values = "=sheetname!R3C8:R" & maxdpos & "C8"

    sc.Item(2).Values = "=sheetname!R3C28:R" & maxdpos & "C28"

     

    btw maxdpos is a variable that recieves a value in a previous sub.

    i know that it's possible to do it, because the app i'm working was created in asp, and it works

     

    can anyone give me some pointers, or lead me in the right direction

    any help would be appreciatted

     

    thanks in advance

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Measuring programming progress by lines of code is like measuring aircraft building progress by weight.” - Bill Gates