Let’s say I have the following info stored in a DataTable called dt_data already.
|Copper||23. July 2020||652|
|Brass MS 58||23. July 2020||514|
|MP 58||23. July 2020||505|
|Brass MS 63/37||23. July 2020||545|
How to I pass these values into an Excel file so that the result will look like this below?
metal 2020 .xlsx (57.8 KB)
It needs to find the right excel tab (July 2020 in this case), the right column, and the right date.
We can use a fixed column position for each item since Copper will always be in column B, Brass MS 58 in column D, MP 58 in column E, and Brass MS 63/37 in column F.
How do I achieve this without changing the excel format?