2. PHPRunner General questions
  3. xlsx Imports Blank Line
This topic is locked

xlsx Imports Blank Line

 		2/7/2021 05:49:52
PHPRunner General questions
G
 gluckett author

Hi, in PHPRUNNER 10.5 the import tool using xlsx file, with headings brings in an extra row.
For example if I have 2 rows (1 headers and 1 data) it imports 2 rows, one completely blank.
If I export the xlsx to a CSV file, the 1 headers and 1 row imports correctly.
I have scanned the xlsx for any data or non-blanks and it has none.
Any tips?
C
 		charlesfolder 2/7/2021

in before import, if field is blank skip the row
mbintex 2/9/2021

I would contact support directly and show them your solution and Excel file. Perhaps there is a bug somewhere.
G
 		gluckett author 2/11/2021



in before import, if field is blank skip the row


Do you mean in the Events? Check if the row contains data and skip importing that row?

This must happen a lot, I wonder if there are any examples?