exporting text file to excel to plot a graph using 'C' program_问答_开发者

exporting text file to excel to plot a graph using 'C' program

开发者 https://www.devze.com 2023-01-17 08:22 出处：网络

I am storing samples using a text file in my C program. I want to plot a waveform using those values in ex开发者_开发百科cel. How can I export data to excel from program???How can I do that??? otherwi

相关专题：c excel

Thanks in advance...

Since you seem to be open to alternatives, may I suggest Gnuplot. It's a very flexible plotting software that can be easily controlled via pipes. If all you want is to plot some graphs, it's likely much easier to use than the behemoth that is Excel.

Controlling Gnuplot from your own software involves starting it up as a new process and feeding commands into stdin. It has a built-in help function for the commands, and extensive documentation available on the site I linked to. In order to plot some data generated by your program, you could feed it something like this:

set term x11 persist
plot '-' using 1:2 with lines
1 2
2 3
3 2.5
5 1
e

This example is for Linux, and shows the plot in a new window that persists after the controlling program has exited, which is handy if you just want to look at the graph. The set term line can be changed to adapt for other platforms, or to have it save the output into a file instead (there are many output formats, including PNG and SVG).

Here's an example graph I just created by using

set term png
set output "a-graph.png"

and then running the above plot command.

exporting text file to excel to plot a graph using 'C' program

There is a way if you save an HTML file with a table with the XLS extension, Excel will open it. Then you can make your graph using the data.

Basically, save a file with

<html>
<body>
  <table>
    <tr>
      <td>Cell</td>
      <td>Cell</td>
      <td>Cell</td>
    </tr>
    <tr>
     <td>Cell</td>
     <td>Cell</td>
     <td>Cell</td>
    </tr>
 </table>
</body>
</html>

Most plot programs (including gnuplot and excel, I think) are able to read simple formats that have all values for a point on one line and that separates these by commas or tab-characters. A simple printf format for a point could look like this: