Hi
I have a range in Excel i would like to save as CSV file in C:\test\
with filename: PROD + date and time (Format DD-MM-YYYY HH MM)
C:\test\PROD 22-09-2021 12 00.CSV
Besides the three column in my sheet i would like to add a 4. column with a fixed text like "LAG"
Ressult should be like this:
Column 1;Column 2;Column 3;Column 4
podr 12;1;Hat 63;LAG
podr 13;2;Hat 69;LAG
podr 14;3;Hat 75;LAG
podr 15;4;Hat 81;LAG
podr 16;5;Hat 87;LAG
podr 17;6;Hat 93;LAG
podr 18;7;Hat 99;LAG
podr 19;8;Hat 105;LAG
podr 20;9;Hat 111;LAG
I have a range in Excel i would like to save as CSV file in C:\test\
with filename: PROD + date and time (Format DD-MM-YYYY HH MM)
C:\test\PROD 22-09-2021 12 00.CSV
Besides the three column in my sheet i would like to add a 4. column with a fixed text like "LAG"
Mappe2 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Column 1 | Column 2 | Column 3 | ||
2 | podr 12 | 1 | Hat 63 | ||
3 | podr 13 | 2 | Hat 69 | ||
4 | podr 14 | 3 | Hat 75 | ||
5 | podr 15 | 4 | Hat 81 | ||
6 | podr 16 | 5 | Hat 87 | ||
7 | podr 17 | 6 | Hat 93 | ||
8 | podr 18 | 7 | Hat 99 | ||
9 | podr 19 | 8 | Hat 105 | ||
10 | podr 20 | 9 | Hat 111 | ||
Ark1 |
Ressult should be like this:
Column 1;Column 2;Column 3;Column 4
podr 12;1;Hat 63;LAG
podr 13;2;Hat 69;LAG
podr 14;3;Hat 75;LAG
podr 15;4;Hat 81;LAG
podr 16;5;Hat 87;LAG
podr 17;6;Hat 93;LAG
podr 18;7;Hat 99;LAG
podr 19;8;Hat 105;LAG
podr 20;9;Hat 111;LAG