I am using the different formats in from the Java tool so that you can write rpg reports that go directly to Excel reports. I want to create a cell style for that of all the different fime formats.
// Create a cell style for dates. Dates in Excel
// are numbers that are formatted in a particular
Dates = HSSFWorkbook_createCellStyle(book);
DataFmt = HSSFWorkbook_createDataFormat(book);
TempStr = new_String('m/d/yy');
DateFmt = HSSFDataFormat_getFormat(DataFmt: TempStr);
Can you do the same thing as they do with the dates to create a new format for time but I also want to create a *USA format does anyone know how to do that.
TimeUSA = HSSFWorkbook_createCellStyle(book);
DataFmt = HSSFWorkbook_createDataFormat(book;
TempStr = new_String('00:00:00);
TimeFmt = HSSFDATAFormat_getFormat(DataFmt: TempStr);
HssfCellStyle_setDataFormat(TimeUSA : TimeFmt);
But how to you account for the am-pm part?