Hi, you can use the transicc utility to do so: 1) Download the windows binaries of lcms2.0a, you need the transicc utility. 2) On your excel, choose "Save as", "Other formats", "text (tab delimited)". Save a temporary text file with your your lab data: in.txt" 3) On a command line session, use the transicc utility in bacth mode, you need -n toggle. Example:
transicc -n -l CIELab_to_UPLab2.icc <in.txt >out.txt 4) In excel, "open" "text files", and then out.txt, choose "delimited" and "Delimiter: space" It worked to me. Otherwise, if you need a perceptually uniform color space, you could give a try to CIE CAM02, which is far better than CIE L*a*b*. Regards Marti Maria Quoting Jim Reswick Jr <j...@reswickgallery.com>: > Hi: > > I have a batching issue that I'm hoping Lcms may be able to resolve. > I am a DBA by profession and not a heavy coder (photography and > unique large format printing methods are my avocation). > > I have developed a spreadsheet for analyzing target and ramp color > data that largely references hue angle based on L*a*b* readings (not > to be LCh) from my EyeOne that are loaded into the spreadsheet > through Macbeth Key Wizard. I am coding it in OpenOffice Calc VBA in > the Windows environment, and much of the code is simple > transformations and polar/rectangular conversions, etc. > > Unfortunately, I am getting into trouble because L*a*b* is not > perceptually uniform, and as I move saturation down a hue angle axis, > I'm getting the usual perceptual color shifts associated with L*a*b*. > I am a grateful visitor of Bruce Lindbloom's site, and have read his > analysis of L*a*b*'s non-perceptual uniformity issues. Consequently, > I desire to employ his Perceptually Uniform profile in correcting my > raw measured data. > > I have a number of tools that are capable of returning L*a*b* data > processed through profiles, but the batch methods are for images and > the raw data methods are calculators that have to be manually fed. I > need to get columns of L*a*b* data in my spreadsheet processed > through Bruce's profile by batch methods, and reloaded into the > spreadsheet for VBA processing. > > From what I have been reading, Lcms is a library of source code for > app development, which is beyond my expertise. Is there a developed > tool based on Lcms for Windows that I can use to (at the very least) > run through text list files from a command line (or maybe a GUI) and > batch process the data through a profile (Bruce's) so that I can > reload the corrected data back into the spreadsheet? > > Any help would be appreciated! > > Thanks, Jim > > > > > Jim Reswick Jr > HC1 Box 20 > La Honda, CA 94020 ------------------------------------------------------------------------------ _______________________________________________ Lcms-user mailing list Lcms-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/lcms-user