topic RE: .xlsx to .txt in Product Forum

.xlsx to .txt

sivaranjani_96 — Fri, 24 Dec 2021 09:26:00 GMT

Hi All,
I have scenario where my excel has to be saved as a txt when i do this my notepad is having korean/chinese kind of language in it instead of the original one, Is there any way to resolve this issue please help me with this.

------------------------------
sivaranjani singaravel
Assistance Software Engineer
accenture
Asia/Kolkata
------------------------------

RE: .xlsx to .txt

shashank.kumar280 — Fri, 24 Dec 2021 10:53:00 GMT

Hi Sivaranjani ,

You could save the excel as a csv and then it can be viewed in notepad. What kind of data do you have in excel? Any particular reason for saving it as txt?

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: .xlsx to .txt

devneetmohanty07 — Fri, 24 Dec 2021 16:29:00 GMT

Hi Sivaranjani,

Going through your post it looks like that the excel file is either not being read properly or there is some issue while writing the data. In order to properly write the excel contents into a text file, I can suggest you two approaches.

Please find the attached document and let me know in case of any queries

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Automation Consultant
Blueprism 6x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------