Sisipkan Checkboxes, Masukan Teks, atau Gambar
Mesin penggabungan mengambil dokumen sebagai masukan, mencari bidang MERGEFIELD
di dalamnya, dan menggantinya dengan data yang diperoleh dari sumber data. Biasanya, teks biasa dan HTML disisipkan, tetapi pengguna Aspose.Words juga dapat membuat dokumen yang menangani skenario yang lebih tidak biasa untuk bidang Mail Merge.
Fungsionalitas Aspose.Words yang kuat memungkinkan Anda untuk memperpanjang proses Mail Merge:
- sisipkan checkboxes dan kolom formulir masukan teks ke dalam dokumen selama mail merge
- sisipkan gambar dari penyimpanan khusus apa pun (file, bidang BLOB, dll.)
Sisipkan Checkbox es dan Masukan Teks selama Mail Merge
Terkadang perlu untuk melakukan operasi Mail Merge agar bukan teks yang diganti di bidang gabungan, tetapi checkbox atau bidang input teks. Meskipun ini bukan skenario yang paling umum, ini sangat berguna untuk beberapa tugas.
Tangkapan layar berikut dari dokumen Word menunjukkan templat dengan bidang gabungan:

Tangkapan layar dokumen Word di bawah ini menunjukkan dokumen yang sudah dibuat:

