CSV to Excel in using ProcessFlow

I am replacing a manual process that extracta data and then they convert to Excel. Using the import in Excel will preserve the leading zeros.

However in IPA, after saving the SQL Node result to CSV, opening in Excel will remove the leading zeros (double click the CSV file). One way I can preserve is to make the column 00123 to ="00123". Excel will treat this as text, hence shows with leading zeros.

Anyone done something different?

Thanks

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

unknown

I use Perl to create an Excel file from a csv file. Here is a link to check out. You may have to download and install the package.

metacpan.org/.../Excel::Writer::XLSX

unknown

Jim, I have never worked with Perl and this is intriguing. Can you explain a bit more with respects to IPA? How would you put this into IPA? THANKS!!!

unknown

To test: I would RDP to the Landmark server and run the perl script in the command prompt. If all is well, then use the Sys Cmd node in IPA.

john-miller

I use an Excel File with VBA Macros to create a new file, import a CSV and preserve formatting, then save off the Excel file to where ever. After the CSV is created you can call the Macro Excel file using a batch file and a sys command. (You may also skip the batch file and just use the sys command, we wanted a bit of freedom with the call and not update the Workflow everytime a minor tweak was needed.)

unknown

I have never worked with VBA so that is why I chose Perl, but VBA might be a better option. I use a syscmd node to execute the script which is located in %GENDIR%/bin on our LSF server. You can execute it directly with the command perl %GENDIR%/bin/script.pl or you could use a bat file. If you want to do any processing of the file with IPA such as attach to an email or move it to another directory you will most likely have to share that directory. We are a Windows shop so not sure how it works in Unix. I believe I also had to install a couple of Perl packages for this to work.

unknown

I've seen a lot of companies have security issues using VBA and VBA is obselete by microsoft. I would use a perl module such as SpreadSheet::XLSX

Copyright © 2025 Infor. All rights reserved.