OraFAQ Forum: Forms » forms data into excel sheet

Home » Developer & Programmer » Forms » forms data into excel sheet

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

forms data into excel sheet [message #113163]

Thu, 31 March 2005 05:02

hsinghalmrt
Messages: 51
Registered: March 2005

Member

hi!,
How can we transfer the data displayed in the form into an
excel sheet.

Report message to a moderator

Re: forms data into excel sheet [message #113258 is a reply to message #113163]

Thu, 31 March 2005 22:18

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Create a CSV file.

Report message to a moderator

Re: forms data into excel sheet [message #113291 is a reply to message #113163]

Fri, 01 April 2005 02:03

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

You'll have to define procedures for this purpose. See the forms documentation for using EXCEL, Word etc...

Report message to a moderator

Re: forms data into excel sheet [message #113307 is a reply to message #113258]

Fri, 01 April 2005 04:25

hsinghalmrt
Messages: 51
Registered: March 2005

Member

hi ,
can you please send the exact process of making CSV file.
thanks,
himanshu

Report message to a moderator

Re: forms data into excel sheet [message #113472 is a reply to message #113307]

Mon, 04 April 2005 01:26

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

A CSV format file, for me, means create a file and put the data in it so that it resembles 'csv' format.

To create a file, depending on the version of forms and PL/SQL installed, use either TEXT_IO or UTL_FILE. Do a search on OTN or google and you will find heaps of references to these keywords. You can also 'read' the comments for 'utl_file' by querying the synonym 'ALL_SOURCE' for 'NAME=UTL_FILE AND TYPE=PACKAGE' and order by line.

Each record is simply alphabetic strings and dates between double quotes and numbers in the raw separated by a comma. See the seven field example below. Dates needs to satisfy your local formatting. Nulls can be done two ways. Make your life easier and have the same number of fields on each line.

"Surname","First Name","01-NOV-04",1234.678,"",,

Basically, open the file, write a record, close the file. Then manually start Excel and open the file, or, in explorer, double click on the file and, assuming 'csv' files have been associated with Excel, it will open in the spreadsheet.

[Updated on: Mon, 04 April 2005 01:26]

Report message to a moderator

Re: forms data into excel sheet [message #113479 is a reply to message #113291]

Mon, 04 April 2005 01:52

tsilav
Messages: 22
Registered: September 2004

Junior Member

Where i can see this forms documentation for excel and for word?

Report message to a moderator

Re: forms data into excel sheet [message #113482 is a reply to message #113479]

Mon, 04 April 2005 02:13

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry I wrote some stuff before reading your comment fully.

[Updated on: Mon, 04 April 2005 02:15]

Report message to a moderator

Re: forms data into excel sheet [message #113486 is a reply to message #113482]

Mon, 04 April 2005 02:42

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

Well
If you can't write the code to display your data from forms into the excel sheet then there's a utility here to use.
Check this out.
http://www.oraxcel.com

Report message to a moderator

Re: forms data into excel sheet [message #113487 is a reply to message #113486]

Mon, 04 April 2005 03:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

hsinghalmrt,

EXACTLY what do you want to do with your Excel and Forms?

What functionality do you want to perform?

Where is the data?

David

Report message to a moderator

Re: forms data into excel sheet [message #113499 is a reply to message #113487]

Mon, 04 April 2005 05:19

hsinghalmrt
Messages: 51
Registered: March 2005

Member

actually suppose we have a form in tabular.
when we execute query in the form the data displays in the tabular block. and i also have a button on the form . i want that as i click on that button the data of the form which is displayed in the tabular block moves to the Excel Document.

Report message to a moderator

Re: forms data into excel sheet [message #114678 is a reply to message #113499]

Mon, 04 April 2005 23:19

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If you want all the rows to go to the 'csv' file then you can run the query as a stand-alone query and write the data to a new 'csv' file.

If you want to 'export' selected rows then you will have to scan the block row by row. Find and store the get_block_property attributes 'current_record' to know which is the current line and 'top_record' to know which line is at the top of the screen when the 'excel' button was pressed. Scan by going to row one and testing the 'select' check-box on each line. When you reach the end of all the retrieved records (:system.last_record = 'TRUE'), go to the row that was defined by the stored 'top_record' and then go to the row defined by the stored 'current_record'.

Report message to a moderator

Re: forms data into excel sheet [message #114869 is a reply to message #114678]

Wed, 06 April 2005 00:17

hsinghalmrt
Messages: 51
Registered: March 2005

Member

thank you david,
i try that and got data into excel shhet.

Report message to a moderator

Previous Topic:	In which Font Forms Data Stored in DB
Next Topic:	tab in text file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:14:07 CDT 2024