haspic.blogg.se

The data, which we are going to work with, is order details from AdventureWorks2014. You can change that in the demo very easily. csv file with all the data and the demo is configured to read from the. Don't worry if you don't have a SQL Server running. The data is taken from AdventureWorks2014. If not, the blame is almost surely on Excel and not the demo. So, even without the demo, you can test them with your version of Excel program and make sure that they can be opened correctly. When you run the solution, you will get these same Excel files every time. The Excel files, available for download, were not opened by an Excel program. The article explains how to circumvent this problem but that might be redundant with future versions EPPlus. The second point is that future versions of EPPlus might implement features that are currently not available with EPPlus 4.1.1. There's also a slight chance that it won't work with future versions of Excel, but that is less likely since Excel has back-compatibility built into it.

This means that if you try to open the file with Excel version 2010 or less, it might tell you that the file is corrupt and can't be opened properly.

The first point is that maybe some features, or some techniques shown in the article, might not apply to previous versions of Excel. The Excel program that I verified the validity of the files is Excel 2013.

The version of EPPlus that the demo uses is EPPlus 4.1.1. Show Values As % of Parent Total (with Base Field).