C++ and Excel
-
Hi, I have extremly large Excel file, where each of columns present one proces measurement. I can not find simple and useful way to read every column and transform that into *.dat file to prepare for MATLAB. Help is realy nedded D.J.
Or at least... unix command-line tools, such as sed, awk, grep, cut, etc. I would simply export the file as CSV, and then do some simple text processing on it. I recommed you install mingw or cygwin for a quick way to get those tools. You can also get it done with macros in a decent text editor, I suppose. -- Nitzan
-
Or at least... unix command-line tools, such as sed, awk, grep, cut, etc. I would simply export the file as CSV, and then do some simple text processing on it. I recommed you install mingw or cygwin for a quick way to get those tools. You can also get it done with macros in a decent text editor, I suppose. -- Nitzan
-
...unfortunately I am in Windows environment completelty and I should be in that one all the time, security rezons...thanks anyway pozdrav
Maybe I wasn't clear enough: you can install a small subset of the command-line utilities on Windows. They're great for everyday tasks. I recommed you go look at mingw: minimal GNU for Windows. Still, if you don't want to for some reason, my suggestion still holds: export as CSV, and use a macro of some sort in a text editor to format for MATLAB. -- Nitzan
-
...unfortunately I am in Windows environment completelty and I should be in that one all the time, security rezons...thanks anyway pozdrav
There is a windows version of awk. And I think, that sed and grep exist for windows too, try google. Robert-Antonio "I launched Norton Commander and saw, drive C: on the left, drive C: on the right...Damn, why I need two drives C:??? So I formatted one..."
-
Maybe I wasn't clear enough: you can install a small subset of the command-line utilities on Windows. They're great for everyday tasks. I recommed you go look at mingw: minimal GNU for Windows. Still, if you don't want to for some reason, my suggestion still holds: export as CSV, and use a macro of some sort in a text editor to format for MATLAB. -- Nitzan
-
You need MinGW Runtime, MinGW Utilities, MinGW, and get binutils too 'cause its useful. There is another post in this thread which is also correct: I suppose you can simply google for "windows awk" or "windows sed" to get just these. -- Nitzan
-
Hi, I have extremly large Excel file, where each of columns present one proces measurement. I can not find simple and useful way to read every column and transform that into *.dat file to prepare for MATLAB. Help is realy nedded D.J.