Add new sheet in Excel using mfc...
-
Hi, I need to add worksheets(like sheet2,sheet3,...) with the below exising code. Now sheet1 is coming by default and able to write the contents. Existing Code: -------------- COleException objEx; // exception object Application objExcel; // excel application object // local var COleVariant vRet; // row index long nRow = 1; // range object Range objRange; // create the excel object objExcel.CreateDispatch( "Excel.Application", &objEx ); // show the application objExcel.SetVisible( COleVariant(short(FALSE)) ); // get the workbooks object vRet = objExcel.Workbooks2(); // set the workbooks object Workbooks objWorkbooks( V_DISPATCH( (LPVARIANT)vRet ) ); // adding the new workbook vRet = objWorkbooks.Add( COleVariant( (long)xlWorksheet ) ); // set the workbook object Workbook objWorkbook( V_DISPATCH( (LPVARIANT)vRet ) ); // adding the worksheet vRet = objWorkbook.Worksheets( COleVariant( (long)1 ) ); // set the worksheet object Worksheet objWorksheet( V_DISPATCH( (LPVARIANT)vRet ) ); How to add more sheets with the above code? Please help. I am using below header files;
#include "XL5EN32.H"
#include "excel9.h"
#include "ExcelObject.h"Thanks, Pala
-
Hi, I need to add worksheets(like sheet2,sheet3,...) with the below exising code. Now sheet1 is coming by default and able to write the contents. Existing Code: -------------- COleException objEx; // exception object Application objExcel; // excel application object // local var COleVariant vRet; // row index long nRow = 1; // range object Range objRange; // create the excel object objExcel.CreateDispatch( "Excel.Application", &objEx ); // show the application objExcel.SetVisible( COleVariant(short(FALSE)) ); // get the workbooks object vRet = objExcel.Workbooks2(); // set the workbooks object Workbooks objWorkbooks( V_DISPATCH( (LPVARIANT)vRet ) ); // adding the new workbook vRet = objWorkbooks.Add( COleVariant( (long)xlWorksheet ) ); // set the workbook object Workbook objWorkbook( V_DISPATCH( (LPVARIANT)vRet ) ); // adding the worksheet vRet = objWorkbook.Worksheets( COleVariant( (long)1 ) ); // set the worksheet object Worksheet objWorksheet( V_DISPATCH( (LPVARIANT)vRet ) ); How to add more sheets with the above code? Please help. I am using below header files;
#include "XL5EN32.H"
#include "excel9.h"
#include "ExcelObject.h"Thanks, Pala