topic Re: problem while saving list output as local file. in Application Development and Automation Discussions

problem while saving list output as local file.

Former Member — Fri, 19 Oct 2007 09:31:14 GMT

Hi Gurus!

i want to save the list output of classical report into excel but complete data is not coming into excel file.

[SYSTEM - > LIST ->SAVE -> LOCAL ->SPREADSHEET ]

when same output is transfer to unconverted file [notepad ] then completed data is coming.

please help me ,

points sure!

Rahul

Message was edited by:

rahul deshmukh

Re: problem while saving list output as local file.

Former Member — Fri, 19 Oct 2007 09:50:54 GMT

HI Rahul.

Please try to download the report in Unconverted format only and then open that unconverted file in excel.

SYSTEM - > LIST ->SAVE -> LOCAL ->UNCONVERTED

Hope this works.

Reward if you find it useful.

REgards.

Akhil

Re: problem while saving list output as local file.

Former Member — Fri, 19 Oct 2007 09:57:24 GMT

hi akhil ,

but its getting in proper format.

Re: problem while saving list output as local file.

Former Member — Fri, 19 Oct 2007 10:15:24 GMT

Yes Rahul, I know that and you have to do the formating. This is how you can do.

Open the unconverted file in Excel format.

Select the first column and then goto Data - Text to Columns , a pop up will come.

Select Delimited, then press next.

Then selct the delimeter that is used in the unconverted file to seperate two columns. Say for example if ' | ' is used then in others write ' | ' and press next.

IN the data preview section select all the columns and then select text radio button on top and press finish finally.

Now u will get the proper format of the file. Delete all the empty rows and columns that u don't want.

Reward if you find it useful.

Regards.

Akhil.