OraFAQ Forum: SQL & PL/SQL » AS_XLSX. how to set worksheet name

Home » SQL & PL/SQL » SQL & PL/SQL » AS_XLSX. how to set worksheet name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AS_XLSX. how to set worksheet name [message #679232]

Mon, 17 February 2020 04:25

calacausi
Messages: 21
Registered: March 2012

Junior Member

hi,
Im creating excel files from oracle DB, using AS_XLSX package.
is there a way to set worksheet name?
thanks

Report message to a moderator

Re: AS_XLSX. how to set worksheet name [message #679233 is a reply to message #679232]

Mon, 17 February 2020 05:22

Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why don't you ask the author?
But first question: which AS_XLSX? The one from Anton Scheffer or the one from mazdik?

Report message to a moderator

Re: AS_XLSX. how to set worksheet name [message #679234 is a reply to message #679233]

Mon, 17 February 2020 05:34

calacausi
Messages: 21
Registered: March 2012

Junior Member

Michel Cadot wrote on Mon, 17 February 2020 12:22

Why don't you ask the author?
But first question: which AS_XLSX? The one from Anton Scheffer or the one from mazdik?

scheffer's one

Report message to a moderator

Re: AS_XLSX. how to set worksheet name [message #679235 is a reply to message #679234]

Mon, 17 February 2020 05:46

Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can contact him on Amis Technology site.

[Updated on: Mon, 17 February 2020 05:46]

Report message to a moderator

Re: AS_XLSX. how to set worksheet name [message #679236 is a reply to message #679235]

Mon, 17 February 2020 07:08

Bill B
Messages: 1971
Registered: December 2004

Senior Member

When you open a new sheet the default is to use sheet1...sheet2...etc, however you can name it to what you want by supplying an argument

As_xlsx.New_sheet ('MyData');

Report message to a moderator

Previous Topic:	test failed: ORA-01017 invalid username / password access denied
Next Topic:	How To Show Non Matching rows in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 15 15:04:07 CDT 2022