Reading excel spreadsheet past last row

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
1 post Page 1 of 1

ehersh

Posts: 56
Joined: Mon Sep 26, 2016 12:50 pm

Post by ehersh » Mon Apr 24, 2017 7:51 am
I am reading an excel spreadsheet then I need to use the data. The spreadsheet has 113 rows. However I have a count rowset in it and the counts gives me 167 rows. When I set up a loop with a print it shows me the value of the column I am trying to use is ' '. None of the columns are blank. Any idea what could cause that or how to fix it? I have the code below to read excel below. I cannot put read maximum rows in because the spreadsheet could grow or shrink so have to treat the number of rows as a variable. .

[code
<readExcel inputFile="resource:smb://customer_Groups_/Test_Files/test.xlsx" outputRowSetVariable="newrow" skipInvalidRecords="true" skipEmptyRows="true" dataStartRowNumber="2" headingsRowNumber="1" processedInputFilesVariable="rowdata" version="2.0">
<data>
<column index="3" name="payee" />
</data>
</readExcel>


<countRowSet rowsetVariable="${newrow}" rowCountVariable="rows" columnCountVariable="columns" version="1.0" />

][/code]
1 post Page 1 of 1