Board index » delphi » How can I add new sheet to Excel

Yucel

Delphi Developer
Mon, 25 Oct 2004 20:51:53 GMT

How can I add new sheet to Excel

There is default 3 sheet in Excel bu I need to more. How can I add new
sheet?
 
Shannon Broski

Delphi Developer
Tue, 26 Oct 2004 00:17:43 GMT

Re:How can I add new sheet to Excel


          ExcelObject.Worksheets.Add(EmptyParam, ExcelObject.ActiveSheet, 1,
xlWorksheet, LCID);
Quote
"Yucel" <ykarapi...@hotmail.com> wrote in message news:3cda70a6_2@dnews...
> There is default 3 sheet in Excel bu I need to more. How can I add new
> sheet?

Yuce

Delphi Developer
Tue, 26 Oct 2004 14:34:32 GMT

Re:How can I add new sheet to Excel


It give like some this error:
Raised exception class EOleSysError with message 'Invalid parameter number'

Can you give me working example with parameter detailed?

Jesús Avilés Martíne

Delphi Developer
Tue, 26 Oct 2004 16:31:34 GMT

Re:How can I add new sheet to Excel


Quote
Yucel wrote:
> It give like some this error:
> Raised exception class EOleSysError with message 'Invalid parameter number'

> Can you give me working example with parameter detailed?

var
   Excel: ExcelApplication;
   Hoja: ExcelWorksheet;

begin
   ...
   Hoja :=
Excel.Sheets.Add(EmptyParam,Excel.Sheets[Excel.Sheets.Count],1,EmptyParam,LCID)
as ExcelWorksheet;
end;

This works fine for me

--
JAM - Reljate y disfruta...

Yuce

Delphi Developer
Tue, 26 Oct 2004 17:13:34 GMT

Re:How can I add new sheet to Excel


I'm using Delphi 3.
{uses ComObj}

It displaying this errors:

Undefined identifier: 'ExcelApplication'.
Undefined identifier: ExcelWorksheet'.
Undefined identifier: EmptyParam'.
'(' expected but ')' found.
.........

Jess Avils Martnez , <3CDB8566.8090...@PEICHjazzfree.com> iletisine
yazdy...

Quote
>Yucel wrote:

>> It give like some this error:
>> Raised exception class EOleSysError with message 'Invalid parameter
number'

>> Can you give me working example with parameter detailed?

>var
>   Excel: ExcelApplication;
>   Hoja: ExcelWorksheet;

>begin
>   ...
>   Hoja :=
>Excel.Sheets.Add(EmptyParam,Excel.Sheets[Excel.Sheets.Count],1,EmptyParam,L
CID)
>as ExcelWorksheet;
>end;

>This works fine for me

>--
>JAM - Reljate y disfruta...

Jesús Avilés Martíne

Delphi Developer
Tue, 26 Oct 2004 17:21:19 GMT

Re:How can I add new sheet to Excel


Quote
Yucel wrote:
> I'm using Delphi 3.
> {uses ComObj}

> It displaying this errors:

> Undefined identifier: 'ExcelApplication'.
> Undefined identifier: ExcelWorksheet'.
> Undefined identifier: EmptyParam'.
> '(' expected but ')' found.
> .........

> Jess Avils Martnez , <3CDB8566.8090...@PEICHjazzfree.com> iletisine
> yazdy...

>>Yucel wrote:

>>>It give like some this error:
>>>Raised exception class EOleSysError with message 'Invalid parameter

> number'

>>>Can you give me working example with parameter detailed?

>>var
>>  Excel: ExcelApplication;
>>  Hoja: ExcelWorksheet;

>>begin
>>  ...
>>  Hoja :=
>>Excel.Sheets.Add(EmptyParam,Excel.Sheets[Excel.Sheets.Count],1,EmptyParam,L

> CID)

>>as ExcelWorksheet;
>>end;

>>This works fine for me

>>--
>>JAM - Reljate y disfruta...

You can replace ExcelApplication and ExcelWorksheet by Variant or
OleVariant and delete the "as ExcelWorksheet". I think EmptyParam can be
replaced by ''.

--
JAM - Reljate y disfruta...

Yuce

Delphi Developer
Tue, 26 Oct 2004 21:44:31 GMT

Re:How can I add new sheet to Excel


var
  Excel, Hoja: OleVariant;
begin
  Excel := CreateOleObject('Excel.Application');
  Excel.Visible := true;
  Excel.Workbooks.Add;
  Hoja:=Excel.Sheets.Add('',Excel.Sheets[Excel.Sheets.Count],1,'',LCID(1));
