Search found 3 matches

by NicoWickersheim
Thu Sep 30, 2021 8:33 am
Forum: HSSFR4
Topic: How to update an exsting cell in an .xlsm file?
Replies: 4
Views: 14357

Re: How to update an exsting cell in an .xlsm file?

Hi Scott, thanks for your help!

I found my mistake, the cell format was wrong. Thanks again!
by NicoWickersheim
Wed Sep 29, 2021 3:13 pm
Forum: HSSFR4
Topic: How to update an exsting cell in an .xlsm file?
Replies: 4
Views: 14357

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...
by NicoWickersheim
Wed Sep 29, 2021 2:13 pm
Forum: HSSFR4
Topic: How to update an exsting cell in an .xlsm file?
Replies: 4
Views: 14357

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...