1. The above code not copying the chart to SVG. It just generating Sample SVG file with out chart.Attached sample(WithoutChart.out.svg).
Note: Attached all sample files in the zip file.
Here is the code that I have written:
// The path to the documents directory.
string dataDir = Path.GetFullPath("../../../Data/");
string filePath = dataDir + "chartest.xlsm";
//Create a workbook object from the template file
Workbook book = new Workbook(filePath);
//Convert each worksheet into svg format in a single page.
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.SaveFormat = SaveFormat.SVG;
imgOptions.OnePagePerSheet = true;
WorksheetCollection wrkSheets = book.Worksheets;
Worksheet wrkBook = (Worksheet)book.Worksheets["Sheet1"];
Worksheet chartSheet = wrkSheets[wrkSheets.Add(SheetType.Chart)];
chartSheet.Name = "MyChart";
chartSheet.IsSelected = true;
//Get the first Chart from the worksheet.
Chart source = wrkBook.Charts[0];
Shape cshape = source.ChartObject;
//Copy the Chart to the Result Worksheet
chartSheet.Shapes.AddCopy(cshape, 20, 0, 2, 0);
SheetRender sr = new SheetRender(chartSheet, imgOptions);
for (int i = 0; i < sr.PageCount; i++)
{
//Output the worksheet into Svg image format
sr.ToImage(i, filePath + chartSheet.Name + i + System.DateTime.Now.ToFileTime() + ".out.svg");
}
2. Secondly, while saving selected area as SVG it looks like it is saving along with entire work sheet length. In the SVG output it is generating extra spaces other than expected Image.
Attached the sample(ChartwithExtraSpace.out.svg). (We would like to display the converted SVG Image on other website that time it is rendering with extra space as same Excel Sheet length)
Here is the code that I have written:
// The path to the documents directory.
string dataDir = Path.GetFullPath("../../../Data/");
string filePath = dataDir + "Template.xlsx";
//Create a workbook object from the template file
Workbook book = new Workbook(filePath);
//Convert each worksheet into svg format in a single page.
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.SaveFormat = SaveFormat.SVG;
imgOptions.OnePagePerSheet = true;
//Convert each worksheet into svg format
foreach (Worksheet sheet in book.Worksheets)
{
//Obtaining the reference of the PageSetup of the worksheet
PageSetup pageSetup = sheet.PageSetup;
//Specifying the cells range (from A1 cell to T35 cell) of the print area
pageSetup.PrintArea = "A13:H31";
SheetRender sr = new SheetRender(sheet, imgOptions);
for (int i = 0; i < sr.PageCount; i++)
{
//Output the worksheet into Svg image format
sr.ToImage(i, filePath + sheet.Name + i + System.DateTime.Now.ToFileTime() + ".out.svg");
}
}