classes/ToCSV.class in poi2csv-0.0.3 vs classes/ToCSV.class in poi2csv-0.0.4
- old
+ new
@@ -1,68 +1,70 @@
- 2
- n ` ` ` ` ` ` `
- `
-
-
-
-
-
-
- `
- `
-
-
- F
+ 2
+ n a a a a a a a
+ a
+
+
+
+
+
+
+ a
+ a
+
+
F
-
-
-
- `
-
- )
-
-
- .
- )
- 1
- `
- <
- ;
- @
- 1 !
- C
- 1"#
- `$
- C%
- C
- F&
- @'
+ F
+
+
+
+ a
+
+ )
+
+
+ .
+ )
+ 1
+
+
+ a
+ <
+ ;
+ @
+ 1!"
+ C
+ 1#$
+ a%
+ C&
+ C
+ F'
@(
@)
- @*+*,-
- 1./0
- .1
- .23
- F45
- F6
- C
- C7
- C89:;<
- `
- `=
- `>
-?@ABC
- nD
-E F
- fGH
- fIJ ExcelFilenameFilter InnerClasses workbook &Lorg/apache/poi/ss/usermodel/Workbook; csvData Ljava/util/ArrayList; Signature @Ljava/util/ArrayList<Ljava/util/ArrayList<Ljava/lang/String;>;>; maxRowWidth I formattingConvention formatter +Lorg/apache/poi/ss/usermodel/DataFormatter; evaluator .Lorg/apache/poi/ss/usermodel/FormulaEvaluator; separator Ljava/lang/String; CSV_FILE_EXTENSION
ConstantValue DEFAULT_SEPARATOR EXCEL_STYLE_ESCAPING UNIX_STYLE_ESCAPING <init> ()V Code LineNumberTable LocalVariableTable this LToCSV; convertExcelToCSV '(Ljava/lang/String;Ljava/lang/String;)V strSource strDestination
-ExceptionsKLM 9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V :(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;I)V excelFile Ljava/io/File; arr$ [Ljava/io/File; len$ i$ source destination filesList destinationFilename
StackMapTable<# openWorkbook (Ljava/io/File;)V file fis Ljava/io/FileInputStream;NN convertToCSV j i sheet #Lorg/apache/poi/ss/usermodel/Sheet; row !Lorg/apache/poi/ss/usermodel/Row;
-lastRowNum numSheetsOP saveCSVFile fw Ljava/io/OutputStreamWriter; bw Ljava/io/BufferedWriter; line buffer Ljava/lang/StringBuffer; csvLineElement LocalVariableTypeTable )Ljava/util/ArrayList<Ljava/lang/String;>;! rowToCSV $(Lorg/apache/poi/ss/usermodel/Row;)V cell "Lorg/apache/poi/ss/usermodel/Cell; lastCellNum csvLineQ escapeEmbeddedCharacters &(Ljava/lang/String;)Ljava/lang/String; field main ([Ljava/lang/String;)V ex Ljava/lang/Exception; args [Ljava/lang/String; converterB
+ @*
+ @+,+-.
+ 1/01
+ .23
+ .45
+ F67
+ F8
+ C
+ C9
+ C:;<=>
+ a
+ a?
+ a@
+ABCD
+ nE
+F G
+ UHI
+ UJK ExcelFilenameFilter InnerClasses workbook &Lorg/apache/poi/ss/usermodel/Workbook; csvData Ljava/util/ArrayList; Signature @Ljava/util/ArrayList<Ljava/util/ArrayList<Ljava/lang/String;>;>; maxRowWidth I formattingConvention formatter +Lorg/apache/poi/ss/usermodel/DataFormatter; evaluator .Lorg/apache/poi/ss/usermodel/FormulaEvaluator; separator Ljava/lang/String; CSV_FILE_EXTENSION
ConstantValue DEFAULT_SEPARATOR EXCEL_STYLE_ESCAPING UNIX_STYLE_ESCAPING <init> ()V Code LineNumberTable LocalVariableTable this LToCSV; convertExcelToCSV '(Ljava/lang/String;Ljava/lang/String;)V strSource strDestination
+ExceptionsLMN 9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V :(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;I)V excelFile Ljava/io/File; arr$ [Ljava/io/File; len$ i$ source destination filesList destinationFilename
StackMapTable>$ openWorkbook (Ljava/io/File;)V file fis Ljava/io/FileInputStream;OO convertToCSV j i sheet #Lorg/apache/poi/ss/usermodel/Sheet; row !Lorg/apache/poi/ss/usermodel/Row;
+lastRowNum numSheetsPQ saveCSVFile fw Ljava/io/OutputStreamWriter; bw Ljava/io/BufferedWriter; line buffer Ljava/lang/StringBuffer; csvLineElement LocalVariableTypeTable )Ljava/util/ArrayList<Ljava/lang/String;>;" rowToCSV $(Lorg/apache/poi/ss/usermodel/Row;)V e Ljava/lang/Exception; cell "Lorg/apache/poi/ss/usermodel/Cell; lastCellNum csvLineR3 escapeEmbeddedCharacters &(Ljava/lang/String;)Ljava/lang/String; field main ([Ljava/lang/String;)V ex args [Ljava/lang/String; converter
SourceFile
-ToCSV.java q r s t w x y x z { | } ~ , java/io/File RST "java/lang/IllegalArgumentException 1The source for the Excel file(s) cannot be found. BThe folder/directory for the converted CSV file(s) does not exist.UT >The destination for the CSV file(s) is not a directory/folder. GThe value passed to the formattingConvention parameter is out of range. ToCSV$ExcelFilenameFilter VWX YZ java/lang/StringBuilder .[\]^_` .csvaZ b cde Opening workbook [ ]fgR java/io/FileInputStream hijklmnop )org/apache/poi/ss/usermodel/DataFormatter qr java/util/ArrayList (Converting files contents to CSV format.stuvOwtxtyz Saving the CSV file [ java/io/OutputStreamWriter java/io/FileOutputStream UTF-8 { java/io/BufferedWriter |}t java/lang/StringBuffer~ java/lang/String _ZR P Qt " \"\"\
+ToCSV.java q r s t w x y x z { | } ~ , java/io/File STU "java/lang/IllegalArgumentException 1The source for the Excel file(s) cannot be found. BThe folder/directory for the converted CSV file(s) does not exist.VU >The destination for the CSV file(s) is not a directory/folder. GThe value passed to the formattingConvention parameter is out of range. ToCSV$ExcelFilenameFilter WXY Z[ java/lang/StringBuilder .\]^_`a .csvb[ c def Opening workbook [ ]ghS java/io/FileInputStream ijklmnopq )org/apache/poi/ss/usermodel/DataFormatter rs java/util/ArrayList (Converting files contents to CSV format.tuvwPxuyuz{ Saving the CSV file [ java/io/OutputStreamWriter java/io/FileOutputStream UTF-8 | java/io/BufferedWriter }~u java/lang/StringBuffer java/lang/String `[S Q Ru java/lang/Exception " \"\"]
\\ \\
- ToCSV \Usage: java ToCSV [Source File/Folder] [Destination Folder] [Separator] [Formatting Convention]
+ ToCSV ]Usage: java ToCSV [Source File/Folder] [Destination Folder] [Separator] [Formatting Convention]
Source File/Folder This argument should contain the name of and
path to either a single Excel workbook or a
folder containing one or more Excel workbooks.
Destination Folder The name of and path to the folder that the
CSV files should be written out into. The
@@ -76,16 +78,16 @@
values. Passing 0 (zero) will result in a CSV
file that obeys Excel's formatting conventions
whilst passing 1 (one) will result in a file
that obeys UNIX formatting conventions. If no
value is passed, then the CSV file produced
- will obey Excel's formatting conventions. java/lang/Exception Caught an: Message: Z Stacktrace follows:..... java/lang/Object java/io/FileNotFoundException java/io/IOException :org/apache/poi/openxml4j/exceptions/InvalidFormatException java/lang/Throwable !org/apache/poi/ss/usermodel/Sheet org/apache/poi/ss/usermodel/Row org/apache/poi/ss/usermodel/Cell (Ljava/lang/String;)V exists ()Z isDirectory
+ will obey Excel's formatting conventions. Caught an: Message: [ Stacktrace follows:..... java/lang/Object java/io/FileNotFoundException java/io/IOException :org/apache/poi/openxml4j/exceptions/InvalidFormatException java/lang/Throwable !org/apache/poi/ss/usermodel/Sheet org/apache/poi/ss/usermodel/Row org/apache/poi/ss/usermodel/Cell (Ljava/lang/String;)V exists ()Z isDirectory
(LToCSV;)V listFiles )(Ljava/io/FilenameFilter;)[Ljava/io/File; getName ()Ljava/lang/String; lastIndexOf (Ljava/lang/String;)I substring (II)Ljava/lang/String; append -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString #(Ljava/io/File;Ljava/lang/String;)V java/lang/System out Ljava/io/PrintStream; java/io/PrintStream println +org/apache/poi/ss/usermodel/WorkbookFactory create =(Ljava/io/InputStream;)Lorg/apache/poi/ss/usermodel/Workbook; $org/apache/poi/ss/usermodel/Workbook getCreationHelper .()Lorg/apache/poi/ss/usermodel/CreationHelper; *org/apache/poi/ss/usermodel/CreationHelper createFormulaEvaluator 0()Lorg/apache/poi/ss/usermodel/FormulaEvaluator; (Z)V close getNumberOfSheets ()I
getSheetAt &(I)Lorg/apache/poi/ss/usermodel/Sheet; getPhysicalNumberOfRows
getLastRowNum getRow $(I)Lorg/apache/poi/ss/usermodel/Row; +(Ljava/io/OutputStream;Ljava/lang/String;)V (Ljava/io/Writer;)V size get (I)Ljava/lang/Object; ,(Ljava/lang/String;)Ljava/lang/StringBuffer; trim write newLine flush getLastCellNum ()S getCell %(I)Lorg/apache/poi/ss/usermodel/Cell; add (Ljava/lang/Object;)Z getCellType formatCellValue d(Lorg/apache/poi/ss/usermodel/Cell;Lorg/apache/poi/ss/usermodel/FormulaEvaluator;)Ljava/lang/String; 6(Lorg/apache/poi/ss/usermodel/Cell;)Ljava/lang/String; contains (Ljava/lang/CharSequence;)Z
replaceAll 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; insert -(ILjava/lang/String;)Ljava/lang/StringBuffer; indexOf java/lang/Integer parseInt getClass ()Ljava/lang/Class; java/lang/Class
-getMessage printStackTrace (Ljava/io/PrintStream;)V ! ` n q r s t u v w x y x z { | } ~ ! x x
- r (* * * * * * * * &