Writing output to a Spreadsheet

vnspn · Post by **vnspn** » Thu Mar 08, 2007 4:07 pm

Hi,

I'm trying to write output data to a spreadsheet as a .csv file using Sequential File stage. When I view the output spreadsheet, I see that the entire row is in the first cell.

But I want it to be written in such a way that each column is in each cell of the spreadsheet. Please let me know what is the way or settings to get this.

Thanks.

chulett · Post by **chulett** » Thu Mar 08, 2007 4:26 pm

If you are writing a true 'csv' as in a 'comma separated value' file with a .csv extension, then Excel should load it up properly. What does the file look like when you open it in Notepad?

narasimha · Post by **narasimha** » Thu Mar 08, 2007 4:46 pm

What "Delimiter" are you using while creating the csv file in the sequential stage?

kumar_s · Post by **kumar_s** » Thu Mar 08, 2007 4:56 pm

Try avoiding Quote characters like single or double ', " if you have any. As noted, if its written properly, it can be easily opened in Excel, despite that, you can open the file specifying the respective column details.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 08, 2007 6:23 pm

Unless, of course, the delimiter character appears in data - in that case you DO need quoted character strings.

vnspn · Post by **vnspn** » Fri Mar 09, 2007 9:21 am

Thanks for all your comments. I was able to solve it.

I gave the Demiliter to be a 'tab' and the Quote character to be nothing. I got the output as needed; as each column written in each cell.

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 9:26 am

Still wondering why comma didn't worked for you.