[Pzfilereader-svn] SF.net SVN: pzfilereader: [112] trunk/PZFileReaderSamples/src/main/java/net /sf/pzfilereader/examples/exporttoexcel/DelimitedFileExportToExcel.java

[<zep...@us...>]

Revision: 112
          http://svn.sourceforge.net/pzfilereader/?rev=112&view=rev
Author:   zepernick
Date:     2006-10-24 04:03:22 -0700 (Tue, 24 Oct 2006)

Log Message:
-----------
Added code to print the errors found in the file if there were any.

Pointed to a text file with no header and trailer to corrispond with
the mapping.

Modified Paths:
--------------
    trunk/PZFileReaderSamples/src/main/java/net/sf/pzfilereader/examples/exporttoexcel/DelimitedFileExportToExcel.java

Modified: trunk/PZFileReaderSamples/src/main/java/net/sf/pzfilereader/examples/exporttoexcel/DelimitedFileExportToExcel.java
===================================================================
--- trunk/PZFileReaderSamples/src/main/java/net/sf/pzfilereader/examples/exporttoexcel/DelimitedFileExportToExcel.java	2006-10-23 11:34:12 UTC (rev 111)
+++ trunk/PZFileReaderSamples/src/main/java/net/sf/pzfilereader/examples/exporttoexcel/DelimitedFileExportToExcel.java	2006-10-24 11:03:22 UTC (rev 112)
@@ -7,6 +7,7 @@
 
 import java.io.File;
 
+import net.sf.pzfilereader.DataError;
 import net.sf.pzfilereader.DataSet;
 import net.sf.pzfilereader.ordering.OrderBy;
 import net.sf.pzfilereader.ordering.OrderColumn;
@@ -26,7 +27,7 @@
     }
 
     public static String getDefaultDataFile() {
-        return "PEOPLE-CommaDelimitedWithQualifierAndHeaderTrailer.txt";
+        return "PEOPLE-CommaDelimitedWithQualifier.txt";
     }
 
     public static String getDefaultMapping() {
@@ -49,11 +50,16 @@
         ds.orderRows(orderby);
 
         if (ds.getErrors() != null && ds.getErrors().size() > 0) {
-            System.out.println("FOUND ERRORS IN FILE");
+            for (int i = 0; i < ds.getErrors().size(); i++){
+                final DataError de = (DataError)ds.getErrors().get(i);
+                System.out.println("Error Msg: " + de.getErrorDesc() + " Line: " + de.getLineNo());
+            }
         }
 
         // lets write this file out to excel :)
-        ds.writeToExcel(new File("MyExcelExport.xls"));
+        File xlFile = new File("MyExcelExport.xls");
+        ds.writeToExcel(xlFile);
+        System.out.println("Excel Workbook Written To: " + xlFile.getAbsolutePath());
 
         // clear out the DataSet object for the JVM to collect
         ds.freeMemory();


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.