// Create a png file stream FileStream outputStream = new FileStream("ExportChartToImage.png", FileMode.Create); //create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); Stream fileStream = this.GetResourceStream("xlsx\\Template_SalesTracker_report.xlsx"); //Open a xlsx file contains a chart workbook.Open(fileStream); IWorksheet worksheet = workbook.Worksheets[0]; //Export the chart to image worksheet.Shapes["ProductIncomeChart"].ToImage(outputStream, ImageType.PNG); // Close the image stream outputStream.Close();
' Create a png file stream Dim outputStream = File.Create("ExportChartToImage.png") ' Create a new Workbook Dim workbook As New Workbook Dim fileStream As Stream = GetResourceStream("Template_SalesTracker_report.xlsx") ' Open a xlsx file contains a chart workbook.Open(fileStream) Dim worksheet As IWorksheet = workbook.Worksheets(0) ' Export the chart to image worksheet.Shapes("ProductIncomeChart").ToImage(outputStream, ImageType.PNG) ' close the image stream outputStream.Close()