Jan 24, 2011 at 8:56 PM
Edited Jan 24, 2011 at 8:58 PM
How can we maintain the order/sequence of the submitted data?
Excel stores each cell by its coordinates: column and row... e.g. A3, which is column A in row 3; or CF271, which is column CF in row 271. Rows are numbered from 1 to 65536 (for xls files up to Excel 2003) or 1048576 (for xlsx files Excel 2007 and above).
Columns are identified by the letters A through Z, followed by AA through AZ, BA through BZ, up to IV (for xls files up to Excel 2003) or XFD (for xlsx files Excel 2007 and above). So does PHPExcel.
However, your sample spreadsheet seems to confuse rows and columns.
We need the output to match row-by-row order above
I'm not sure exactly what you mean by "going in" and "extracted", but is there any reason why you think that PHPExcel might not follow the same cell addressing sequence as Excel itself? The PHPExcel Writers write out each row in
turn, and each column within that row in turn. When a program that can read Excel files (such as MS Excel, Open Office Calc, or Gnumeric) reads a file generated by PHPExcel, it will ensure that the cells are displayed in the appropriate rows and columns.
Is there any code that can make sure that the order of the rows is the same going in as when extracted?
If you're unsure, you can try for yourself.
Alternatively, one of the benefits of Open Source is that you can always see how it works by examining the source code.