TMS FlexCel Studio for.NET是一款100%托管代碼的Excel文件處理引擎和.NET、Xamarin.iOS、Xamarin.Android、Xamarin.Mac環(huán)境下的Excel、PDF格式報(bào)表生成器。
【TMS Flexcel Studio for .NET v6.26全新升級(jí) | 最新版下載】
概觀
為了方便起見，這里的大多數(shù)演示使用的數(shù)據(jù)集將作為數(shù)據(jù)源。因?yàn)樵?NET 2.0中不支持Linq，如果我們使用Linq，這些演示將不適用于所有人，而且焦點(diǎn)在Excel模板中，而不是在數(shù)據(jù)層中。但是您可以將任何IQueryable< T >集合用作FlexCel報(bào)表中的數(shù)據(jù)源，這是我們將在此處顯示的內(nèi)容。
所示概念
當(dāng)詳細(xì)信息嵌套在主服務(wù)器內(nèi)的多個(gè)級(jí)別時(shí)，如何執(zhí)行master-detail報(bào)表。
- 在這種情況下，Country類具有People類，People類具有Language對(duì)象列表。如果People是Country里面的List < >且你想使用該列表，你只需要定義一個(gè)__People__帶（這將在Linq示例中顯示）。但是由于List < >在People內(nèi)，而People又在Country內(nèi)，因此你需要定義一個(gè)__People.Language__ band。
如何使用[square brackets]引用帶點(diǎn)的表格。
- 如果你寫一個(gè)單元格< #tablename.section.field> FlexCel將此解釋為表“tablename”，字段“section.field”。直到第一個(gè)點(diǎn)的文本始終是表，其余的是字段。
- 有時(shí)您可能希望將其解釋為表“tablename.section”，字段“field”。為此，您需要編寫< #[tablename.section].field>。在這種特殊情況下，我們有一個(gè)表“People.Language”，在前一點(diǎn)中定義了它。如果我們?cè)趩卧馚1中寫道：“< #people.language.speakers.percen>FlexCel會(huì)解釋這是表“people”，而不是“people.language”，這就是我們需要的。讓FlexCel明白我們想要一張表< #[people.language] .speakers.percent>
Files
AssemblyInfo.cs
using System.Reflection;
using System.Runtime.CompilerServices;
//
// General Information about an assembly is controlled through the following
// set of attributes. Change these attribute values to modify the information
// associated with an assembly.
//
[assembly: AssemblyTitle("")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("")]
[assembly: AssemblyProduct("")]
[assembly: AssemblyCopyright("(c) 2002 - 2019 TMS Software")]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCulture("")]
//
// Version information for an assembly consists of the following four values:
//
// Major Version
// Minor Version
// Build Number
// Revision
//
// You can specify all the values or you can default the Revision and Build Numbers
// by using the '*' as shown below:
[assembly: AssemblyVersion("6.26.0.0")]
//
// In order to sign your assembly you must specify a key to use. Refer to the
// Microsoft .NET Framework documentation for more information on assembly signing.
//
// Use the attributes below to control which key is used for signing.
//
// Notes:
// (*) If no key is specified, the assembly is not signed.
// (*) KeyName refers to a key that has been installed in the Crypto Service
// Provider (CSP) on your machine. KeyFile refers to a file which contains
// a key.
// (*) If the KeyFile and the KeyName values are both specified, the
// following processing occurs:
// (1) If the KeyName can be found in the CSP, that key is used.
// (2) If the KeyName does not exist and the KeyFile does exist, the key
// in the KeyFile is installed into the CSP and used.
// (*) In order to create a KeyFile, you can use the sn.exe (Strong Name) utility.
// When specifying the KeyFile, the location of the KeyFile should be
// relative to the project output directory which is
// %Project Directory%\obj\. For example, if your KeyFile is
// located in the project directory, you would specify the AssemblyKeyFile
// attribute as [assembly: AssemblyKeyFile("..\\..\\mykey.snk")]
// (*) Delay Signing is an advanced option - see the Microsoft .NET Framework
// documentation for more information on this.
//
[assembly: AssemblyDelaySign(false)]
[assembly: AssemblyKeyFile("")]
[assembly: AssemblyKeyName("")]Form1.cs
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.IO;
using System.Diagnostics;
using System.Reflection;
using FlexCel.Core;
using FlexCel.XlsAdapter;
using FlexCel.Report;
using System.Collections.Generic;
using System.Linq;
namespace AdvancedLinq
{
/// /// Summary description for Form1.
/// public partial class mainForm : System.Windows.Forms.Form
{
public mainForm()
{
InitializeComponent();
}
private void button1_Click(object sender, System.EventArgs e)
{
AutoRun();
}
public void AutoRun()
{
using (FlexCelReport report = new FlexCelReport(true))
{
LoadTables(report);
string DataPath = Path.Combine(Path.Combine(Path.GetDirectoryName(Assembly.
GetExecutingAssembly().Location), ".."), "..") + Path.DirectorySeparatorChar;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
report.Run(DataPath + "Advanced Linq.template.xlsx", saveFileDialog1.FileName);
if (MessageBox.Show("Do you want to open the generated file?", "Confirm",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Process.Start(saveFileDialog1.FileName);
}
}
}
}
private void LoadTables(FlexCelReport report)
{
var Countries = new List();
Countries.Add(new Country("China",
new People(1384688986),
new Geography(
new Area(270550, 9326410))));
var country = Countries[Countries.Count - 1];
country.People.Language.Add(new Language(
new LanguageName("Md", "Mandarin"),
new LanguageSpeakers(0, 66.2)));
country.People.Language.Add(new Language(
new LanguageName("Yue", "Yue"),
new LanguageSpeakers(0, 4.9)));
country.People.Language.Add(new Language(
new LanguageName("Wu", "Wu"),
new LanguageSpeakers(0, 6.1)));
country.People.Language.Add(new Language(
new LanguageName("Mb", "Minbei"),
new LanguageSpeakers(0, 6.2)));
country.People.Language.Add(new Language(
new LanguageName("Mn", "Minnan"),
new LanguageSpeakers(0, 5.2)));
country.People.Language.Add(new Language(
new LanguageName("Xi", "Xiang"),
new LanguageSpeakers(0, 3.0)));
country.People.Language.Add(new Language(
new LanguageName("Gan", "Gan"),
new LanguageSpeakers(0, 4.0)));
Countries.Add(new Country("India",
new People(1296834042),
new Geography(
new Area(314070, 2973193))));
country = Countries[Countries.Count - 1];
country.People.Language.Add(new Language(
new LanguageName("Hi", "Hindi"),
new LanguageSpeakers(0, 43.6)));
country.People.Language.Add(new Language(
new LanguageName("Bg", "Bengali"),
new LanguageSpeakers(0, 8)));
country.People.Language.Add(new Language(
new LanguageName("Ma", "Marath"),
new LanguageSpeakers(0, 6.9)));
country.People.Language.Add(new Language(
new LanguageName("Te", "Telugu"),
new LanguageSpeakers(0, 6.7)));
country.People.Language.Add(new Language(
new LanguageName("Ta", "Tamil"),
new LanguageSpeakers(0, 5.7)));
country.People.Language.Add(new Language(
new LanguageName("Gu", "Gujarati"),
new LanguageSpeakers(0, 4.6)));
country.People.Language.Add(new Language(
new LanguageName("Ur", "Urdu"),
new LanguageSpeakers(0, 4.2)));
country.People.Language.Add(new Language(
new LanguageName("Ka", "Kannada"),
new LanguageSpeakers(0, 3.6)));
country.People.Language.Add(new Language(
new LanguageName("Od", "Odia"),
new LanguageSpeakers(0, 3.1)));
country.People.Language.Add(new Language(
new LanguageName("Ma", "Malayalam"),
new LanguageSpeakers(0, 2.9)));
country.People.Language.Add(new Language(
new LanguageName("Pu", "Punjabi"),
new LanguageSpeakers(0, 2.7)));
country.People.Language.Add(new Language(
new LanguageName("As", "Assamese"),
new LanguageSpeakers(0, 1.3)));
country.People.Language.Add(new Language(
new LanguageName("Mi", "Maithili"),
new LanguageSpeakers(0, 1.1)));
country.People.Language.Add(new Language(
new LanguageName("O", "Other"),
new LanguageSpeakers(0, 5.6)));
Countries.Add(new Country("United States",
new People(329256465),
new Geography(
new Area(685924, 9147593))));
country = Countries[Countries.Count - 1];
country.People.Language.Add(new Language(
new LanguageName("En", "English"),
new LanguageSpeakers(0, 78.2)));
country.People.Language.Add(new Language(
new LanguageName("Sp", "Spanish"),
new LanguageSpeakers(0, 13.4)));
country.People.Language.Add(new Language(
new LanguageName("Ch", "Chinese"),
new LanguageSpeakers(0, 1.1)));
country.People.Language.Add(new Language(
new LanguageName("O", "Other"),
new LanguageSpeakers(0, 7.3)));
report.AddTable("country", Countries );
}
private void btnCancel_Click(object sender, System.EventArgs e)
{
Close();
}
}
public class Country
{
public string Name { get; private set; }
public People People { get; set; }
public Geography Geography { get; set; }
public Country(string name, People people, Geography geography)
{
this.Name = name;
this.People = people;
this.Geography = geography;
}
}
public class Geography
{
public Area Area { get; private set; }
public Geography(Area area)
{
this.Area = area;
}
}
public class Area
{
public int Total { get { return Water + Land; } }
public int Water { get; private set; }
public int Land { get; private set; }
public Area(int water, int land)
{
this.Water = water;
this.Land = land;
}
}
public class People
{
public int Population { get; private set; }
public List Language { get; private set; }
public People(int population)
{
this.Population = population;
this.Language = new List();
}
}
public class Language
{
public LanguageName Name { get; private set; }
public LanguageSpeakers Speakers { get; private set; }
public Language(LanguageName name, LanguageSpeakers speakers)
{
this.Name = name;
this.Speakers = speakers;
}
}
public class LanguageName
{
public string ShortName { get; private set; }
public string LongName { get; private set; }
public LanguageName(string shortName, string longName)
{
this.ShortName = shortName;
this.LongName = longName;
}
}
public class LanguageSpeakers
{
public int AbsoluteNumber { get; private set; }
public double Percent { get; private set; }
public LanguageSpeakers(int absoluteNumber, double percent)
{
this.AbsoluteNumber = absoluteNumber;
this.Percent = percent / 100.0;
}
}
}Form1.Designer.cs
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.IO;
using System.Diagnostics;
using System.Reflection;
using FlexCel.Core;
using FlexCel.XlsAdapter;
using FlexCel.Report;
namespace AdvancedLinq
{
public partial class mainForm : System.Windows.Forms.Form
{
private System.Windows.Forms.Button button1;
private System.Windows.Forms.SaveFileDialog saveFileDialog1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button btnCancel;
/// /// Required designer variable.
/// private System.ComponentModel.Container components = null;
/// /// Clean up any resources being used.
/// protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// /// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// private void InitializeComponent()
{
this.button1 = new System.Windows.Forms.Button();
this.saveFileDialog1 = new System.Windows.Forms.SaveFileDialog();
this.label1 = new System.Windows.Forms.Label();
this.btnCancel = new System.Windows.Forms.Button();
this.SuspendLayout();
//
// button1
//
this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.
AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.button1.BackColor = System.Drawing.Color.Green;
this.button1.ForeColor = System.Drawing.Color.White;
this.button1.Location = new System.Drawing.Point(152, 88);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(112, 23);
this.button1.TabIndex = 0;
this.button1.Text = "GO!";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// saveFileDialog1
//
this.saveFileDialog1.Filter = "Excel Files|*.xlsx";
this.saveFileDialog1.RestoreDirectory = true;
//
// label1
//
this.label1.Location = new System.Drawing.Point(24, 24);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(272, 24);
this.label1.TabIndex = 2;
this.label1.Text = "Press \"GO\" to create a report from a List<> of objects.";
//
// btnCancel
//
this.btnCancel.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.
Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnCancel.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))),
((int)(((byte)(0)))), ((int)(((byte)(0)))));
this.btnCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.btnCancel.ForeColor = System.Drawing.Color.White;
this.btnCancel.Location = new System.Drawing.Point(272, 88);
this.btnCancel.Name = "btnCancel";
this.btnCancel.Size = new System.Drawing.Size(112, 23);
this.btnCancel.TabIndex = 3;
this.btnCancel.Text = "Cancel";
this.btnCancel.UseVisualStyleBackColor = false;
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// mainForm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(416, 133);
this.Controls.Add(this.btnCancel);
this.Controls.Add(this.label1);
this.Controls.Add(this.button1);
this.Name = "mainForm";
this.Text = "Advanced Linq Reports";
this.ResumeLayout(false);
}
#endregion
}
}Program.cs
using System;
using System.Windows.Forms;
namespace AdvancedLinq
{
static class Program
{
/// /// The main entry point for the application.
/// [STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new mainForm());
}
}
}【注：本演示需要.NET 3.5或更新版本。】
購(gòu)買TMS Flexcel Studio for .NET v6.26正版授權(quán)的朋友可以點(diǎn)擊""哦~~~
標(biāo)簽：
本站文章除注明轉(zhuǎn)載外，均為本站原創(chuàng)或翻譯。歡迎任何形式的轉(zhuǎn)載，但請(qǐng)務(wù)必注明出處、不得修改原文相關(guān)鏈接，如果存在內(nèi)容上的異議請(qǐng)郵件反饋至chenjj@ke049m.cn
半島外圍網(wǎng)上直營(yíng) 
11次
相關(guān)產(chǎn)品
正式授權(quán)
最新文章 
半島外圍網(wǎng)上直營(yíng)相關(guān)的文章 
微信
在線咨詢
渝公網(wǎng)安備
50010702500608號(hào)
客服熱線