| Urgent: An Excel File from Report [message #90274] |
Mon, 10 January 2005 00:32  |
arupa
Messages: 3
Registered: January 2005
|
Junior Member |
|
|
Hi,
To the all members,
I want to generate report in .xls format.
I have done it by using the destination file name with .xls extention. But when i want to open it with excel the generated file namely *.xls i have to import it what don't want, and the rows and columns are not distributed properly. What i want is- when i use the .xls extention in the file desname it will generate an actual excel file, what i don't want to import it which is a normal procedure. It'll open as a normal excel file without showing me the dialog box what displayed in time of import.
For e.g.
suppose there is a line in my report
'For the Day Of 11/12/2004'
and the output in the excel sheet is given as follows
A | B | C | D | E | F | G |
--------------------------------------------------
F| |or | The |Day |Of |11/12/2004
|
|
|
|
| Re: Urgent: An Excel File from Report [message #90302 is a reply to message #90274] |
Wed, 26 January 2005 20:51  |
Rohit
Messages: 43
Registered: January 2002
|
Member |
|
|
Please follow the steps:
1. While in the live previewer. Goto View -> Runtime Preview...
2. In the Runtime Preview . File -> Generate to File
-> Delimited .
3. Supply the required paramaters.
4. Give the file name as "file.xls". And your job is done.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
