作者：Danny邓lovestars | 来源：互联网 | 2023-09-14 18:13
publicstaticNPOI.XWPF.UserModel.XWPFDocumentCreatebar(Stringcountent,Dictionary<String,
public static NPOI.XWPF.UserModel.XWPFDocument Createbar(String countent,Dictionary> datas, IList legend, XWPFDocument m_Docx, ST_LegendPos legendLocal, int w, int h, String title)
{
//页面设置
//A4:W=11906,h=16838
//CT_SectPr m_SectPr = m_Docx.Document.body.AddNewSectPr();
//m_Docx.Document.body.sectPr = new CT_SectPr();
//CT_SectPr m_SectPr = m_Docx.Document.body.sectPr;
//页面设置A4横向
//m_SectPr.pgSz.w = (ulong)16838;
//m_SectPr.pgSz.h = (ulong)11906;
//创建页脚
//CT_Ftr m_ftr = new CT_Ftr();
//m_ftr.AddNewP().AddNewR().AddNewT().Value = "fff";//页脚内容
//创建页脚关系（footern.xml）
//XWPFRelation Frelation = XWPFRelation.FOOTER;
//XWPFFooter m_f = (XWPFFooter)m_Docx.CreateRelationship(Frelation, XWPFFactory.GetInstance(), m_Docx.FooterList.Count + 1);
//设置页脚
//m_f.SetHeaderFooter(m_ftr);
//CT_HdrFtrRef m_HdrFtr = m_SectPr.AddNewFooterReference();
//m_HdrFtr.type = ST_HdrFtr.@default;
//m_HdrFtr.id = m_f.GetPackageRelationship().Id;
//创建页眉
//CT_Hdr m_Hdr = new CT_Hdr();
//m_Hdr.AddNewP().AddNewR().AddNewT().Value = "hhh";//页眉内容
//创建页眉关系（headern.xml）
//XWPFRelation Hrelation = XWPFRelation.HEADER;
// XWPFHeader m_h = (XWPFHeader)m_Docx.CreateRelationship(Hrelation, XWPFFactory.GetInstance(), m_Docx.HeaderList.Count + 1);
//设置页眉
//m_h.SetHeaderFooter(m_Hdr);
//m_HdrFtr = m_SectPr.AddNewHeaderReference();
//m_HdrFtr.type = ST_HdrFtr.@default;
//m_HdrFtr.id = m_h.GetPackageRelationship().Id;
//插入柱状图图表
//插入xlsx
//创建xlsx
XSSFWorkbook workbook = new XSSFWorkbook();
//创建表单1（柱状图）
ISheet sheet = workbook.CreateSheet("Sheet1");
//5、表单1柱状图数据
// 系列1 系列2 系列3
//类别1 4.3 2.4 2
//类别2 2.5 4.4 2
//类别3 3.5 1.8 3
//类别4 4.5 2.8 5
IRow row = sheet.CreateRow(0);
ICell cell = row.CreateCell(0);
for (int i = 0; i ();
NPOI.OpenXmlFormats.Dml.CT_TextParagraph charttp = new NPOI.OpenXmlFormats.Dml.CT_TextParagraph();
charttp.AddNewPPr().defRPr = new NPOI.OpenXmlFormats.Dml.CT_TextCharacterProperties();
NPOI.OpenXmlFormats.Dml.CT_RegularTextRun r = charttp.AddNewR();
r.rPr = new NPOI.OpenXmlFormats.Dml.CT_TextCharacterProperties();
r.rPr.lang = "zh-CN";
r.rPr.altLang = "en-US";
r.t = title;
m_chart.title.tx.rich.p.Add(charttp);
m_chart.title.overlay = new CT_Boolean();
m_chart.title.overlay.val = 0;
m_chart.autoTitleDeleted = new CT_Boolean();
m_chart.autoTitleDeleted.val = 0;
m_chart.plotArea = new CT_PlotArea();
m_chart.plotArea.AddNewLayout();
m_chart.plotArea.barChart = new List();
CT_NumVal m_barvalpt = new CT_NumVal();
CT_BarSer m_barser = new CT_BarSer();
CT_StrVal m_barpt = new CT_StrVal();
CT_BarChart m_barchart = new CT_BarChart();
m_barchart = new CT_BarChart();
m_barchart.barDir = new CT_BarDir();
m_barchart.barDir.val = ST_BarDir.col;
m_barchart.grouping = new CT_BarGrouping();
m_barchart.grouping.val = ST_BarGrouping.clustered;
m_barchart.ser = new List();
for (int i = 0; i ();
m_barpt = new CT_StrVal();
m_barpt.idx = 0;
m_barpt.v = legend[i];
m_barser.tx.strRef.strCache.pt.Add(m_barpt);
//分类标题显示
m_barser.invertIfNegative = new CT_Boolean();
m_barser.invertIfNegative.val = 0;
m_barser.cat = new CT_AxDataSource();
m_barser.cat.strRef = new CT_StrRef();
m_barser.cat.strRef.f = "Sheet1!$A$2:$A$5";
m_barser.cat.strRef.strCache = new CT_StrData();
m_barser.cat.strRef.strCache.ptCount = new CT_UnsignedInt();
m_barser.cat.strRef.strCache.ptCount.val = 4;
m_barser.cat.strRef.strCache.pt = new List();
for (int k = 0; k ();
for (int m = 0; m
*/
CT_DTable cT_DTable = new CT_DTable();
CT_Boolean ct_Boolean = new CT_Boolean();
ct_Boolean.val = 1;
cT_DTable.showHorzBorder = ct_Boolean;
cT_DTable.showVertBorder = ct_Boolean;
cT_DTable.showOutline = cT_Boolean;
cT_DTable.showKeys = cT_Boolean;
m_chart.plotArea.dTable = cT_DTable;
//柱图北背景颜色,还有问题
CT_ShapeProperties cT_ShapeProperties = new CT_ShapeProperties();
NPOI.OpenXmlFormats.Dml.CT_SolidColorFillProperties cT_SolidColorFillProperties = new NPOI.OpenXmlFormats.Dml.CT_SolidColorFillProperties();
NPOI.OpenXmlFormats.Dml.CT_SRgbColor cT_SRgbColor = new NPOI.OpenXmlFormats.Dml.CT_SRgbColor();
cT_SRgbColor.val = System.Text.Encoding.UTF8.GetBytes("F79646");
List ItemsElementName = new List();
ItemsElementName.Add(NPOI.OpenXmlFormats.Dml.EG_ColorTransform.alpha);
ItemsElementName.Add(NPOI.OpenXmlFormats.Dml.EG_ColorTransform.lumMod);
ItemsElementName.Add(NPOI.OpenXmlFormats.Dml.EG_ColorTransform.lumOff);
cT_SRgbColor.ItemsElementName = ItemsElementName;
cT_SolidColorFillProperties.srgbClr = cT_SRgbColor;
cT_ShapeProperties.solidFill = cT_SolidColorFillProperties;
//m_chart.plotArea.spPr = cT_ShapeProperties;
m_barchart.axId = new List();
CT_UnsignedInt m_axId = new CT_UnsignedInt();
m_axId.val = 57733120;
m_barchart.axId.Add(m_axId);
m_axId = new CT_UnsignedInt();
m_axId.val = 57734656;
m_barchart.axId.Add(m_axId);
m_chart.plotArea.barChart.Add(m_barchart);
m_chart.plotArea.catAx = new List();
CT_CatAx m_catAx = new CT_CatAx();
m_catAx.axId = new CT_UnsignedInt();
m_catAx.axId.val = 57733120;
m_catAx.scaling = new CT_Scaling();
m_catAx.scaling.orientation = new CT_Orientation();
m_catAx.scaling.orientation.val = ST_Orientation.minMax;
m_catAx.delete = new CT_Boolean();//分类标题
m_catAx.delete.val = 0;
m_catAx.axPos = new CT_AxPos();
m_catAx.axPos.val = ST_AxPos.b;
m_catAx.majorTickMark = new CT_TickMark();
m_catAx.majorTickMark.val = ST_TickMark.none;
m_catAx.minorTickMark = new CT_TickMark();
m_catAx.minorTickMark.val = ST_TickMark.none;
m_catAx.tickLblPos = new CT_TickLblPos();
m_catAx.tickLblPos.val = ST_TickLblPos.nextTo;
m_catAx.crossAx = new CT_UnsignedInt();
m_catAx.crossAx.val = 57733120;
m_catAx.crosses = new CT_Crosses();
m_catAx.crosses.val = ST_Crosses.autoZero;
m_catAx.auto = new CT_Boolean();
m_catAx.auto.val = 0;
m_catAx.lblAlgn = new CT_LblAlgn();
m_catAx.lblAlgn.val = ST_LblAlgn.ctr;
m_catAx.lblOffset = new CT_LblOffset();
m_catAx.lblOffset.val = 100;
m_catAx.noMultiLvlLbl = new CT_Boolean();
m_catAx.noMultiLvlLbl.val = 100;
m_chart.plotArea.catAx.Add(m_catAx);
m_chart.plotArea.valAx = new List();
CT_ValAx m_valAx = new CT_ValAx();
m_valAx.axId = new CT_UnsignedInt();
m_valAx.axId.val = 57734656;
m_valAx.scaling = new CT_Scaling();
m_valAx.scaling.orientation = new CT_Orientation();
m_valAx.scaling.orientation.val = ST_Orientation.minMax;
m_valAx.delete = new CT_Boolean();
m_valAx.delete.val = 1;
m_valAx.axPos = new CT_AxPos();
m_valAx.axPos.val = ST_AxPos.l;
m_valAx.numFmt = new NPOI.OpenXmlFormats.Dml.Chart.CT_NumFmt();
m_valAx.numFmt.formatCode = "General";
m_valAx.numFmt.sourceLinked = true;
m_valAx.majorTickMark = new CT_TickMark();
m_valAx.majorTickMark.val = ST_TickMark.none;
m_valAx.minorTickMark = new CT_TickMark();
m_valAx.minorTickMark.val = ST_TickMark.none;
m_valAx.tickLblPos = new CT_TickLblPos();
m_valAx.tickLblPos.val = ST_TickLblPos.nextTo;
m_valAx.crossAx = new CT_UnsignedInt();
m_valAx.crossAx.val = 57733120;
m_valAx.crosses = new CT_Crosses();
m_valAx.crosses.val = ST_Crosses.autoZero;
m_valAx.crossBetween = new CT_CrossBetween();
m_valAx.crossBetween.val = ST_CrossBetween.between;
m_chart.plotArea.valAx.Add(m_valAx);
//图例位置
m_chart.legend = new CT_Legend();
m_chart.legend.legendPos = new CT_LegendPos();
m_chart.legend.legendPos.val = legendLocal; //在上方
m_chart.legend.overlay = new CT_Boolean();
m_chart.legend.overlay.val = 0;
m_chart.plotVisOnly= new CT_Boolean();
m_chart.plotVisOnly.val = 1;
m_chart.dispBlanksAs = new CT_DispBlanksAs();
m_chart.dispBlanksAs.val = ST_DispBlanksAs.gap;
m_chart.showDLblsOverMax = new CT_Boolean();
m_chart.showDLblsOverMax.val = 0;
XWPFParagraph gp = m_Docx.CreateParagraph();
XWPFRun gr = gp.CreateRun();
gr.AddChartSpace(new XSSFWorkbook(new MemoryStream(bxlsxData)), ctbarchartspace, w, h);
XWPFParagraph Textgp = m_Docx.CreateParagraph();
XWPFRun Textgr = gp.CreateRun();
XWPFStyles m_styles = m_Docx.CreateStyles();
// Textgr.SetTextPosition(2);
CT_RPr rpr3 = Textgr.GetCTR().AddNewRPr();
CT_Fonts rfonts3 = rpr3.AddNewRFonts();
rfonts3.ascii = "仿宋_GB2312";
rfonts3.eastAsia = "仿宋_GB2312";
rpr3.AddNewSz().val = (ulong)30;//1号字体
rpr3.AddNewSzCs().val = (ulong)30;
Textgr.SetText(countent);
return m_Docx;
}
京公网安备 11010802041100号