Listware for Excel:Best Practices: Difference between revisions
Jump to navigation
Jump to search
Created page with "==Upgrade to latest .NET== BP_XLPW_001 Upgrade to the latest "FULL" version of .NET before installing the Excel Plug-ins ==Saving Output Results== BP_XLPW_002 Save as xls o..." |
No edit summary |
||
| Line 1: | Line 1: | ||
==Upgrade to latest .NET== | ==Upgrade to latest .NET== | ||
BP_XLPW_001 | BP_XLPW_001 | ||
Upgrade to the latest "FULL" version of .NET before installing the Excel Plug-ins | Upgrade to the latest "FULL" version of .NET before installing the Excel Plug-ins | ||
==Saving Output Results== | ==Saving Output Results== | ||
| Line 10: | Line 12: | ||
Save active sheet between multiple runs. In the event the service ends unexpectedly, previously appended Results will not be lost. | Save active sheet between multiple runs. In the event the service ends unexpectedly, previously appended Results will not be lost. | ||
==Optimizing Speed== | ==Optimizing Speed== | ||
Revision as of 14:30, 23 January 2014
Upgrade to latest .NET
BP_XLPW_001
Upgrade to the latest "FULL" version of .NET before installing the Excel Plug-ins
Saving Output Results
BP_XLPW_002
Save as xls or xlsx to be able to save the background colors of the cells and the comments on the fields that Personator appends.
Save active sheet between multiple runs. In the event the service ends unexpectedly, previously appended Results will not be lost.
Optimizing Speed
BP_XLPW_003
For faster processing speed, turn off the PlugIn Options which add formatting to the output cells. While the formatting makes
poat-processing analyzing easier and visually more attractive, writing the formatting to the excel output sheet can slow down the
process significantly.