Issue with case sensitive

Mar 2, 2015 at 3:33 PM
Hi!

Today I spend some time trying to import multiple csv-files into a single excel with multiple worksheets.
I was using "$Worksheet.Cells.LoadFromText" for this.
I had the issue EPPlus wouldn't save the file. The Following error popped up (using powershell btw)
Exception calling "SaveAs" with "1" argument(s): "Error saving file filename.xlsx"
At .\create-excel.ps1:102 char:1
+ $ExcelPackage.SaveAs($FileNameExcel)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : InvalidOperationException
In the end, this was caused by having a "True" value in the csv... Replacing all "True" with "TRUE" solved the issue...
"FALSE";"TRUE";"True"
replaced by
"FALSE";"TRUE";"TRUE"
Any idea how this can can happen? Or is their a solution/workaround for this?