readXls method When reading xls, if an empty column is encountered, the content of the subsequent column will be filled in it, causing the data of the subsequent column of the generated dataframe to be inconsistent with the column corresponding to the data
in xls like:
AA BB CC
sds sd
readXls :
AA BB CC
0 sds sd
writexls fix thins error:
java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook
readXls method When reading xls, if an empty column is encountered, the content of the subsequent column will be filled in it, causing the data of the subsequent column of the generated dataframe to be inconsistent with the column corresponding to the data
in xls like:
writexls fix thins error: java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook