| • | 2.1(215) fixes a problem with failure to properly set formats when the //XL,AddSheet directive was specified with both srcbook and dstbook arguments set to the same file. |
| • | 2.1(216) fixes a problem with the //XL,SetCol directive failing to properly recognize the numfmtid=NUMFMT_TEXT option (possibly leading to cells meant to contain text showing up as 0 in the target spreadsheet if first 20 rows of data were not representative of the remainder of the rows for the affected column). |
| • | 2.1(217) enhances the //XL,AddSheet directive by adding a new optional parameter "deletefirst", e.g. |
//XL,AddSheet,srcbook=x.xls,dstbook=x.xls,sheetname=test,deletefirst
If the deletefirst parameter is specified and the specified sheet already exists, it will first be deleted before being re-added. Otherwise, the default is, and has been, to just overwrite the existing sheet with the new data. This could result in a mixture of new and old data if the CSV data contains fewer rows or columns than the existing sheet data.
