scottklement.com

I finally set the ccsid to what the machine has as a sysval and now no more lex errors. It does indicate it open then the file name and : Conversion error. Not sure where to look. CCSID is set to 65533. I think I am very close to making this work. I did not want to use data-into as the json is huge ...

I don't see a shortcut in the Klement tools to make a row be hidden.

Found it. Had to XSSF on the prototype for the protect sheet.

I have a program that was writing xls. I changed it to use the new HSSFR4 in order to handled xlsx. It works well, except for the Protect Sheet. Is does not want to protect the sheet. I do not see any errors. Maybe is should not be hssf any longer? D ssSheet_protectSheet... D PR ExtProc( *Java D : '...

I found the issue. After a bit of google searching I found that the original sheet cannot have any formulas in it. The source sheet I was using had 2 simple formulas in a couple of cells =b13 and =C12. With xlsx you need to have no formulas in the sheet you are going to update , or you have to set t...

Could be back when you did it, things did work. I tried opening with Excel 2013 and in Teams. Teams will open it, and prompts to "Fix It". Excel 2013 opens it and removes the formulas. I went to the web, and one place indicated I needed poi-ooxml, and I do see that jar on the system and ge...

I have code that was using hssf procedures as it was an xls (old excel). Management want the excel to now be xlsx. I used the ss_formula procedure call and it did not abend. The issue is when I go to open the xlsx it indicates something is wrong with spreadsheet. It allows me to open it and with thi...