Hi Scott, thanks for your help!
I found my mistake, the cell format was wrong. Thanks again!
Search found 3 matches
- Thu Sep 30, 2021 8:33 am
- Forum: HSSFR4
- Topic: How to update an exsting cell in an .xlsm file?
- Replies: 4
- Views: 19270
- Wed Sep 29, 2021 3:13 pm
- Forum: HSSFR4
- Topic: How to update an exsting cell in an .xlsm file?
- Replies: 4
- Views: 19270
Re: How to update an exsting cell in an .xlsm file?
Thanks Scott, but the result also with your advices is the same. My cell variable is filled with an Integer, so I think the procedure found the cell. But when I open the file after saving it, this cell is empty. Do you have any other suggestions as to what it could be? Should I use a .xlsx instead o...
- Wed Sep 29, 2021 2:13 pm
- Forum: HSSFR4
- Topic: How to update an exsting cell in an .xlsm file?
- Replies: 4
- Views: 19270
How to update an exsting cell in an .xlsm file?
Hi, I want to update an existing cell in an Excel file (test.xlsm). So I don't want to create a new cell in this file. I want to update cell D4. Here's my code: 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 cc...