Fine della traccia dello stack dell'eccezione interna. In 1C1(String value, Int32 row, Int32 col) In (String value, dlgTransl addressTranslator, Int32 row, Int32 col, Int32 rowIncr, Int32 colIncr)
In (String part, Int32 row, Int32 col, Int32 rowIncr, Int32 colIncr) In _1(String part, Int32 row, Int32 col, Int32 rowIncr, Int32 colIncr) System.ArgumentOutOfRangeException: La lunghezza non può essere minore di zero. XmlTextWriter xmlTextWriter = new XmlTextWriter ( stringWriter ) StringWriter stringWriter = new StringWriter() String sSaveAsWorbookFileName = ConfigurationManager.AppSettings String sWorkbookFileName = ConfigurationManager.AppSettings Stack Trace: at ()Īt (FileInfo file)Īt (String args) in d:\Spikes\EpPlusPivotTableConsoleApp\EpPlusPivotTableConsoleApp\Program.cs:line 45 The use of SaveAs to a different file, instead of Save to the same file, allows to proof that there is no weird stuff going on at runtime between the read and the write, like a schema downgrade that is OK in memory, but turns out incompatible when save back to the same file.Įxception: Error saving file D:\data\SaveAsTest.xlsx The code and the test run clearly show that the exception is thrown when the SaveAs is attempted to be executed, in this case, to no avail.
In fact, the spike shows that the library can do most things properly with a workbook that has one or more Pivot Tables, but there seems to be a bug when trying to save said workbook. The spike shows that the library can properly navigate through the collection of Pivot Tables on any given WorkSheet of the open WorkBook, and within any given Pivot Table, it can properly retrieve the XML for said Pivot Table. I did a test run with the example workbook provided by stevenxi, and the stdout of said run is as follows (see stdout below).
It is a small console app (see the code sample below). I did a spike to help expose what might be be going on.
0 kommentar(er)
