Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
hldr
483 Views, 5 Replies

Export value to multiple cells in excel

Hi, 

 

I'm currently working on a rule which exports the bom to an excel. I need to add an additional column which adds the name of the main assembly to each row, as shown in the attached image. 

 

I currently have something like this: 

'Add additional data to macro excel
GoExcel.CellValue("C:\User\Desktop\" & test & ".xlsm", "Parts List", "K1") = "Mainassy"
GoExcel.CellValue("C:\User\Desktop\" & test & ".xlsm", "Parts List", "L1") = "assembly1"
GoExcel.CellValue("C:\User\Desktop\" & test & ".xlsm", "Parts List", "M1") = "Amount"
GoExcel.CellValue("C:\User\Desktop\" & test & ".xlsm", "Parts List", "N1") = "1"

 But i need something that will add the text to all cells in a column instead of just one. 

Does anyone know if there is a possibility to do this?