/// <summary>
/// Updates the series text.
/// </summary>
/// <param name="sheetName">Name of the sheet.</param>
/// <param name="chartSeries">The chart series.</param>
/// <param name="columnName">Name of the column.</param>
/// <param name="pointCountVal">The point count val.</param>
/// <param name="stringPointNumericVal">The string point numeric val.</param>
protected static void UpdateSeriesText(string sheetName, OpenXmlCompositeElement chartSeries, string columnName, int pointCountVal, string stringPointNumericVal)
{
if (chartSeries != null)
{
SeriesText seriesText = chartSeries.Descendants <SeriesText>().FirstOrDefault();
if (seriesText == null)
{
seriesText = chartSeries.AppendChild <SeriesText>(new SeriesText());
}
else
{
seriesText.RemoveAllChildren <StringReference>();
}
StringReference stringReference = GetStringReference(sheetName + "!$" + columnName + "$1", pointCountVal);
AddStringPoint(stringReference.StringCache, 0, stringPointNumericVal);
seriesText.Append(stringReference);
}
}
public PieChartSeries GeneratePieChartSeries(string[] labels, double[] data)
{
PieChartSeries pieChartSeries1 = new PieChartSeries();
Index index1 = new Index()
{
Val = (UInt32Value)0U
};
Order order1 = new Order()
{
Val = (UInt32Value)0U
};
SeriesText seriesText1 = new SeriesText();
NumericValue numericValue1 = new NumericValue();
numericValue1.Text = "sreie 1";
seriesText1.Append(numericValue1);
CategoryAxisData categoryAxisData1 = new CategoryAxisData();
StringLiteral stringLiteral1 = new StringLiteral();
PointCount pointCount1 = new PointCount()
{
Val = (uint)labels.Length
};
//StringPoint stringPoint1 = new StringPoint() { Index = (UInt32Value)0U };
//NumericValue numericValue2 = new NumericValue();
//numericValue2.Text = "a";
//stringPoint1.Append(numericValue2);
//StringPoint stringPoint2 = new StringPoint() { Index = (UInt32Value)1U };
//NumericValue numericValue3 = new NumericValue();
//numericValue3.Text = "n";
//stringPoint2.Append(numericValue3);
//StringPoint stringPoint3 = new StringPoint() { Index = (UInt32Value)2U };
//NumericValue numericValue4 = new NumericValue();
//numericValue4.Text = "c";
//stringPoint3.Append(numericValue4);
//StringPoint stringPoint4 = new StringPoint() { Index = (UInt32Value)3U };
//NumericValue numericValue5 = new NumericValue();
//numericValue5.Text = "d";
//stringPoint4.Append(numericValue5);
//Ajout des etiquette de legendes
for (int i = 0; i < labels.Length; i++)
{
StringPoint stringPoint = new StringPoint()
{
Index = (uint)i
};
NumericValue numericValue = new NumericValue();
numericValue.Text = labels[i];
stringPoint.Append(numericValue);
stringLiteral1.Append(stringPoint);
}
stringLiteral1.Append(pointCount1);
//stringLiteral1.Append(stringPoint1);
//stringLiteral1.Append(stringPoint2);
//stringLiteral1.Append(stringPoint3);
//stringLiteral1.Append(stringPoint4);
categoryAxisData1.Append(stringLiteral1);
DocumentFormat.OpenXml.Drawing.Charts.Values values1 = new DocumentFormat.OpenXml.Drawing.Charts.Values();
NumberLiteral numberLiteral1 = new NumberLiteral();
FormatCode formatCode1 = new FormatCode();
formatCode1.Text = "General";
PointCount pointCount2 = new PointCount()
{
Val = (uint)data.Length
};
//NumericPoint numericPoint1 = new NumericPoint() { Index = (UInt32Value)0U };
//NumericValue numericValue6 = new NumericValue();
//numericValue6.Text = "1";
//numericPoint1.Append(numericValue6);
//NumericPoint numericPoint2 = new NumericPoint() { Index = (UInt32Value)1U };
//NumericValue numericValue7 = new NumericValue();
//numericValue7.Text = "2";
//numericPoint2.Append(numericValue7);
//NumericPoint numericPoint3 = new NumericPoint() { Index = (UInt32Value)2U };
//NumericValue numericValue8 = new NumericValue();
//numericValue8.Text = "3";
//numericPoint3.Append(numericValue8);
//NumericPoint numericPoint4 = new NumericPoint() { Index = (UInt32Value)3U };
//NumericValue numericValue9 = new NumericValue();
//numericValue9.Text = "5";
//numericPoint4.Append(numericValue9);
for (int i = 0; i < data.Length; i++)
{
NumericPoint numericPoint = new NumericPoint()
{
Index = (uint)i
};
NumericValue numericValue = new NumericValue();
numericValue.Text = data[i].ToString();
numericPoint.Append(numericValue);
numberLiteral1.Append(numericPoint);
}
numberLiteral1.Append(formatCode1);
numberLiteral1.Append(pointCount2);
//numberLiteral1.Append(numericPoint1);
//numberLiteral1.Append(numericPoint2);
//numberLiteral1.Append(numericPoint3);
//numberLiteral1.Append(numericPoint4);
values1.Append(numberLiteral1);
pieChartSeries1.Append(index1);
pieChartSeries1.Append(order1);
pieChartSeries1.Append(seriesText1);
pieChartSeries1.Append(categoryAxisData1);
pieChartSeries1.Append(values1);
return(pieChartSeries1);
}
protected void modificaChartData(string FormatoValori, string titoloSerie, out SeriesText seriesText1, out CategoryAxisData categoryAxisData1, out Values values1)
{
seriesText1 = new SeriesText();
StringReference stringReference1 = new StringReference();
Formula formula1 = new Formula();
formula1.Text = "Foglio1!$B$1";
StringCache stringCache1 = new StringCache();
PointCount pointCount1 = new PointCount()
{
Val = (UInt32Value)1U
};
StringPoint stringPoint1 = new StringPoint()
{
Index = (UInt32Value)0U
};
NumericValue numericValue1 = new NumericValue();
numericValue1.Text = titoloSerie;
stringPoint1.Append(numericValue1);
stringCache1.Append(pointCount1);
stringCache1.Append(stringPoint1);
stringReference1.Append(formula1);
stringReference1.Append(stringCache1);
seriesText1.Append(stringReference1);
DataPoint dataPoint1 = new DataPoint();
Index index2 = new Index()
{
Val = (UInt32Value)2U
};
dataPoint1.Append(index2);
//################################i testi ####################################
categoryAxisData1 = new CategoryAxisData();
StringReference stringReference2 = new StringReference();
Formula formula2 = new Formula();
formula2.Text = string.Format("Foglio1!$A$2:$A${0}", valori.Count + 2);
StringCache stringCache2 = new StringCache();
UInt32Value nValori = Convert.ToUInt32(valori.Count);
PointCount pointCount2 = new PointCount()
{
Val = nValori
};
StringPoint[] stringPoints = new StringPoint[nValori];
UInt32Value n = 0;
foreach (KeyValuePair <string, double> item in valori)
{
stringPoints[n] = new StringPoint()
{
Index = (UInt32Value)n
};
NumericValue numericValue2 = new NumericValue();
numericValue2.Text = item.Key;
stringPoints[n].Append(numericValue2);
n += 1;
}
stringCache2.Append(pointCount2);
for (int i = 0; i < n; i++)
{
stringCache2.Append(stringPoints[i]);
}
stringReference2.Append(formula2);
stringReference2.Append(stringCache2);
categoryAxisData1.Append(stringReference2);
//################################i valori####################################
values1 = new Values();
NumberReference numberReference1 = new NumberReference();
Formula formula3 = new Formula();
formula3.Text = string.Format("Foglio1!$B$2:$B${0}", valori.Count + 2);
NumberingCache numberingCache1 = new NumberingCache();
FormatCode formatCode1 = new FormatCode();
formatCode1.Text = FormatoValori; //<-----------------------------------------------------------
PointCount pointCount3 = new PointCount()
{
Val = nValori
};
NumericPoint[] numericPoints = new NumericPoint[nValori];
n = 0;
foreach (KeyValuePair <string, double> item in valori)
{
numericPoints[n] = new NumericPoint()
{
Index = (UInt32Value)n
};
NumericValue numericValue = new NumericValue();
numericValue.Text = item.Value.ToString();
numericValue.Text = numericValue.Text.Replace(",", "."); // devo forzare il formato americano
numericPoints[n].Append(numericValue);
n += 1;
}
numberingCache1.Append(formatCode1);
numberingCache1.Append(pointCount3);
for (int i = 0; i < n; i++)
{
numberingCache1.Append(numericPoints[i]);
}
numberReference1.Append(formula3);
numberReference1.Append(numberingCache1);
values1.Append(numberReference1);
}