| Newhavensoft forum »Newhavensoft.net forums » Odds Wizard » Updating from Excel file |
| 1. Theuth - 15 November, 2007 - 15:07:33 |
| Hi Alex, How do I import results from a Excel spreadsheet into the new version of OW? In a previous forum post you describe a method, which I found very useful, to do this in the last version of OW. Is this method of updating still valid? Are there extra columns in the spreadsheet to cope with the half time scores and kick-off time? Could you give a step-by-step guide again please. |
| 2. Alex - 17 November, 2007 - 17:07:54 |
| Columns on the Excel worksheet must contain the same headers as the games table does (Date, Time, Home team, Away team, G1, G2, HT, Rem). Otherwise the program tries to determine columns automatically. At least 3 columns must be present: Date, Home team, and Away team. Columns Date, Time must contain data in date/time format, not just text. There may be more than one worksheet in a file. Results are updated only from the default worksheet, i.e. from the worksheet which is active when you open Excel file. Updating process is the same as with LEA or HTM/HTML files: use menu item Games -> Update from file (or shortcut keys |