java xslt 导出excel_利用xslt导出复杂样式的excel,支持多个worksheet

DataSet ds =tb.GetPageData(windcode, startdate, market);

ExportHelper.exportDataSet(ds,"PeriodDiff", "Book导出测试", this);

ds包含两个datatable,每一个为一个worksheet对应的datatable,DataSet名称为"DsBrief",两个DataTable为"TradeBrief","StandardContact"

public static void exportDataSet(DataSet ds, string xsltName,stringcnName, System.Web.UI.Page page)

{

MemoryStream dataStream= newMemoryStream();

ds.Namespace= "";

ds.WriteXml(dataStream);

doExport(dataStream, xsltName, cnName, page);

}public static void doExport(Stream dataStream, string xsltName, stringcnName, System.Web.UI.Page page)

{

MemoryStream outStream= newMemoryStream();

dataStream.Position= 0;

XmlReader reader=XmlReader.Create(dataStream);

XslCompiledTransform xTrans= newXslCompiledTransform();