Posts

Showing posts from July, 2022

Convert Single or Multiple CSV To Excel (Xlsx)

Image
There are a requirement needed to extract source text and currently translated text into a sheet and let third party to do translation. So this task is assigned to my team intern (Adrain) and under my guidance. So when I first received this task, I already think of a general automation way to extract the info via using python library (Beautiful soup). I have once using that library for my web scraping project so that I assume it will work on the xml tag file as well.  Therefore, what I proposed to my intern is to using that and extract the source text into a csv with delimiter, so that it will categorize it nicely when we use excel or other applications. I suggest he to break the source text by context name makes them into separate spreadsheet in a workbook. And today, my team lead tell me since using excel already what not also extract other languages make them together with different column? After some discussion I only realize l