Creating Multiple Page Excel Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating an excel spreadsheet from a data grid, there are more than 255 columns (approx 660), and so I need to create threee tabs or sheets. I have done this in VB6 but could use some help in .Net. I dimension objExcel as a new excel application, but when I type .sheets my only option is 'Get Type'. I have tried several combinations but I hit a wall everytime.

Any help will be appreciated.
Thanks
Jack
 
* =?Utf-8?B?SmFjayBN?= said:
I am creating an excel spreadsheet from a data grid, there are more
than 255 columns (approx 660), and so I need to create threee tabs or
sheets. I have done this in VB6 but could use some help in .Net. I
dimension objExcel as a new excel application, but when I type .sheets
my only option is 'Get Type'. I have tried several combinations but I
hit a wall everytime.
Click to expand...

Sample for Excel automation:

HOWTO: Automate Microsoft Excel from Visual Basic .NET
<http://support.microsoft.com/default.aspx?scid=kb;en-us;301982>
 
Back
Top