note
Albannach
Another potentially hair-brained scheme for your consideration:
<ul>
<li>For a one time task using actual Excel, create a workbook with an <code>Auto_Open()</code> macro containing simply <code>Columns.AutoFit</code>
<li>Again one time only, using the <code>extract_vba.pl</code> utility from [cpan://Excel::Writer::XLSX], extract the macro as a binary file and store it somewhere permanently for use in your periodic spreadsheet generation
<li>Use [cpan://Excel::Writer::XLSX] to do all your spreadsheet creation, and also insert the macro using <code>add_vba_project( 'vbaProject.bin' )</code>, then distribute the resulting as an XLSM file. Now I don't know how much this will mess up your spreadsheet creation code, but according to the [http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.72/lib/Excel/Writer/XLSX.pm#Compatibility_with_Spreadsheet::WriteExcel|docs], it should be little problem.
</ul>
</p>
The downside is depending on your users' setups they may have to authorize the macro to run when they load the file, which may generate lots of questions and put you no farther ahead than you are now.
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-33341">
<p>--<br>
I'd like to be able to assign to an luser
</div></div>
1053936
1053936