in reply to Excel Width Calculation

I'm not sure how Excel calculates column width, but the Windows GDI can calculate the width of any string to the pixel for you - regardless of the font or size used.

Win32::API and a search on MSDN for GetTextExtentPoint32 should get you started.

Hope this helps you get started...