Excel formulas (.CSV)

Top  Previous  Next

This function copies all the records of the active file in a new CSV file. All formula data is transferred to the target.

 

The new file is a CSV standard file, it can be opened and  imported by several applications like spreadsheets and word processors.

This new file can also be opened with a standard text (ASCII) editor or handled in different operative systems (Linux, UNIX, Mac etc.).

 

This is an example of the CSV internal data structure:

 

CODE,BASE,BQTY,C1,V1,C2,V2,C3,V3,C4,V4,C5,V5,C6,V6, ... ,C14,V14,C15,V15,NOTE,R,G,B,HTML

CX-01 PYRITE,ULTRA-DEEP,250,XL,48,XG,888,XT,32,,,,,,,,,,,,,,,,,,,,,,,,,,220,186,72,#DCBA48

CX-02 GREEN CITRUS,NEUTRAL,250,XL,56,XG,936,XT,32,XZ,56,,,,,,,,,,,,,,,,,,,,,,,,194,160,50,#C2A032

CX-03 STAR MAGNOLIA,PASTEL,250,XC,8,XL,4,XG,24,,,,,,,,,,,,,,,,,,,,,,,,,,247,236,209,#F7ECD1

CX-04 ANGELICA BLOSSOM,PASTEL,250,XC,24,XL,8,XG,72,,,,,,,,,,,,,,,,,,,,,,,,,,244,227,187,#F4E3BB

CX-05 DIJON,PASTEL,250,XC,48,XL,16,XG,144,,,,,,,,,,,,,,,,,,,,,,,,,,242,221,172,#F2DDAC

CX-06 MUSTARD BLOOM,MEDIUM,250,XC,96,XL,16,XG,288,,,,,,,,,,,,,,,,,,,,,,,,,,240,209,142,#F0D18E

CX-07 HONEY GOLD,DEEP,250,XC,96,XL,16,XG,288,,,,,,,,,,,,,,,,,,,,,,,,,,236,198,120,#ECC678

CX-08 GOLDEN ROTUNDA,DEEP,250,XC,192,XL,32,XG,576,,,,,,,,,,,,,,,,,,,,,,,,,,226,184,100,#E2B864

CX-09 EVERGOLD,NEUTRAL,250,XC,224,XL,32,XG,712,XZ,184,,,,,,,,,,,,,,,,,,,,,,,,207,159,66,#CF9F42

CX-10 DELICATE CREAM,PASTEL,250,XC,8,XG,16,,,,,,,,,,,,,,,,,,,,,,,,,,,,249,238,213,#F9EED5

CX-11 LIGHT HONEY,PASTEL,250,XC,32,XG,64,,,,,,,,,,,,,,,,,,,,,,,,,,,,250,230,188,#FAE6BC

CX-12 ROMAN CHAMOMILE,PASTEL,250,XC,64,XG,128,,,,,,,,,,,,,,,,,,,,,,,,,,,,250,224,172,#FAE0AC

CX-13 DAISETTA,MEDIUM,250,XC,128,XG,256,,,,,,,,,,,,,,,,,,,,,,,,,,,,248,211,143,#F8D38F

CX-14 GOLDEN HORN,DEEP,250,XC,256,XG,512,,,,,,,,,,,,,,,,,,,,,,,,,,,,237,188,99,#EDBC63

...

 

The first line is added to increase file readability.

The following lines contain individual color formulas and sRGB data.

 

The purpose of this function is to make available to other applications formula data. Another usual application is to process formula data for printing purposes, for example a paper formula book.