A ChartSheet represents a chart sheet. It is a worksheet that contains only a chart. This article will demonstrate how to convert a chart sheet to SVG stream by using Spire.XLS.
Firstly, view the sample Excel worksheets with two chart sheets.
Convert all the chart sheets to SVG stream:
using System.Drawing.Imaging;
using System.IO;
namespace Convert
{
class Program
{
static void Main(string[] args)
{
//load the document from file
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
//call ToSVGStream(Stream stream) method to save each chart sheet to SVG stream
for (int i = 0; i < workbook.Chartsheets.Count; i++)
{
FileStream fs = new FileStream(string.Format("chartsheet-{0}.svg", i), FileMode.Create);
workbook.Chartsheets[i].ToSVGStream(fs);
fs.Flush();
fs.Close();
}
}
}
}
Effective screenshot of the two chart sheets to SVG.
using System.Drawing.Imaging;
using System.IO;
namespace Convert
{
class Program
{
static void Main(string[] args)
{
//load the document from file
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
//get the second chartsheet by name
ChartSheet cs = workbook.GetChartSheetByName("Chart2");
//save to SVG stream
FileStream fs = new FileStream(string.Format("chart2.svg"), FileMode.Create);
cs.ToSVGStream(fs);
fs.Flush();
fs.Close();
}
}
}
