shift column by 1 for a specific row in excel using perl

vishal0620 has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: shift column by 1 for a specific row in excel using perl by runrig (Abbot) on Aug 28, 2013 at 19:06 UTC
Show some small amount of code that attempts to show what you are talking about and what you are trying to do. Perl has a shift function, but that does not seem to be what you are looking for (or maybe it is?).	[reply]
Re: shift column by 1 for a specific row in excel using perl by hdb (Monsignor) on Aug 29, 2013 at 08:50 UTC
Assuming your row of interest is stored in an array `@row`, then `shift @row;` [download] would remove the first element, ie shift your data by one column to the left, and `unshift @row, "";` [download] would add an element at the beginning of the array, ie shift your data by one column to the right. . You would still need to write the data back into your spreadsheet, I guess, which depends on which modules you are using. Without some of your code this can't be discussed in a meaningful way.	[reply] [d/l] [select]