Jan 26 2021 03:30 PM
Hi
I have an Excel sheet that will have inputs and outputs from/to a PLC. The PLC can read and write from/to a CSV file that is text-formatted, not in spread sheet format. The PLC does not have MS Office on it.
I was wondering if there is a simple way that can achieve the above goal.
Thank you.
Jan 27 2021 06:06 PM
@Pipan You can utilize PowerQuery to control the import of the text file to excel
Jan 28 2021 10:06 AM - edited Jan 28 2021 10:06 AM
Jan 28 2021 11:14 AM
@Pipan PowerQuery wouldn't be able to do that, but a Save As of the file to a .txt format should work