Search results for query: *

I am trying to run a loop which ends after it satisfies the If for the first time. I read that you are supposed to use the last command, similar to Break in C#. Can someone perhaps explain why the last is being ignored in this code, and where it should go. THanks! for (my $i=0; $i < $#UndlyPx...

I am trying to write a script which will take the users input, and then look to match that input in a specific column. THen once that input is found in the column, I want the script to print the values of two different cells in that row. For example, if the data is in cell C4, I want the script...

Hey, I have 3 xml files which I need to convert to csv files. I must use XSLT to do this, and apparently accessing xalan from my command prompt is a helpful way to do this. If anyone can please give me some advice / code to point me in the right direction it would be most helpful. Thanks!

In one of my old perl scripts, I pull data from a database, and then load that data into excell. Now, I need to load basically the same info-- all of the columns are the same, however the data in 1 of the columns is different, thus changing the data on the other 3 columns. Essentially, I need...

Hey, I'm trying to get a perl script working which would essentially go down a specific column in my spreadsheet (column D) and, baside on whether the text in the cell is "A" or "B," do something. If the text in the cell is "a" I want to remove the ENTIRE rown from the sheet, and add it to a...

I wrote a perl file which opens up a CSV file and removes the first row of the file, and the last column of the file. What I need to somehow do is save the text from the first row of the file (which I then remove), so as to add it to the top of another sheet in the same workbook. Any ideas...

Hey, I need to be able to export a spreadsheet as an htm file (which I have already done) and then using perl code have it automatically e-mailed, and placed into the body as html. Essentially, I need my code to attach the entire file (which I have already accomplished), and then have this one...

I am currently trying to create a batch file which executes several different perl scripts. The last perl script which I need to create will be executed by the batch file, and will automatically attach and e-mail the new "recon.xls" file. I know that I need to use the Mime::Lite & Net::SMTP...

Hey, I have written a rather long macro for excel which will daily bring in our recon file and then use it to refresh several pivot tables. My macro automatically runs through a perl script, however once the refresh begins in excel, I must manually select the files. I was wondering if there is...

I'm having some trouble using perl to write to excel csv files. Does anyone have any idea how to write a perl script which will remove columns in excel and/or text? please help!