|
From: Hans-Bernhard B. <br...@ph...> - 2004-10-03 00:13:14
|
On Sat, 2 Oct 2004, ccharron1 wrote: > I'm discovering gnuplot and I'm trying to use it to do some 3D-graph > representation of data (real x, y and z graph). As my data are in an excel > sheet, it would be very usefull if gnuplot would have an option to import > directly the data from an excel file, as a command in a GUI. I don't think that'll happen. If you have data stuck in the bowels of some Excel file, it's the duty of Excel and you to get it out of there, not gnuplot's. And, luckily, it can do it: you can export the data you have to a CSV file, and gnuplot will be able to read it. > To be able to select the data file directly from the GUI, without having > to write the name in the command line windows would be nice. It is nice --- you can do it right now. If it *is* a data file, rather than some Excel blob, that is. > Are you developping a preference setting to choose the language of > Gnuplot ? No. But maybe I just didn't understand that question. What "language of gnuplot" to you want to make preference-settable there? gnuplot uses essentially only one language, and that only to write documentation in and derive keywords from. Neither of which seems to be what you're asking about. So: what kind of change do you have in mind there? -- Hans-Bernhard Broeker (br...@ph...) Even if all the snow were burnt, ashes would remain. |
|
From: Hans-Bernhard B. <br...@ph...> - 2004-10-03 15:56:31
|
On Sun, 3 Oct 2004, ccharron1 wrote: > About the language, I'm thinking Germa, French, Spanish ... Gui translation. Which of the GUIs would you want translated? We have at least two integrated in the source tree (Windows and OS/2), and a couple of external ones, most of which have fallen into disrepair though. As it is, the Windows GUI texts, e.g., come in two parts: the main menu is actually covered by the wgnuplot.mnu file, which is simple editable text. It shouldn't be too hard to change that. All the other menus (like the Windows system menu and the context menus) are generated on-the-fly, by the code, and the names used by those are currently hardwired. > You don't seem to appreciate Excel, Right. But that's not actually my main point here. That is whether it makes sense for *us* to try to parse a proprietary file format like Excel's. I think it doesn't. Ultimately only Excels knows how to parse its files, so it's Excel's responsibility to export to something usable by the rest of the world. [And please don't blindly quote full messages if you're not going to refer to their content. Just because that's Outlook's default doesn't mean it's sensible behaviour.] -- Hans-Bernhard Broeker (br...@ph...) Even if all the snow were burnt, ashes would remain. |
|
From: Andrius K. <and...@ma...> - 2004-10-04 06:35:38
|
Hello, > But that's not actually my main point here. That is whether it makes > sense for *us* to try to parse a proprietary file format like Excel's. I > think it doesn't. Ultimately only Excels knows how to parse its files, so > it's Excel's responsibility to export to something usable by the rest of > the world. well, from the times I used Excel, I remember that it has some scripting language, Excel Basic, I think. So if people want some integration of gnuplot into the Excel's GUI, it probably would be meaningful to do it with the help of some Excel script. It could even be some wizard, which allows to select the chart type and the data columns and sends that data to gnuplot. This way, the parsing of excel files would not be necessary. And a good integration with Excel's gui could be achieved. Just my 2cents. Andrius |
|
From: Joe K. <jko...@co...> - 2004-10-03 03:24:57
|
A couple of general comments. First, Excel has a very bad, inflexible plot package, and has had it for many years. I cringe when I see an Excel plot in published documents. Almost anything is better. By doing an Excel "Save As" to tab text, a gnuplot user should be able to access most Excel data with only a little editing. Second, there are some commercial plot programs that will import Excel files directly. On my Mac, I use Kaleidagraph, which is available for both Mac and PC, and is not too expensive as software goes. Kaleidagraph reformats each Excel workbook into a separate Kaleidagraph data file. This proves that it can be done. I'm sure there are others that do the same, but cost money. Joe on 10/2/04 6:12 PM, Hans-Bernhard Broeker at br...@ph... wrote: > On Sat, 2 Oct 2004, ccharron1 wrote: > >> I'm discovering gnuplot and I'm trying to use it to do some 3D-graph >> representation of data (real x, y and z graph). As my data are in an excel >> sheet, it would be very usefull if gnuplot would have an option to import >> directly the data from an excel file, as a command in a GUI. > > I don't think that'll happen. If you have data stuck in the bowels of > some Excel file, it's the duty of Excel and you to get it out of there, > not gnuplot's. And, luckily, it can do it: you can export the data you > have to a CSV file, and gnuplot will be able to read it. > >> To be able to select the data file directly from the GUI, without having >> to write the name in the command line windows would be nice. > > It is nice --- you can do it right now. If it *is* a data file, rather > than some Excel blob, that is. > >> Are you developping a preference setting to choose the language of >> Gnuplot ? > > No. But maybe I just didn't understand that question. What "language of > gnuplot" to you want to make preference-settable there? gnuplot uses > essentially only one language, and that only to write documentation in and > derive keywords from. Neither of which seems to be what you're asking > about. So: what kind of change do you have in mind there? |
|
From: ccharron1 <cch...@fr...> - 2004-10-03 14:38:50
|
Thanks for the answer, I just want to do some 3D representation of data, to try to understand some chemical reactions depending of more than 3 parameters. I looked other the internet, I found several very expensive software and I found Gnuplot, which was very interesting for me, except that I'm not working with a command line program for years now, and having to to it it's painfull when you have the habbit to use a graphical program interface system like windows or system 7 from apple. Sorry for my bad english, I'm French. ----- Original Message ----- From: "Joe Koski" <jko...@co...> To: "Hans-Bernhard Broeker" <br...@ph...>; "ccharron1" <cch...@fr...> Cc: "gnuplot" <gnu...@li...> Sent: Sunday, October 03, 2004 5:24 AM Subject: Re: [Gnuplot-info] Suggestion > A couple of general comments. > > First, Excel has a very bad, inflexible plot package, and has had it for > many years. I cringe when I see an Excel plot in published documents. Almost > anything is better. By doing an Excel "Save As" to tab text, a gnuplot user > should be able to access most Excel data with only a little editing. > > Second, there are some commercial plot programs that will import Excel files > directly. On my Mac, I use Kaleidagraph, which is available for both Mac and > PC, and is not too expensive as software goes. Kaleidagraph reformats each > Excel workbook into a separate Kaleidagraph data file. This proves that it > can be done. I'm sure there are others that do the same, but cost money. > > Joe > > > on 10/2/04 6:12 PM, Hans-Bernhard Broeker at br...@ph... > wrote: > > > On Sat, 2 Oct 2004, ccharron1 wrote: > > > >> I'm discovering gnuplot and I'm trying to use it to do some 3D-graph > >> representation of data (real x, y and z graph). As my data are in an excel > >> sheet, it would be very usefull if gnuplot would have an option to import > >> directly the data from an excel file, as a command in a GUI. > > > > I don't think that'll happen. If you have data stuck in the bowels of > > some Excel file, it's the duty of Excel and you to get it out of there, > > not gnuplot's. And, luckily, it can do it: you can export the data you > > have to a CSV file, and gnuplot will be able to read it. > > > >> To be able to select the data file directly from the GUI, without having > >> to write the name in the command line windows would be nice. > > > > It is nice --- you can do it right now. If it *is* a data file, rather > > than some Excel blob, that is. > > > >> Are you developping a preference setting to choose the language of > >> Gnuplot ? > > > > No. But maybe I just didn't understand that question. What "language of > > gnuplot" to you want to make preference-settable there? gnuplot uses > > essentially only one language, and that only to write documentation in and > > derive keywords from. Neither of which seems to be what you're asking > > about. So: what kind of change do you have in mind there? > > > |
|
From: ccharron1 <cch...@fr...> - 2004-10-03 14:32:46
|
Hi, About the language, I'm thinking Germa, French, Spanish ... Gui translation. You don't seem to appreciate Excel, and like you I'm carefull about Microsoft, but the present situation is that the majority of the people are using excel actually, and if you don't have it, it's a little bit difficult to do some business work Thanks Christophe ----- Original Message ----- From: "Hans-Bernhard Broeker" <br...@ph...> To: "ccharron1" <cch...@fr...> Cc: "gnuplot" <gnu...@li...> Sent: Sunday, October 03, 2004 2:12 AM Subject: Re: [Gnuplot-info] Suggestion > On Sat, 2 Oct 2004, ccharron1 wrote: > > > I'm discovering gnuplot and I'm trying to use it to do some 3D-graph > > representation of data (real x, y and z graph). As my data are in an excel > > sheet, it would be very usefull if gnuplot would have an option to import > > directly the data from an excel file, as a command in a GUI. > > I don't think that'll happen. If you have data stuck in the bowels of > some Excel file, it's the duty of Excel and you to get it out of there, > not gnuplot's. And, luckily, it can do it: you can export the data you > have to a CSV file, and gnuplot will be able to read it. > > > To be able to select the data file directly from the GUI, without having > > to write the name in the command line windows would be nice. > > It is nice --- you can do it right now. If it *is* a data file, rather > than some Excel blob, that is. > > > Are you developping a preference setting to choose the language of > > Gnuplot ? > > No. But maybe I just didn't understand that question. What "language of > gnuplot" to you want to make preference-settable there? gnuplot uses > essentially only one language, and that only to write documentation in and > derive keywords from. Neither of which seems to be what you're asking > about. So: what kind of change do you have in mind there? > > -- > Hans-Bernhard Broeker (br...@ph...) > Even if all the snow were burnt, ashes would remain. > > > |