MVC web app error The type initializer for 'MS.Utility.EventTrace' threw an exception. when calling SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(file, SpreadsheetDocumentType.Workbook);

Question

User-351932365 posted

have a class inside mvc 6 application calling   SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(file, SpreadsheetDocumentType.Workbook);

error is The type initializer for 'MS.Utility.EventTrace' threw an exception when calling SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(file, SpreadsheetDocumentType.Workbook);

I have all the openxml working inside an exe program.  Moved the one class over to MVC, Where can I start?

Cindy

Answer 1

User-351932365 posted

also is this a permissions issue from trace?  With exe was writing to a share on c.  all users have permission.  With mvc do I have to write to a folder inside of mvc app?

Application Authentication	Tag(arftr) SPApplicationAuthenticationModule.IsBearerChallengeRequested: Return 'False'.
Claims Authentication	Tag(crpqx) STS setting for SuppressModernAuthForOfficeClients:'True'.	0.002030	0.002030
Application Authentication	Tag(bjkut) IsClaimsTrustedAuthenticationOnly: 'False', IsOfficeClientIDCRLRequest: 'False', HasSPTrustedSecurityTokenIssuer: 'False', ForceIdcrlForOfficeClients: 'True'.

Answer 2

User1686398519 posted

Hi cmellocanon, 

1. Have you installed DocumentFormat.OpenXml?You can install it through NuGet.
2. SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(file, SpreadsheetDocumentType.Workbook);
   • Is the value of the file correct?

Best Regards,

YihuiSun

Answer 3

User-351932365 posted

I reinstalled the package, same error.  By file, and this part does work in the console app.   For example I can run console app and file is created   so when code runs it first checks is there an old file then delete it.

     System.IO.FileInfo newFile = new System.IO.FileInfo(fileName);
                if (File.Exists(fileFullname))
                {
                    newFile.Delete();
                };

The file is in a share on c that all users have modify

then I run

  // Create a spreadsheet document by providing a file name.  
            SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.
                Create(file, SpreadsheetDocumentType.Workbook);

where file is that same share 

and error is the same 

{"The type initializer for 'MS.Utility.EventTrace' threw an exception."}

   do I have to use a folder inside the mvc app as the location to create?   is that a difference between mvc and console app?  sorry feel like I am out of my depth....do not have another developer to ask questions

Answer 4

User-351932365 posted

Thank you YihuiSun,

The mvc application could not do c fileshare, using folder inside of mvc with map path The code is working.  

Cindy