Harbour-J

Date & Datetime Style Formats

1

The program below highlights a couple of issues with Datetime formatting. 1. Custom datetime format don't seem to work. 2. Several of the CELL_FORMAT_DATE... entries in VFPxWorkbookXLSX.h don't seem to...

Xlsx file is invalid if first row is not text

15

... loXL.SetCellValue(lnWb, lnSheet, 1, 1, 'Header') loXL.SetCellValue(lnWb, lnSheet, 2, 1, 2) ... works fine to create a 2-cell spreadsheet. ... loXL.SetCellValue(lnWb, lnSheet, 1, 1, 1) loXL.SetCellValue(lnWb, lnSheet, 2, 1, 2)...