Re: Extra blank lines in ACS file transfer to Excel

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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