Test Scenario

  • Time cost when Export an Word/Excel file
  • Time cost when batch Export Word/Excel files
  • Output File Size

Test Environment

  • O/S: Microsoft Windows XP Service Pack 3
  • CPU: Intel Celeron E3300
  • Mainboard: ECS G31T-M9
  • RAM: Geil CL5-5-5 DDR2 800 2GB
  • Graphics: Intel Chipset – Integrated Graphics 0[ECS EliteGroup Computer]
  • HDD: Seagate ST3500418AS
  • Office: Office Automation via Office 2003 and Spire.Office for .NET
  • Test Data Source Files Info:
    Rows Columns
    File 1 20 5
    File 2 55 15
    File 3 43 7
    File 4 60 8
    File 5 5000 7

Test Result

Export Data to Word

When export a single Word file document, Office OLE Automation is much slower than Spire.Doc. From the result above we can see that Spire.Doc only need about 20ms and Office need at least add 1000ms.

Batch Export Word Files

When batch export 10 Word file documents, Spire.Doc need some more time but it is still much faster.

Export Single Word File Output Size

The exported output Word document file size created by Spire.Doc is much smaller than which created by Office OLE Automation.

Export Data to Excel

Export an Excel File

When export a single Excel file, Spire.XLS is faster than Office OLE Automation. We tested 9 times and the average time (Spire.XLS,1233ms; Office,1633ms) shows Spire.XLS is about 1/3 faster.

Batch Export Excel Files (10 Files)

Batch export 10 Excel files and from the Chart above we can see Spire.XLS and Office OLE Automation spend almost the same time.

PS: Office OLE Automation Excel will ask you whether overlap the same name files or not, which may reduce export speed. Spire.XLS for .NET enables you set up to ignore this hint.

Export Single Excel File Output Size

After exporting data to Excel, we can see the output file size from the above chart for both Office and Spire.XLS. The result shows it's really a small difference between them.

PS: When we test large content data on exporting through Office OLE automation, the test PC would stop working. It took all of the CPU usage and need more than 10 minutes to return normal. Furthermore, it stored the Excel/Word process in RAM which needs manual operation or program to finish. That's really a trouble for non-professional.

Download Comparion Details.xls

Download Source Code

Wednesday, 06 April 2011 09:53

PDF Split in C#, VB.NET

The sample demonstrates how to split one PDF document to multiple PDF documents.

(NO screenshot)

Wednesday, 06 April 2011 09:50

PDF Merge in C#, VB.NET

The sample demonstrates how to merge multiple PDF documents to one PDF document.

(NO screenshot)

Wednesday, 06 April 2011 09:47

PDF Extract in C#, VB.NET

The sample demonstrates how to extract images and text from PDF document.

(NO screenshot)

Wednesday, 06 April 2011 09:44

PDF Booklet in C#, VB.NET

The sample demonstrates how to convert a PDF document to a booklet.

Download Booklet.pdf

Wednesday, 06 April 2011 09:41

PDF ViewPreference in C#, VB.NET

The sample demonstrates how to set PDF document view preference.

Download ViewerPreference.pdf

Wednesday, 06 April 2011 09:37

PDF Properties in C#, VB.NET

The sample demonstrates how to set PDF document properties and PDF file information.

Download Properties.pdf

Wednesday, 06 April 2011 09:33

PDF FromHTML in C#, VB.NET

The sample demonstrates how to convert HTML to PDF document.

Download FromHTML.pdf

Wednesday, 06 April 2011 09:30

PDF DigitalCertificate in C#, VB.NET

The sample demonstrates how to sign PDF document with digital certificate.

Download DigitalSignature.pdf

Wednesday, 06 April 2011 09:27

PDF Decrypt in C#, VB.NET

The sample demonstrates how to decrypt an encrypted PDF document and extract the embedded picture.

Page 7 of 22