I want to rearrange the column name in the exported excel file, Can anyone please help me to rearrange these.
Below is my excel file attached and warehouse planning is the screen i am working on.
Hello @Shalini D M
I reviewed the function you're using to download the xlsx file.
Advance Excel Use this Cell write function to arrange columns according to your use case.
Regards
Nikhil kumar vijay
Warehouse code
warehouse description
part no.
norms type
Min stock
max stock
Fixed Min Quantity
Fixed Max
Staging lead time
Fixed days
Lot size
Created date
created by
Modified Date
Modified By
Sir I need to arrange the column in this order but how to do it using Advance_excel
Hello, I have found a related query that might help you.
Export to Excel Order the columns
It's possible to use this action in Advance Excel and arrange it according to your use case.
Hi, @Shalini D M, if by rearrange you mean give a different name to the column, then you can do so by changing the label of all columns in your structure.ThanksGitansh Anand
Hi @Shalini D M
You can try with advance excel forge component.
Link- https://www.outsystems.com/forge/component-overview/355/advanced-excel
If you don't want to use forge component then you can try to create a structure and assign the structure list in the export excel element and select the attribute which you want to see into the excel.
Hope this will help
Thanks
Prince
Can you please brief it
yes let me make changes into your oml.
take help from my OML. because cs module is not included in oml. you donot need to use Advance Excel.
Regards,
for var1 what is the data type you are using
the structure which i created. and you can create as you want to export.
i have created this and made var1 list of export.
ok i will try
Thank You, it worked for me
Hi Shalini,
To get some clarity, you can download the demo module of Advanced excel and look into it which will be helpful for you to understand better to write your own logic.
https://www.outsystems.com/forge/component-overview/355/advanced-excel
Wasimkhan S