Share
Report
34When I set an Action to 'Write to Excel worksheet' using dynamic column names PAD overwrites the entire row to the end of the maximum number of columns allowed by Excel. When I use a fixed column name the command works. I need to use dynamic column names since the name stays the same from spreadsheet to spreadsheet but the column changes, for example: instead of a column I need being 'AW' it might be column 'AT' in another file. I DO NOT get syntax errors or anything else just the complete overwrite of a row.
DYNAMIC COLUMN NAME:
FIXED COLUMN NAME
WHAT IT LOOKS LIKE IN THE SPREADSHEET
What is truly weird is I can use dynamic names to grab data from an Excel spreadsheet without any issue.
Categories:
I have the same question (0)
All responses (
Answers (
