Invalid XLS file is generated on creating a document with charts via SpreadsheetControl API

Hello Alexandre,
Thank you for your project. I have successfully reproduced the behavior you described and passed this ticket to our developers for further research.
Please bear with us. We will notify you as soon as we make any progress.

However, while researching your scenario, we found the following issues:

1. The Worksheet names are calculated in your scenario with an apostrophe. You need to correct this point by replacing the following code lines:

C#
//string feuilleSourceAxe = correspondance.Groups[1].Value;  
...................  
//string feuilleSource = correspondance.Groups[1].Value;  

with these ones:

C#
string feuilleSourceAxe = correspondance.Groups[1].Value.Trim(new char[] { '\'' });  
.................  
string feuilleSource = correspondance.Groups[1].Value.Trim(new char[] { '\'' });  

2. In your scenario, you are incorrectly using references to document ranges to get corresponding ranges. These references contain information about corresponding worksheets, but are used for inappropriate worksheet instances in your code. The most suitable solution in your scenario is to use the Range.Parse method to calculate correct document ranges. Please refer to the following code:

C#
foreach (Tuple<string, string> tupleCourant in listeElement)  
{  
    //Range rngTitre = feuilleCible.Range[tupleCourant.Item2];  
    //Range rngArguments = feuilleCible.Range[adresseDonneesAxeX];  
    //Range rngValeurs = feuilleCible.Range[tupleCourant.Item1];  
    Range rngTitre = classeur.Range.Parse(tupleCourant.Item2);  
    Range rngArguments = classeur.Range.Parse(adresseDonneesAxeX);  
    Range rngValeurs = classeur.Range.Parse(tupleCourant.Item1);  
    graphiqueCourant.Series.Add(rngTitre, rngArguments, rngValeurs);  

    graphiqueCourant.Series.Add(rngTitre, rngArguments, rngValeurs);  
}