Darth_Raven_CZ
New Member
- Joined
- Jan 7, 2015
- Messages
- 1
I am going to get a bunch of data exports from various systems and most of them will be in Excel file (xls as well as xlsx). I am looking how to detect Encoding of the file via any way, possibly even VBA macro or anything, but automated way (i.e. not converting to csv/txt file). Is there a possibility to write a macro for that?
in worst case scenario - I can somehow manually check xlsx files meta-information in XML. However, I don't see any such possibility for older excel files and that is where I am lost.
Maybe there is easier way that does not use VBA, but I could not find it. Most of similar topics/threads are about "saving" in specific encoding or "creating CSV". I just want to detect, what encoding is used. Can anyone help me?
If it helps, I would be ok with not detection, but checking if file uses UTF-8, so in ideal way, I would know the encoding, in worse case I would be ok with just YES/NO if it uses UTF.
in worst case scenario - I can somehow manually check xlsx files meta-information in XML. However, I don't see any such possibility for older excel files and that is where I am lost.
Maybe there is easier way that does not use VBA, but I could not find it. Most of similar topics/threads are about "saving" in specific encoding or "creating CSV". I just want to detect, what encoding is used. Can anyone help me?
If it helps, I would be ok with not detection, but checking if file uses UTF-8, so in ideal way, I would know the encoding, in worse case I would be ok with just YES/NO if it uses UTF.
