Skip to content

Using WPS Software for Excel Template Printout

Jump to bottom
GENY edited this page May 31, 2026 · 1 revision

Using WPS Software for Excel Template Printout

Overview

WPS (Kingsoft Office) provides a lightweight and compatible alternative to Microsoft Excel for printing EEM test reports and templates. This section guides you through setting up and using WPS software to generate professional printouts of your test result Excel templates.

System Requirements

  • WPS Office (Spreadsheets module)
  • Compatible with .xls, .xlsx, and .xlsm file formats
  • Windows operating system
  • Sufficient disk space for template storage

Installation & Setup

  1. Install WPS Office

    • Download WPS Office from the official website
    • Install the Spreadsheets component
    • Launch WPS Spreadsheets

  2. Configure Print Settings

    • Open your EEM Excel template in WPS
    • Navigate to File → Page Setup
    • Set paper size to A4 (or your preferred format)
    • Adjust margins: Top/Bottom 0.75", Left/Right 0.5"
    • Enable "Fit to 1 page width" for optimal printout

Printing Excel Templates

  1. Open Template

    • File → Open → Select your EEM template (.xlsx, .xlsm, or .xls)
    • Verify all data is correctly populated

  2. Preview Before Printing

    • Go to File → Print Preview
    • Check page breaks and layout
    • Adjust page orientation (Portrait/Landscape) if needed

  3. Print Configuration

    • Select File → Print (Ctrl+P)
    • Choose your printer
    • Set print options:
      • Print Quality: High/Best
      • Color Mode: Color or Black & White
      • Pages: Select specific pages or print all
    • Click Print

  4. Save as PDF (Optional)

    • For digital archival: File → Export as PDF
    • Adjust compression settings for optimal file size

Template Compatibility

EEM Excel templates are fully compatible with WPS Office:

  • Standard formulas and formatting preserved
  • Macros (.xlsm) supported with full functionality
  • Charts and vector diagrams render correctly
  • Conditional formatting maintained

Troubleshooting

Issue Solution
Template formulas not calculating Ensure macros are enabled in WPS (File → Options → Trust Center)
Print preview shows incorrect layout Check page setup and column widths in the template
Fonts appear different Install required fonts or allow WPS to substitute compatible fonts
Macro errors Verify template compatibility; re-save as .xlsm in Excel if needed

Best Practices

  • Backup Templates: Keep original templates in a secure location
  • Font Consistency: Use standard fonts (Arial, Times New Roman) for cross-platform compatibility
  • Page Setup: Test print settings on sample template before batch printing
  • Regular Updates: Update WPS Office regularly for better Excel compatibility
  • Data Validation: Verify test data completeness before printing

Integration with EEM Software

The Printout application (v1.4.46+) generates Excel templates compatible with WPS. For automated report generation:

  • Run MeterTest.exe to generate test data
  • Use Printout.exe to create Excel template
  • Open template in WPS for final review and printing

Clone this wiki locally