excel.h - Automating Excel... How to Create new worksheets

[Jona]

Hi, I'm trying to create new Worksheets in my code but I really have
no clue how to...
here is part of my code.
Thanks for your help in advance.

//Header declarations..
_Application xlApp;
Workbooks wb;
_Workbook _wb;
Worksheets ws;

//Source
//Add Workbook
wb = xlApp.GetWorkbooks();
_wb = wb.Add(covOptional);
ws = _wb.GetSheets();

//Remove the 3 default sheets
_Worksheet selSheet;
selSheet = ws.GetItem(COleVariant((short)1));
selSheet.Delete();
selSheet = ws.GetItem(COleVariant((short)2));
selSheet.Delete();
selSheet = ws.GetItem(COleVariant((short)3));
selSheet.Delete();



If you want to rename any of these sheets is really easy//
selSheet = ws.GetItem(COleVariant((short)2));
selSheet.SetName("NonInteractive Mode Results");

-Jona

 

[shadowman]

Hi, I'm trying to create new Worksheets in my code but I really have
no clue how to...
here is part of my code.
Thanks for your help in advance.

//Header declarations..
_Application xlApp;
Workbooks wb;
_Workbook _wb;
Worksheets ws;

//Source
//Add Workbook
wb = xlApp.GetWorkbooks();
_wb = wb.Add(covOptional);
ws = _wb.GetSheets();

//Remove the 3 default sheets
_Worksheet selSheet;
selSheet = ws.GetItem(COleVariant((short)1));
selSheet.Delete();
selSheet = ws.GetItem(COleVariant((short)2));
selSheet.Delete();
selSheet = ws.GetItem(COleVariant((short)3));
selSheet.Delete();



If you want to rename any of these sheets is really easy//
selSheet = ws.GetItem(COleVariant((short)2));
selSheet.SetName("NonInteractive Mode Results");

-Jona

Try microsoft.public.excel.programming

 

[Victor Bazarov]

Hi, I'm trying to create new Worksheets in my code but I really have
no clue how to...

Neither do we. There is no definition of "Excel" or "worksheet" in
C++ _language_. You need to ask in the newsgroup dedicated to Excel
and/or whatever toolkit you're using. Try the 'microsoft.public.*'
hierarchy.

[..]

V