I am trying to figure out how to create multiple files from a series of data in Excel, given a functional area specification (i.e. ABC, XYZ, etc.)...
- I have an Area column which contains functional areas for the objects (i.e. ABC, XYZ)
- I have an Object column which contains the object name (i.e. objectAlpha).
- I have a Field column which contains a field name belonging to an object (i.e. field1).
I would like to create a .txt file named after the object name with a 'template' of data. For example:
File name: objectAlpha.txt
File contents:
@startuml
object objectAlpha {
field1
field2
field4
}
@enduml
I have attached a sample input/output as well.
Sample.xlsx
Thanks!
Bookmarks