I've created a Workflow AutoStart from Email project to monitor an inbox. The email sent to the email inbox contains a .ZIP attachment of a .CSV file. I've figured out how to extract the file without a problem. Where I'm running into an issue is how to take the .CSV file and then convert it to a .XLSX file. Anyone have an idea on the best way to go about this?
Thanks
I don't think the current WF components are able to write an XLSX file, they are only capable of the older XLS format.
I think you can probably use some thing like this:
http://www.softinterface.com/Convert-XLS/Features/Convert-CSV-To-XLSX.htm
It has a command line, but I have never used this product, so no endorsement! just a suggestion.
Rob
Because XLSX is just a zipped pack of XML files I think it should be possible to prepare a template XLSX file, then create own component XML file filled with data using NVelocity and just replace it in template.
The Excel Write component can create an XLSX file. I tested that yesterday quite a few times when trying to get the CSV file info to write into it. I could write the file and save it locally to my workstation. The only problem I run into is getting the data into the XLSX file in the proper format as it appears when I pull up the CSV file in Excel.
That solution worked great! I wrapped it up in an ExecuteProcessComponent and it worked like a charm! :)