I have an xcel file that based upon Cells defined will be used to create an output file with a .txt extension. All of the columns in xcel file are defined as "TEXT". The key to building the output file is based upon the xcel file definition.
Xcel file example:
A B C D E F
1 col1 col2 col3 col4 col5 col6
2 1/1 1/2 1/3 1/4 2/1 3/1
3 xbx 530 115 x - yes
4 abc 630 215 x - yes
The powershell script needs to read Row-2 of the xcel file and the column\row(1/1-example) will be the driver to build the output file.
Sample text file output.
"xbx" "530" "115" "x"
"abc" "630" "215" "x"
The first row the "@@batchload" will be a static value. The ppvpmt.p would be dynamic and maybe ask for user input to build this part of the data..
The next rows are built from row 2 of the xcel file 1/1 --> row\position .. reads row 2 of the xls file and assigns values.
After all xcel data rows have been built there is a static data row built @@end.
The first value is the row in text file and the second value is the position. If you have a 1/2 that's row 1 and the second data value in output file. The can be 1 to thousands of records in the Xcel file.
Any help in getting this built would be much apricated.