end;
// it doesn't work with LCID, so I write LCID(1)

In runtime, it giving 'Invalid parameter number' error. What is wrong?

Mike Shkolni

Delphi Developer
Fri, 29 Oct 2004 19:37:28 GMT

Re:How can I add new sheet to Excel


You can skip any parameters in Add method:
Hoja := Excel.Sheets.Add;

--
With best regards, Mike Shkolnik
E-Mail: mshkol...@scalabium.com
WEB: http://www.scalabium.com

Yucel <ykarapi...@hotmail.com> D??? ???Y??:3cdbce7a_1@dnews...

Quote
> var
>   Excel, Hoja: OleVariant;
> begin
>   Excel := CreateOleObject('Excel.Application');
>   Excel.Visible := true;
>   Excel.Workbooks.Add;

Hoja:=Excel.Sheets.Add('',Excel.Sheets[Excel.Sheets.Count],1,'',LCID(1));
Quote
> end;
> // it doesn't work with LCID, so I write LCID(1)

> In runtime, it giving 'Invalid parameter number' error. What is wrong?

Yuce

Delphi Developer
Fri, 29 Oct 2004 21:10:28 GMT

Re:How can I add new sheet to Excel


It is working, finally. Thank you very much Mike and all...

Mike Shkolnik , <3cdfa4f3_1@dnews> iletisine yazdy...

Quote
>You can skip any parameters in Add method:
>Hoja := Excel.Sheets.Add;

>--
>With best regards, Mike Shkolnik
>E-Mail: mshkol...@scalabium.com
>WEB: http://www.scalabium.com

>Yucel <ykarapi...@hotmail.com> D??? ???Y??:3cdbce7a_1@dnews...
>> var
>>   Excel, Hoja: OleVariant;
>> begin
>>   Excel := CreateOleObject('Excel.Application');
>>   Excel.Visible := true;
>>   Excel.Workbooks.Add;

>Hoja:=Excel.Sheets.Add('',Excel.Sheets[Excel.Sheets.Count],1,'',LCID(1));
>> end;
>> // it doesn't work with LCID, so I write LCID(1)

>> In runtime, it giving 'Invalid parameter number' error. What is wrong?

Jesús Avilés Martíne

Delphi Developer
Fri, 29 Oct 2004 23:19:44 GMT

Re:How can I add new sheet to Excel


Quote
"Yucel" <ykarapi...@hotmail.com> wrote:
>var
>  Excel, Hoja: OleVariant;
>begin
>  Excel := CreateOleObject('Excel.Application');
>  Excel.Visible := true;
>  Excel.Workbooks.Add;
>  Hoja:=Excel.Sheets.Add('',Excel.Sheets[Excel.Sheets.Count],1,'',LCID(1));
>end;
>// it doesn't work with LCID, so I write LCID(1)

>In runtime, it giving 'Invalid parameter number' error. What is wrong?

Try to remove last parameter:

Hoja:=Excel.Sheets.Add('',Excel.Sheets.Excel.Sheets.Count],1,'');

Yuce

Delphi Developer
Sat, 30 Oct 2004 14:26:24 GMT

Re:How can I add new sheet to Excel


This time it giving this error :
"Class of Sheets Add method is unsuccessful"

But this working:
Hoja := Excel.Sheets.Add;

Thanks...

Jess Avils Martnez , <3cdfd990$1_1@dnews> iletisine yazdy...

Quote

>"Yucel" <ykarapi...@hotmail.com> wrote:
>>var
>>  Excel, Hoja: OleVariant;
>>begin
>>  Excel := CreateOleObject('Excel.Application');
>>  Excel.Visible := true;
>>  Excel.Workbooks.Add;

Hoja:=Excel.Sheets.Add('',Excel.Sheets[Excel.Sheets.Count],1,'',LCID(1));
Quote
>>end;
>>// it doesn't work with LCID, so I write LCID(1)

>>In runtime, it giving 'Invalid parameter number' error. What is wrong?

>Try to remove last parameter:

>Hoja:=Excel.Sheets.Add('',Excel.Sheets.Excel.Sheets.Count],1,'');

Other Threads

1. Copy Current Excel sheet to a New Sheet

2. Adding the labels in a data sheet to an excel chart

3. Delphi Add In to Excel to load sheet cells

4. Excel 97 : Adding Names in sheet

5. How to insert new Sheet in Excel

6. Write Excel sheet without Excel

7. Adding a new worksheet to excel

8. Adding New workSheet in Excel.

9. Excel - using Excel VBA to call functions stored in a Delphi COM Add-In

10. Building Excel add-in with Excel