Convert csv to excel preserving columns
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
5 posts
Page 1 of 1
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
Read the CSV file and create a Rowset Variable ... just as if you read from DB Table, etc.
Use the Rowset Variable as the Input Rowset Variable into writing the Excel Spreadsheet.
Write the Excel Spreadsheet by defining the columns... as an example:
Use the Rowset Variable as the Input Rowset Variable into writing the Excel Spreadsheet.
Write the Excel Spreadsheet by defining the columns... as an example:
Code: Select all
<writeExcel label="Write Billable Projects" inputRowSetVariable="${Projects}" outputFile="${FileName}" whenFileExists="overwrite" excelFormat="excel2007" includeHeadings="true" outputFileVariable="excelFile" version="2.0">
<data startRowNumber="2">
<column index="1" name="F1" />
<column index="2" name="F2" />
<column index="3" name="F3" />
<column index="4" name="F4" />
<column index="5" name="F5" />
<column index="6" name="F6" type="DECIMAL" pattern="#,###,###.00" fontColor="Red" />
<column index="7" name="F7" />
<column index="8" name="F8" />
</data>
</writeExcel>
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
I'm not sure I understand your question...
Can GoAnywhere convert data from XML -> Excel or CSV -> Fixed Width or Database -> XML?
Absolutely!
And you can define the parameters put into those values as needed.
Can GoAnywhere convert data from XML -> Excel or CSV -> Fixed Width or Database -> XML?
Absolutely!
And you can define the parameters put into those values as needed.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
5 posts
Page 1 of 1