Adding a Chart or Worsheet??? with VB.NET

  • Thread starter Thread starter paul.lorena
  • Start date Start date
P

paul.lorena

Hi:
I have this problem, I have to insert first a chart, after a worksheet
to an excel file with VB.NET.

I'get an error in line 3 (below) "not found public member 'Cells' in
type 'Chart'"

How Can I define in line (1) the type of worksheets???

1 >excelBook.Sheets.Add(Before:=excelBook.Sheets(tablename + 1))
2 >For Each dcColumn In dstDataset.Tables(tablename).Columns
3 > excelApp.ActiveSheet.Cells(1, x) = dcColumn.ColumnName
4 > x += 1
5 > Next


thanks in advance!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically selecting active chart 4
create chart with column axis 10
hyperlinking to charts in file 1
I need to give index number to charts 3
Charts Having X Axis Scaled Using Calendar Weeks 4
Can I get a chart object (excel.ChartObject) from OLE_chart.object 4
how to set last/latest value of a line chart to a static cell? 4
Want Macro to save to .xlsx 2

Back
Top