How can I use a script to modify an Excel spreadsheet?
Posted on 2014-10-30
I have an Excel spreadsheet which I would like to modify.
Actions I want to have done to the spreadsheet using a script.
If data exists in Column A1 and if the quantity shown in Column S1 is 0, then delete the whole line. If S1 has nothing in it, then do not delete the line, only if it has a 0 in that field.
This has to continue for all columns it finds data for in the A column and down for the entire spreadsheet.
Then, after it does this, I would like to automatically delete the following columns: B-R, and T-Z.