Add custom property to 97/2003 MSOffice Files (xls/doc/ppt) using DSOFile 2.1

Question

I'm trying to add custom property on the ppt file. But Received value("güsiöçÇÖISÜG") is not equal sent value("ğüşiöçÇÖİŞÜĞ").

I faced a strange situation like that:

Open the sample.ppt by LibreOffice.
Save (CTRL+S) and Close, any change is not necessarily.
Run the code again.
And two values are equal

Sample ppt files is here: https://drive.google.com/drive/folders/1qTlREuLAAM-I0JIn-htPwLEUwRjQ9IiJ?usp=sharing

Is there anyone to help me, thanks.

See https://stackoverflow.com/questions/6900474/set-windows-file-properties-of-non-office-files — Eugene Astafiev, Feb 11 '22 at 23:32
Hi @EugeneAstafiev thanks for the answer but I can't understand cleary... Is this encoding inconsistentcy about DSOFile or NTFS or DOC(2005) ? Some characters are allowed ( üöçÜÖÇ ) and some characters are not allowed ( ğşıĞŞİ ). Should I change somewhere of code, if yes, where is ? — sergenbag01, Feb 14 '22 at 05:48
You did not. But the software you use could do that for you. — Eugene Astafiev, Feb 14 '22 at 10:10

score 0 · Answer 1 · answered Feb 14 '22 at 10:11

You need to check encodings of your Excel files. Most probably a software (DSO) generates a UTF-8 based document instead of UTF-16. For example, you may try using the following code:

Dim strEncodingName As String = String.Empty
Dim myStreamRdr As System.IO.StreamReader = New System.IO.StreamReader(myFileName, True)
Dim myString As String = myStreamRdr.ReadToEnd()
strEncodingName = mmFileIA.CurrentEncoding.EncodingName

Add custom property to 97/2003 MSOffice Files (xls/doc/ppt) using DSOFile 2.1

1 Answers1