Collection to Excel
- Thread starter Patnaik14
- Start date
RavitejaKiran
New Member
Hi Patnaik,
There is an action in MS Excel VBO called "Write collection" to write the data into excel from a collection which contains inputs like
Handle: the reference you are using for that particular excel.
Workbook name: the workbook to store the data.
Worksheet name: the worksheet name in the workbook to store the data.
Collection: pass the collection which you want to send to excel.
Cell reference: From which cell you want to start writing the data.
Include column names: whether you want to write along with the column name or not. this is a boolean value.
Hope its clear.
There is an action in MS Excel VBO called "Write collection" to write the data into excel from a collection which contains inputs like
Handle: the reference you are using for that particular excel.
Workbook name: the workbook to store the data.
Worksheet name: the worksheet name in the workbook to store the data.
Collection: pass the collection which you want to send to excel.
Cell reference: From which cell you want to start writing the data.
Include column names: whether you want to write along with the column name or not. this is a boolean value.
Hope its clear.
Sukesh Kumaru
Active Member
Hello,
By using "MS Excel VBO" action as "Write Collection" you can write the entire data present inside the Collection to an Excel file.
for this you have to provide few inputs like handle number, Collection name, Workbook Name, Worksheet Name, Cell Reference, Include Column Names.
Good Luck.
By using "MS Excel VBO" action as "Write Collection" you can write the entire data present inside the Collection to an Excel file.
for this you have to provide few inputs like handle number, Collection name, Workbook Name, Worksheet Name, Cell Reference, Include Column Names.
Good Luck.
Sukesh Kumaru
Active Member
Oh yes,
You can,
Use a calc stage and write required expression and store the result in a Data Item,
specify this data item name in Worknook name in action.
Good Luck.
You can,
Use a calc stage and write required expression and store the result in a Data Item,
specify this data item name in Worknook name in action.
Good Luck.