So I don't want to create a new cell in this file.
I want to update cell D4.
Here's my code:
Code: Select all
D book s like(SSWorkbook) D sheet s like(SSSheet) D row s like(SSRow) D cell s like(SSCell) D TempStr s like(jString) D StrVal s 8000C D ccsid(13488) book = ss_open(path); sheet = ss_getSheet(book: 0); row = SSSheet_getRow(sheet: 3); cell = SSRow_getCell(row: 3); StrVal = 'testcell'; TempStr = new_String(%trim(StrVal)); SSCell_setCellValueStr(cell: TempStr); SS_save(book:path);
But after saving the file, the content of the cell is still blank. I set the cell type in the file to "String".
Am I missing something that I still have to set or where can be the error here?
Thanks for your help!