Subject
diganti dengan bidang input teks.
Contoh kode berikut menunjukkan cara menyisipkan checkbox es dan memasukkan bidang teks ke dalam dokumen selama mail merge:
// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git. | |
Document doc = new Document(MyDir + "Mail merge destinations - Fax.docx"); | |
// Setup mail merge event handler to do the custom work. | |
doc.MailMerge.FieldMergingCallback = new HandleMergeField(); | |
// Trim trailing and leading whitespaces mail merge values. | |
doc.MailMerge.TrimWhitespaces = false; | |
string[] fieldNames = { | |
"RecipientName", "SenderName", "FaxNumber", "PhoneNumber", | |
"Subject", "Body", "Urgent", "ForReview", "PleaseComment" | |
}; | |
object[] fieldValues = { | |
"Josh", "Jenny", "123456789", "", "Hello", | |
"<b>HTML Body Test message 1</b>", true, false, true | |
}; | |
doc.MailMerge.Execute(fieldNames, fieldValues); | |
doc.Save(ArtifactsDir + "WorkingWithFields.MailMergeFormFields.docx"); |
// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git. | |
private class HandleMergeField : IFieldMergingCallback | |
{ | |
/// <summary> | |
/// This handler is called for every mail merge field found in the document, | |
/// for every record found in the data source. | |
/// </summary> | |
void IFieldMergingCallback.FieldMerging(FieldMergingArgs e) | |
{ | |
if (mBuilder == null) | |
mBuilder = new DocumentBuilder(e.Document); | |
// We decided that we want all boolean values to be output as check box form fields. | |
if (e.FieldValue is bool) | |
{ | |
// Move the "cursor" to the current merge field. | |
mBuilder.MoveToMergeField(e.FieldName); | |
string checkBoxName = $"{e.FieldName}{e.RecordIndex}"; | |
mBuilder.InsertCheckBox(checkBoxName, (bool) e.FieldValue, 0); | |
return; | |
} | |
switch (e.FieldName) | |
{ | |
case "Body": | |
mBuilder.MoveToMergeField(e.FieldName); | |
mBuilder.InsertHtml((string) e.FieldValue); | |
break; | |
case "Subject": | |
{ | |
mBuilder.MoveToMergeField(e.FieldName); | |
string textInputName = $"{e.FieldName}{e.RecordIndex}"; | |
mBuilder.InsertTextInput(textInputName, TextFormFieldType.Regular, "", (string) e.FieldValue, 0); | |
break; | |
} | |
} | |
} | |
void IFieldMergingCallback.ImageFieldMerging(ImageFieldMergingArgs args) | |
{ | |
args.ImageFileName = "Image.png"; | |
args.ImageWidth.Value = 200; | |
args.ImageHeight = new MergeFieldImageDimension(200, MergeFieldImageDimensionUnit.Percent); | |
} | |
private DocumentBuilder mBuilder; | |
} |
Sisipkan Gambar selama Mail Merge
Saat melakukan operasi Mail Merge, Anda dapat menyisipkan gambar dari database ke dalam dokumen menggunakan bidang gambar khusus Mail Merge. Bidang image Mail Merge adalah bidang gabungan bernama Image: MyFieldName.
Menyisipkan Gambar dari Database
Selama mail merge, saat bidang image Mail Merge ditemukan dalam dokumen, peristiwa FieldMergingCallback diaktifkan. Anda dapat menanggapi peristiwa ini untuk mengembalikan nama file, aliran, atau objek gambar ke mesin Mail Merge sehingga dapat disisipkan ke dalam dokumen.
Contoh kode berikut menunjukkan cara menyisipkan gambar yang disimpan dalam bidang database BLOB ke dalam laporan:
// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git. | |
Document doc = new Document(MyDir + "Mail merge destination - Northwind employees.docx"); | |
doc.MailMerge.FieldMergingCallback = new HandleMergeImageFieldFromBlob(); | |
string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + DatabaseDir + "Northwind.accdb"; | |
OleDbConnection conn = new OleDbConnection(connString); | |
conn.Open(); | |
OleDbCommand cmd = new OleDbCommand("SELECT * FROM Employees", conn); | |
IDataReader dataReader = cmd.ExecuteReader(); | |
doc.MailMerge.ExecuteWithRegions(dataReader, "Employees"); | |
conn.Close(); | |
doc.Save(ArtifactsDir + "WorkingWithFields.MailMergeImageFromBlob.docx"); |
// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git. | |
public class HandleMergeImageFieldFromBlob : IFieldMergingCallback | |
{ | |
void IFieldMergingCallback.FieldMerging(FieldMergingArgs args) | |
{ | |
// Do nothing. | |
} | |
/// <summary> | |
/// This is called when mail merge engine encounters Image:XXX merge field in the document. | |
/// You have a chance to return an Image object, file name, or a stream that contains the image. | |
/// </summary> | |
void IFieldMergingCallback.ImageFieldMerging(ImageFieldMergingArgs e) | |
{ | |
// The field value is a byte array, just cast it and create a stream on it. | |
MemoryStream imageStream = new MemoryStream((byte[]) e.FieldValue); | |
// Now the mail merge engine will retrieve the image from the stream. | |
e.ImageStream = imageStream; | |
} | |
} |
Setel Properti Gambar selama Mail Merge
Saat menggabungkan bidang penggabungan gambar, terkadang Anda mungkin perlu mengontrol berbagai properti gambar, seperti WrapType.
Saat ini, menggunakan ImageFieldMergingArgs Anda hanya dapat mengatur properti lebar atau tinggi gambar. Untuk mengatasi masalah ini, Aspose.Words menyediakan properti Shape, yang memudahkan untuk mendapatkan kontrol penuh atas gambar yang disisipkan atau bentuk lainnya.
Contoh kode berikut menunjukkan cara mengatur berbagai properti gambar:
// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git. | |
Document doc = new Document(); | |
DocumentBuilder builder = new DocumentBuilder(doc); | |
builder.Writeln("{{#foreach example}}"); | |
builder.Writeln("{{Image(126pt;126pt):stempel}}"); | |
builder.Writeln("{{/foreach example}}"); | |
doc.MailMerge.UseNonMergeFields = true; | |
doc.MailMerge.TrimWhitespaces = true; | |
doc.MailMerge.UseWholeParagraphAsRegion = false; | |
doc.MailMerge.CleanupOptions = MailMergeCleanupOptions.RemoveEmptyTableRows | |
| MailMergeCleanupOptions.RemoveContainingFields | |
| MailMergeCleanupOptions.RemoveUnusedRegions | |
| MailMergeCleanupOptions.RemoveUnusedFields; | |
doc.MailMerge.FieldMergingCallback = new ImageFieldMergingHandler(); | |
doc.MailMerge.ExecuteWithRegions(new DataSourceRoot()); | |
doc.Save(ArtifactsDir + "WorkingWithFields.MailMergeImageField.docx"); |
// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git. | |
private class ImageFieldMergingHandler : IFieldMergingCallback | |
{ | |
void IFieldMergingCallback.FieldMerging(FieldMergingArgs args) | |
{ | |
// Implementation is not required. | |
} | |
void IFieldMergingCallback.ImageFieldMerging(ImageFieldMergingArgs args) | |
{ | |
Shape shape = new Shape(args.Document, ShapeType.Image) | |
{ | |
Width = 126, Height = 126, WrapType = WrapType.Square | |
}; | |
shape.ImageData.SetImage(MyDir + "Mail merge image.png"); | |
args.Shape = shape; | |
} | |
} |
// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET.git. | |
public class DataSourceRoot : IMailMergeDataSourceRoot | |
{ | |
public IMailMergeDataSource GetDataSource(string s) | |
{ | |
return new DataSource(); | |
} | |
private class DataSource : IMailMergeDataSource | |
{ | |
private bool next = true; | |
string IMailMergeDataSource.TableName => TableName(); | |
private string TableName() | |
{ | |
return "example"; | |
} | |
public bool MoveNext() | |
{ | |
bool result = next; | |
next = false; | |
return result; | |
} | |
public IMailMergeDataSource GetChildDataSource(string s) | |
{ | |
return null; | |
} | |
public bool GetValue(string fieldName, out object fieldValue) | |
{ | |
fieldValue = null; | |
return false; | |
} | |
} | |
} |