Best way to make a template?

Topics: User Forum
Apr 3, 2009 at 12:53 AM
Hi all,

I have a few spreadsheets that I need to use as a template. Most of them have formulas and validations in the cells causing the memory to be inflated and reading them in is slow. So I figured that I could serialize each of them and use them as templates that way. If I read them in with setReadDataOnly(true) would I be able to use the spreadsheet to write to it when I read in the phpxl file?

Developer
Apr 3, 2009 at 7:53 AM
The approach may be possible. But once the serialized spreadsheet is loaded in memory it will occupy as much memory as when you read the ordinary template. There may not be much gain except that it loads faster with the serialized file.