File Transfer - Keeping Excel format?

Print Page | Close Window

Keeping Excel format?

Printed From: Rocket Software
Category: AccuTerm Knowledge Base (read only)
Forum Name: File Transfer
Forum Description: Help with uploading & downloading database and document files
URL: https://forum.asent.com/forum_posts.asp?TID=2509
Printed Date: March 26 2026 at 8:50pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: Keeping Excel format?

Posted By: TTegen
Subject: Keeping Excel format?
Date Posted: May 26 2015 at 12:46pm

I have a program that exports an Excel spreadsheet once a day. The format for numeric columns with decimals for not formatted very well. All trailing zeros after the decimal point are removed. ie. 1.250 becomes 1.25 etc. I have to format all of the numeric columns every time I export the spreadsheet.

Is there a way to either:

1. keep the correct formatting on export.

2. Keep the format of the spreadsheet. For example load the spreadsheet data into an existing formatted spreadsheet instead of overlaying the existing spreadsheet.

Any help is greatly appreciated.

-------------
Thomas Tegen

Replies:

Posted By: PSchellenbach
Date Posted: June 04 2015 at 9:25am

Hi Tom -

If you use FTD or FTEXPORT with a target file name to a workbook file that exists and is pre-formatted, include the range in the target file. For example: C:\docs\mysheet.xlsx!1!A2:G99

Thanks,

Pete