A couple more questions come to mind.

1. Are the added lines at the start or at the end? I suppose it's obvious to others, but it isn't to me.

2. Does the OP get the extra lines if specifying to start at row 1? This would suggest what you are, Rob, that there are rows with "content" below what looks like data - this is possible, the lowest-right corner seems to be the one where the cell was active when the workbook was saved - something like that, I never have quite grokked what Excel does here.

3. If OP doesn't get extra lines when specifying from row 1, then it suggests that the active range size is used to determine the size of the target.

Cheers
Vern

On 1/28/2020 11:30 AM, Rob Berendt wrote:
What defines the end of the file in Excel?
Is it the first row which has no data in any columns?
Is it the selected area? For example, if you do Print Selection.

I would make sure you select just the rows you want transferred.
If that doesn't do it I would remove at least 3 rows from the end. Maybe one of those rows had a value at some time and the value was deleted but not cleared.

Rob Berendt
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com -----Original Message----- From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of mlazarus Sent: Tuesday, January 28, 2020 10:14 AM To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx> Subject: Extra blank lines in ACS file transfer to Excel CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. When I do a file transfer in ACS from the "active Excel sheet", if I tell it to transfer starting from row 4, for example, the transfer creates an extra 3 blank lines in the target file. Is there a fix for this? This is in version: 1.1.8.3 of ACS (2019-12-02), so it's not very old. -mark -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact support@xxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com
-- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact support@xxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.