Formatting excel sheet with column locks and data validation

Jeganath KS has asked for the wisdom of the Perl Monks concerning the following question:

I have formatted the excel sheet(.xls file) with column locks and data validations using the module Spreadsheet::WriteExcel. Now I need to format the excel(.xlsx file) sheet having more than 100000 records. By using Spreadsheet::WriteExcel module, I cannot able to write into .xlsx file. Is it possible for writing data into .xlsx file with column locks and data validations.

Comment on Formatting excel sheet with column locks and data validation

Replies are listed 'Best First'.
Re: Formatting excel sheet with column locks and data validation by Corion (Patriarch) on May 06, 2010 at 07:05 UTC
Spreadsheet::WriteExcel only knows about the `.xls` format. There is a XLSX module on CPAN too. Even if that module does not work for you, `.xlsx` files are basically XML files, so you should be able to set the lock attributes on the corresponding tags yourself.	[reply] [d/l] [select]

Back to Seekers of Perl Wisdom