Page 1 of 1

Reading .csv file into GW Basic

Posted: Wed Sep 09, 2015 8:52 pm
by johnnyb59
I have a long list of x,y coordinates in an excel file in column A and Column B. I have a program I wrote in GW Basic that checks some conditions of an x, y point. Currently, I input the x, and y manually. What I would like to do is read into GW basic one point after another from the excel (.csv) file, work with that point in my program, output the answer to a new or the existing file .csv file and then go to the next point, etc. Any advise? I'm figuring it will involve a OPEN, input#, etc. commands, but I can't get them right.
Thanks in advance.
JohnnyB

Re: Reading .csv file into GW Basic

Posted: Sun Mar 06, 2016 10:09 pm
by Cobramil
You could drag the mouse to the desired Excel columns and copy, and then open the "EDIT.COM" and paste, and "Save" with any other name. The data will enter the EDIT.COM tabulated with the same formatting of Excel.
After that, your GWBasic program could open it and change it in their own way.
However, would not be possible to return the changes back to Excel through GWBasic programming line.