我们知道,.xlsb格式的Excel文件存储容量小,打开速度快,一般交付时会使用这种格式。但是,在将.xlsb格式的Excel文件导入到Spotfire时,发现存在两个问题:
1. 数据类型匹配错误(如,文本类型的会被匹配成日期型,数字格式的会被匹配成日期型)
2. Excel数据导入后,某些列在Spotifre中没有任何数据,即,整个一列的数据都丢失了。这个错误比较隐匿,如果不是为了调整筛选器(filter)的类型时发现list box中没有显示任何值,可能不会发现这个问题。
解决方法:
将.xlsb格式另存为.xlsx后,问题解决。
此问题已记入技术学习笔记。
Type | Subtype | Short Desc | Detailed Description | Solution Sample | Last Access |
Spotfire | bug | Excel file with extention name .xlsb cannot be exported to Sportfire correctly | There are 2 issues after .xlsb format was imported into Spotfire as datatable: 1. column type cannot be mapped correctly (String column was mapped to DateTime, vice versa) 2. Data in some columns were not imported at all | Save Excel raw data as a new Excel file in .xlsx format, instead of .xlsb format. | 2019-08-24 17:01:28 |