Forum Discussion

Copper Contributor

Oct 16, 2020

Solved

Tiny Life Plaguing Boxes

Hello to anyone out there reading this. I ran into a peculiar issue this morning while testing some Microsoft Word to Excel transfer scripting I had started the other day. For some reason Microso...

excel

Osten24
Oct 16, 2020
Osten24
Discovered the fix for the issue. It seems as if this was more an issue between communications with my c# scripting and word, rather excel. Excel I am sorry for questioning your abilities. He just can't read asciii symbols and apparently expresses them as boxes. I simply added the below code if anyone was ever encountering this issue when using Microsoft.Office.Interop interactions.

text = text.Substring(0, text.Length - 2);

Simply removed the last two extra characters. I'd rather a better solution but this should get me through development.

Osten24

Copper Contributor

Oct 16, 2020

Osten24

Discovered the fix for the issue. It seems as if this was more an issue between communications with my c# scripting and word, rather excel. Excel I am sorry for questioning your abilities. He just can't read asciii symbols and apparently expresses them as boxes. I simply added the below code if anyone was ever encountering this issue when using Microsoft.Office.Interop interactions.

text = text.Substring(0, text.Length - 2);

Simply removed the last two extra characters. I'd rather a better solution but this should get me through development.