使用Javascript ASP.NetC在Excel中导出Google Chart# [英] Export Google Chart in Excel using Javascript ASP.NetC#
本文介绍了使用Javascript ASP.NetC在Excel中导出Google Chart#的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我在网络应用程序中使用谷歌图表。我想在Excel中导出Google Chart。 Google Chart提供图像数据作为数据:image / png后跟编码字符串(data:image / png; base64,iVBO ...)。它很容易用HTML和PDF(使用JsPDF)呈现,但不能在使用html的excel导出中工作。请帮助我。
Hi all,
I am using Google Chart in a web Application. I want to export Google Chart in Excel. Google Chart Provides Image Data as data:image/png followed by coded string ("data:image/png;base64,iVBO…" ). It is easily rendered in HTML and PDF(using JsPDF ) but not working in excel export using html. Please Assist me.
推荐答案
我已经解决了。对于图像URI数据base64,保存在文件中,然后像往常一样调用文件导出excel。
保存文件:
public string CreateImage(string data)
{
string fname = Server.MapPath(" data) -image")+" // chart.png";
var base64Data = Regex.Match(data,@" data:image /(?< type>。+?),( ?< data>。+)")。Groups [" data"]。Value;
var binData = Convert.FromBase64String(base64Data);
using( var stream = new MemoryStream(binData))
{
System.Drawing.Bitmap img = new Bitmap(stream);
img.Save (fname,System.Drawing.Imaging.ImageFormat.Png);
}
返回fname;
}
:)
I have resolved it. For Image URI Data base64, saved in a file and then called the file as usual to export in excel.
To Save File:
public string CreateImage(string data)
{
string fname = Server.MapPath("data-image") + "//chart.png";
var base64Data = Regex.Match(data, @"data:image/(?<type>.+?),(?<data>.+)").Groups["data"].Value;
var binData = Convert.FromBase64String(base64Data);
using (var stream = new MemoryStream(binData))
{
System.Drawing.Bitmap img = new Bitmap(stream);
img.Save(fname, System.Drawing.Imaging.ImageFormat.Png);
}
return fname;
}
:)
这篇关于使用Javascript ASP.NetC在Excel中导出Google Chart#的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文