Storing To File Has Failed Error When Saving Data In Excel Format in DIAdem

Updated Feb 17, 2020

Reported In

Software

  • DIAdem

Issue Details

I have several channel groups in the DIAdem Dataportal and want to save them for colleagues in the Excel format. However, I sometimes get this error message: 
Storing the internal data to the file "<file name>.xlsx" with the format "" has failed and the file is incomplete (6204).



 

Solution

The channel group names of the DIAdem Dataportal are used as sheet names in Excel. Here you have at least two restrictions.

A)    Sheet names in Excel must be unique.
B)    Excel supports only a length of 31 characters for a sheet name.

This makes it necessary to have channel group names which differs in the first 31 characters and which have a maximum length of 31 characters.