> "gregjohn" <pte### [at] yahoocom> wrote:
>> I work with a lot of generated CSV files.  I'm getting tired of all the mouse
>> clicks required to import it into Excel, and into an intelligible graph.  I'd
>> like to write my own povray file for graphing, perhaps one that is always
>> perfect in "readability" no matter what render pixel size you pick.
>>
>> What's the quickest way of getting a CSV-formatted data file into povray?  (If I
>> have to do even a small amount of editing of the CSV by hand, it ruins the
>> benefit of the project.)
>
> Oh my, upon seeing a corporate directive to use Apache OpenOffice, I tried to
> use Calc to import my CSV.
>
> It interpreted
> -3.5308E-07
>
> as
> '-3.5308E-07

IIRC, when you open the CSV in AOO, there's an option to "detect special 
numbers" (or something similar) that will make it treat scitentific 
notations as numbers and not text.


-- 
/*Francois Labreque*/#local a=x+y;#local b=x+a;#local c=a+b;#macro P(F//
/*    flabreque    */L)polygon{5,F,F+z,L+z,L,F pigment{rgb 9}}#end union
/*        @        */{P(0,a)P(a,b)P(b,c)P(2*a,2*b)P(2*b,b+c)P(b+c,<2,3>)
/*   gmail.com     */}camera{orthographic location<6,1.25,-6>look_at a }

Post a reply to this message