3 ms·
Parsing proper Excel files is fine - you just have to use a proper Excel parser such as EPPlus or Aspose.Cells or similar. In lots of ways this is actually easi
by arethuza 6y ago
Parsing proper Excel files is fine - you just have to use a proper Excel parser such as EPPlus or Aspose.Cells or similar. In lots of ways this is actually easier than handling CSV files from random sources.
- sk5t 6y agoI've done it with Apache POI, and while that 'worked' it doesn't wash away the fundamental problems with Excel datatype guessing. CSV is not great either (no fun explaining encoding or invisible control characters and unusual whitespace to the average IT person) but it is nevertheless less bad.