Author: nick
Date: Thu Feb 27 13:32:27 2014
New Revision: 1572555
URL: http://svn.apache.org/r1572555
Log:
Report how long the CSV conversion took, helpful for a quick read performance
test
Modified:
poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java
Modified: poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java?rev=1572555&r1=1572554&r2=1572555&view=diff
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java (original)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/ToCSV.java Thu Feb 27
13:32:27 2014
@@ -18,24 +18,24 @@
package org.apache.poi.ss.examples;
-import org.apache.poi.ss.usermodel.WorkbookFactory;
-import org.apache.poi.ss.usermodel.Workbook;
-import org.apache.poi.ss.usermodel.Sheet;
-import org.apache.poi.ss.usermodel.Row;
-import org.apache.poi.ss.usermodel.Cell;
-import org.apache.poi.ss.usermodel.DataFormatter;
-import org.apache.poi.ss.usermodel.FormulaEvaluator;
-import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
-
+import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
+import java.io.FileNotFoundException;
import java.io.FileWriter;
-import java.io.BufferedWriter;
import java.io.FilenameFilter;
import java.io.IOException;
-import java.io.FileNotFoundException;
import java.util.ArrayList;
+import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
+import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.DataFormatter;
+import org.apache.poi.ss.usermodel.FormulaEvaluator;
+import org.apache.poi.ss.usermodel.Row;
+import org.apache.poi.ss.usermodel.Sheet;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.ss.usermodel.WorkbookFactory;
+
/**
* Demonstrates <em>one</em> way to convert an Excel spreadsheet into a CSV
* file. This class makes the following assumptions;
@@ -669,6 +669,8 @@ public class ToCSV {
// for example - then the CSV file generated from one will overwrite
// that generated from the other.
ToCSV converter = null;
+ boolean converted = true;
+ long startTime = System.currentTimeMillis();
try {
converter = new ToCSV();
if(args.length == 2) {
@@ -710,6 +712,7 @@ public class ToCSV {
"\t\t\t\tthat obeys UNIX formatting conventions. If no\n" +
"\t\t\t\tvalue is passed, then the CSV file produced\n" +
"\t\t\t\twill obey Excel's formatting conventions.");
+ converted = false;
}
}
// It is not wise to have such a wide catch clause - Exception is very
@@ -723,6 +726,12 @@ public class ToCSV {
System.out.println("Message: " + ex.getMessage());
System.out.println("Stacktrace follows:.....");
ex.printStackTrace(System.out);
+ converted = false;
+ }
+
+ if (converted) {
+ System.out.println("Conversion took " +
+ (int)((System.currentTimeMillis() - startTime)/1000) + "
seconds");
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
