We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
COURSE of the MONTH
8 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Delphi6 OleApplication Excel How to add new worksheets to active workbook.
Posted on 2004-04-05
Have a need to have seven initial worksheets in a workbook, but how do you add another 4 to the three as default? Both the 'add on opening' workbook and the 'add on fly' to an open workbook methods are required please. Code so far...
procedure ExcelOpen(Sender: TObject; Excelname:String);
begin
// If the workbook exists, open it, else create an instance of it.
OleApplication := CreateOleObject('Excel.App
OleApplication.visible :=false;
if fileexists(dataq.outdir+'\
begin
OleWorkBook:=OleApplicatio
end else begin
OleWorkBook:=OleApplicatio
// what is the code that should generate the total 7 worksheets?
end;
end;
procedure ExcelOpen(Sender: TObject; Excelname:String);
begin
// If the workbook exists, open it, else create an instance of it.
OleApplication := CreateOleObject('Excel.App
OleApplication.visible :=false;
if fileexists(dataq.outdir+'\
begin
OleWorkBook:=OleApplicatio
end else begin
OleWorkBook:=OleApplicatio
// what is the code that should generate the total 7 worksheets?
end;
end;
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
The following code will ensure that each workbook you open has 7 worksheets available.
Hope this helps,
Russell
procedure ExcelOpen(Sender: TObject; Excelname:String);
var OleApplication: OleVariant;
OleWorkBook: Olevariant;
dwIndex: Integer;
begin
// If the workbook exists, open it, else create an instance of it.
OleApplication:=CreateOleO
OleApplication.Visible:=Fa
if fileexists(dataq.outdir+'\
OleWorkBook:=OleApplicatio
else
OleWorkBook:=OleApplicatio
// what is the code that should generate the total 7 worksheets?
for dwIndex:=OleWorkBook.WorkS
begin
OleWorkBook.Worksheets.Add
end;
end;
Hope this helps,
Russell
procedure ExcelOpen(Sender: TObject; Excelname:String);
var OleApplication: OleVariant;
OleWorkBook: Olevariant;
dwIndex: Integer;
begin
// If the workbook exists, open it, else create an instance of it.
OleApplication:=CreateOleO
OleApplication.Visible:=Fa
if fileexists(dataq.outdir+'\
OleWorkBook:=OleApplicatio
else
OleWorkBook:=OleApplicatio
// what is the code that should generate the total 7 worksheets?
for dwIndex:=OleWorkBook.WorkS
begin
OleWorkBook.Worksheets.Add
end;
end;
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Objective:
- This article will help user in how to convert their numeric value become words.
How to use
1. You can copy this code in your Unit as function
2. than you can perform your function by type this code
The Code
(CODE)
The Im…
Introduction
I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need.
This article will address some of the concepts when dealing with a multithreaded delphi database…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month8 days, 22 hours left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.