How to write data in columns of xls file

[nitin2003]

Hi,

How can I write my final result in an excel file?
e.g. if I scraped 10 fields from a site, now I want to save these 10 fields as 1 column each in an excel file so that my excel file will have multiple rows with 10 columns?

I tried by writing it to a table and then writing that table to a file but I am stuck at the point where I add a line into a table. What separator do I have to give to make it write in multiple columns?

Thanks
Nitin

 

[rostonix]

Standard separator for excel tables should be {-String.Tab-}

 

[nitin2003]

I think I am making an error here. Whenever I try to write to excel, it doesn't write anything.
I create a 'Write to file' task and wrote {-Variable.Url-}{-String.Tab-}{-Variable.Category-}
But, it didn't write anything in excel. Excel file shows size as 435kb but when I open it, it gives me an error.

Can someone help me with a demo for the same?

Thanks in advance.

 

[bigcajones]

View attachment NitinTable.xmlz

 

[nitin2003]

Thanks bigcajones.
Actually, I tried this way too and when I write the table content using Table processing task in a file. File size increases but there is no data in the file.
Not sure, what exactly is wrong with my file writing. it works fine in .txt files.

Thanks

View attachment 3912

 

[nitin2003]

Ok. now it worked but only with xls file and not xlsx files. so, I believe my format for xlsx file wasn't correct.

 

[bigcajones]

This should work for xlsx also. If you have problems with it, try using an actual tab from the keyboard in between the variables instead of {-String.Tab-}. I almost always do it that way anyways when working with excel tables.

 

[amul]

I was just looking into this...

Clint, you rock!