Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic On Open Excel Files (Read 520 times)
bizintel_dan
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 10
Joined: Jun 15th, 2020
On Open Excel Files
Jun 15th, 2020 at 8:31pm
Print Post  
Here as Excel File attached opens with an issue. The error message goes away when i exclude my overview worksheet in the workbook.
  

Excel_error_message_2.PNG ( 19 KB | 27 Downloads )
Excel_error_message_2.PNG
Excel_error_message_1.PNG ( 22 KB | 23 Downloads )
Excel_error_message_1.PNG
Back to top
 
IP Logged
 
Slavcho
God Member
*****
Offline


tech.support

Posts: 2362
Joined: Oct 19th, 2005
Re: On Open Excel Files
Reply #1 - Jun 16th, 2020 at 6:26am
Print Post  
Hi,

You mean one created by ExcelExporter? Please attach that "log file listing repairs", and if possible also the source workbook saved in our own format by SaveToFile / SaveToXml.

Regards,
Slavcho
Mindfusion
  
Back to top
 
IP Logged
 
bizintel_dan
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 10
Joined: Jun 15th, 2020
Re: On Open Excel Files
Reply #2 - Jun 29th, 2020 at 1:10am
Print Post  
Attached is the error log text.
I'll pm you two serialized workbooks as xdocuments.
The adv_workbook gets the error. nrth_workbook doesn't. Even though they go through the same functions. Just different data.
Let me know if you want to look at the excels as well.
  

errorlog.txt ( 0 KB | 28 Downloads )
Back to top
 
IP Logged
 
Slavcho
God Member
*****
Offline


tech.support

Posts: 2362
Joined: Oct 19th, 2005
Re: On Open Excel Files
Reply #3 - Jul 3rd, 2020 at 9:44am
Print Post  
It turns out Excel does not allow sheet names longer than 30 characters. For time being you could export a copy of the workbook with pruned names:

Code
Select All
foreach (var sheet in workbook.Worksheets)
    if (sheet.Name.Length > 30)
        sheet.Name = sheet.Name.Substring(0, 30);
ex.Export(workbook, "..."); 



We'll fix that in exporter class for upcoming release.

Regards,
Slavcho
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint