How to write data in columns of xls file

nitin2003

Client
Регистрация
18.09.2012
Сообщения
195
Благодарностей
11
Баллы
18
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

Известная личность
Регистрация
23.12.2011
Сообщения
29 067
Благодарностей
5 703
Баллы
113
Standard separator for excel tables should be {-String.Tab-}
 

nitin2003

Client
Регистрация
18.09.2012
Сообщения
195
Благодарностей
11
Баллы
18
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

Client
Регистрация
09.02.2011
Сообщения
1 216
Благодарностей
681
Баллы
113
  • Спасибо
Реакции: nitin2003

nitin2003

Client
Регистрация
18.09.2012
Сообщения
195
Благодарностей
11
Баллы
18

nitin2003

Client
Регистрация
18.09.2012
Сообщения
195
Благодарностей
11
Баллы
18
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

Client
Регистрация
09.02.2011
Сообщения
1 216
Благодарностей
681
Баллы
113
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.
 
  • Спасибо
Реакции: nitin2003

amul

Client
Регистрация
02.07.2011
Сообщения
140
Благодарностей
9
Баллы
18
I was just looking into this...

Clint, you rock!
 

Кто просматривает тему: (Всего: 1, Пользователи: 0, Гости: 1)