Home » SQL & PL/SQL » SQL & PL/SQL » AS_XLSX. how to set worksheet name
AS_XLSX. how to set worksheet name [message #679232] Mon, 17 February 2020 04:25 Go to next message
calacausi
Messages: 23
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
Re: AS_XLSX. how to set worksheet name [message #679233 is a reply to message #679232] Mon, 17 February 2020 05:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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?

Re: AS_XLSX. how to set worksheet name [message #679234 is a reply to message #679233] Mon, 17 February 2020 05:34 Go to previous messageGo to next message
calacausi
Messages: 23
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
Re: AS_XLSX. how to set worksheet name [message #679235 is a reply to message #679234] Mon, 17 February 2020 05:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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 Go to previous message
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');
Previous Topic: test failed: ORA-01017 invalid username / password access denied
Next Topic: How To Show Non Matching rows in oracle
Goto Forum:
  


Current Time: Fri Mar 29 01:25:11 CDT 2024